|
TurboDB Engine Documentation Full-Text Search-Conditions |
| Previous Top Next |
Full-text search-conditions are used with the TurboSQL contains predicate and the VCL TTdbTable.WordFilter property. A full-text search-condition is basically a list of keywords, separated by "+", "," or "-". These characters mean:
, or space |
both keywords must occur in the record |
+ or / |
one of the keywords must occur in the record |
- |
the keyword must not occur in the record |
The alternate character (space and slash) are only available as of table level 4. The keyword itself can contain the jokers "?" and "*" to represent any single character or any substring respectively.
Examples
Database |
Finds Database, database, dataBase, ... |
Database* |
Finds database, Databases, DatabaseDriver, ... |
Data?ase |
Finds Database, dataCase, ... |
Database, Driver |
Record must contain the words Database and Driver |
Database Driver |
Same as above for table level 4 |
Database, Driver, ODBC |
Record must contain the words Database, Driver and ODBC |
Database Driver ODBC |
Same as above for table level 4 |
Database + Driver |
Record must contain either the word Database or the word Driver or both |
Database/Driver |
Same as above for table level 4 |
Database + Driver + ODBC |
Record must contain either the word Database or the word Driver or the word ODBC |
Database/Driver/ODBC |
Same as above for table level 4 |
Database Driver ODBC/OLE |
Record must contain the word Database and the word Driver and either the word ODBC or the word OLE |
-Database |
Record must not contain the word Database |
Database - Driver |
Record must contain the word Database but not the word Driver |
Compatibility Information
TurboPL is supported only for backward compatibility in tables up to level 4.