TurboDB VCL/CLX 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 at TdbTable component for both the table your are searching in and the helper keyword table on your form.  
 
2.Set the FullTextTable property of the first table component to the second table component.  
 
3.At design-time or at run-time set the WordFilter property of the first table component to the keyword or the full-text expression your are looking for. E.g. set:  
WordFilter := 'Borland';  
The syntax for keyword filter expressions is explained in "Full-Text Search-Conditions".  
 
4.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.  
 
5. 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.