TurboDB VCL Component Library

Using a Full-text Index at Run-time

See also

Previous  Top  Next

If you have created a full-text index you can use it to locate records containing one or more given keywords in just a few milliseconds.

To use a full-text index at run-time, you have to:

1.Place a TTdbTable component for the table your are searching in on your form.
2.At design-time or at run-time set the WordFilter property to your desired full-text expression, e.g. WordFilter := 'Embarcadero';
The syntax for keyword filter expressions is explained in "Full-Text Search-Conditions".
3.Now you can work with this filter like you are used to from normal filters. You may employ the FindFirst, FindNext, FindPrior and FindLast methods to locate the record or you can just set the Filtered property to True.
4.You may also combine word filters with standard filter-conditions by setting the WordFilter property and the Filter (or FilterW) property at the same time.

 

Annotation

Only old type full-text indexes (table level 3 and lower) need an additional table component for the dictionary table. Set the FullTextTable property to the component for the dictionary table.