|
SEARCH/MODIFY
Search/modify function provides the ability to search records inside a table using search criteria, edit one by one selected group of records, delete selected group of records, insert new record into the table.
SEARCH RECORDS page displays HTML forms against the column names, where the user inserts arguments (search patterns) and search criteria and chooses the display result options. If multiple arguments are used they must be separated by comma.
The following search criteria are available:
|
SEARCH CRITERIA
|
MATCH
|
NUMBER OF ARGUMENTS
|
|
no criteria
|
fields containing the argument ('%argument%')
|
One (phrase)
|
|
Starts with
|
field value starts with any argument ('arg1%' OR 'arg2%' OR 'arg3%', ...)
|
|
|
Ends with
|
The field value ends with any argument ('%arg1' OR '%arg2' OR '%arg3', ...)
|
|
|
AND
|
The field contains all the arguments ('%arg1%' AND '%arg2%' AND '%arg3%', ...)
|
Two or more
|
|
OR
|
The field contains any argument ('%arg1%' OR '%arg2%' OR '%arg3%', ...)
|
Two or more
|
|
>, <, =
|
Field value is more, less or equal to argument
|
One
|
|
BETWEEN
|
Field content is more or equal than first, and less or equal than second argument
|
Two
|
|
IN
|
match if the field content is one of the values in the list (val1, val2, val3 ...)
|
Two or more
|
|
NULL
|
Matched field should be NULL
|
No
|
Search options:
'NOT' - inverts search criteria
'Match case' - performs case sensitive search (or binary)
NOTE: 'Match case' is supported by Mysql server of version 3.23.00 and higher. This option will not be displayed if the version of the installed Mysql server is prior 3.23.00
Display options:
'Sort by'- defines the column to sort the search result by,
'Sort order' - defines the displaying order - ascending or descending,
'Start' - defines the row number displaying the result will start from,
'Hits' - defines the number of hits per page,
'Show columns' - defines the columns that will be displayed in the search result.
Search result:
' Search result' page displays the rows that match search criteria.
Here we can select one or more rows to be edited or deleted, or print the result.
The user will be prompted to confirm the deletion of the selected rows.
If two or more rows are selected to be edited, they are being edited one by one. The next row will be displayed on the 'Edit' page as the editing of the previous one is done, until the last row is edited. The program will return back to the search result page then.
If the currently selected row should not be edited, just press SUBMIT button, the program will not generate the 'UPDATE statement if nothing was changed in the displayed fields. Or press "Back to search result" and select new set of rows to be edited.
Unquoted data checkboxes are used to insert SQL functions into the fields. For example, if we need to insert encrypted password into a field we must check the "Unquoted data" and then type PASSWORD('password ') in the field form.
To print the result select the following printing options:
- Print full result or displayed hits only.
- Enter the page title as the header of the printout.
- Title style (Bolt, Italic and Underlined).
- Title alignment: Left, Right or Center.
- Height of the table header and height of the table rows: (min., 20 pixel, 30 pixel).
|
