Tips
Umlauts/UTF-8
Normalization
OemToAnsi
MySQL Import
Site Search
City Desk
DynDNS
MXLookup
SPAM
Support
Downloads
Contact Us
Locate and Filter
SqlDBU offers two different options for data search within a selected
Table: Positioning the record pointer to the first (next) row matching the search criteria (LOCATE) or record filtering (FILTER).
In both cases column associated keywords have to be entered into topmost
row of the table. More then one given keywords will be combined by logical
AND.Sample (selected table demo)
SqlDBU generates for keyword "M" entered into column LAST and "840"
into column COUNTRY following SQL statement:
SELECT * FROM demo WHERE LAST LIKE 'M%' AND COUNTRY=840
Note: Keywords for character based (non numeric) columns imply compare operations beginning with first character of the column value. See SQL statement above which could be translated like:
"Find all records where column LAST begins with 'M' and column COUNTRY equals 840."
Click here in order to see the result. You can remove the filter by clicking Delete Filter.
For full text search within the appropriate column SqlDBU supports the
keyword prefix "*".
The modified version of the sample above (keyword "*M" for column LAST) results into following statement:
SELECT * FROM demo WHERE LAST LIKE '%M%' AND COUNTRY=840
Translation: "Find all records where column LAST contains 'M' and column COUNTRY equals 840."
This time the result looks like follows.
SeekView
SqlDBU by default generates single line text input field for each selected
column. This does not make that much sense for columns containing numeric
codes pointing into child tables unless these codes are easy to remember.
For columns like that an optional list box with all possible strings representing the appropriate codes is a much better idea. Therefore keyword input can be customized at column level by SEEKVIEW=... entries (similar to the FORMVIEW=... form definition):[DEMO.COUNTRY]
...
SEEKVIEW=<!---DATABASE-country---> \
<select name="COUNTRY"> \
<option value=""> </option> \
<!---startlist---> \
<option value="-COUNTRY.COUNTRY-">-COUNTRY.ENG-</option> \
<!---endlist---> \
</select>Now it looks like follows:
Back
