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.