| Category | Data Query |
| Default Catalog | Visual FoxPro Catalog\Foundation Classes\Data Query |
| Class | _tablefind |
| Base Class | Custom |
| Class Library | _table.vcx |
| Parent Class | _table |
| Sample | ...\Samples\Vfp98\Solution\Ffc\dataqry.scx |
Remarks
This class creates a generic object that locates a record based on specified critereria. The class also provides an optional Find Next method.
To use, drop the class on a project or form or, from the Component Gallery Item Shortcut menu, select Add to Project or Add to Form. When you add the class to a form, Visual FoxPro opens a builder so you can specify appropriate cFindString, lMatchCase, lSkipMemo, lWrapAround values. When you drop the class on a project, you can choose between adding the class or creating a subclass.
See Guidelines for Using Visual FoxPro Foundation Classes for more information on using foundation classes.
| Properties, Events, Methods | Description |
| cFields property | Specifies the list of fields to search. Default: "" |
| cFindString property | Specifies the string for which to search. Default: "" |
| lFindAgain | Specifies whether the file is traversed to find succesive instances of cFindString. Default: .F. |
| lMatchCase property | Specifies whether to use case-sensitivity in the search. Default: .F. |
| lSkipMemos property | Specifies whether to ignore Memo fields in the search. Default: .F. |
| lWrapAround property | Specifies whether to continue searching from the beginning if end of file (EOF) is reached. Default: .F. |
| SkipField method | Removes tcSkipField from the search. Syntax: SkipField( ) Return: none Arguments: none tcSkipField specifies the field to ignore during the search. |
| aMemos [1] property | Internal to the class. Default: .F. |
| iMemos property | Internal to the class. Default: 0 |
| cControlCharacter property | Internal to the class. Default: ~ |