![]() If a search fails, the current record does not change. Locate returns True if it finds a matching record, False if it does not. If Locate finds a match, the first record containing the match becomes the current record. LocateSuccess := CustTable.Locate( 'Company', 'Professional Divers, Ltd.' , SearchOptions) (Partial-key matching is when the criterion string need only be a prefix of the field value.) For example, the following code moves the cursor to the first row in the CustTable where the value in the Company column is "Professional Divers, Ltd.": In its simplest form, you pass Locate the name of a column to search, a field value to match, and an options flag specifying whether the search is case-insensitive or if it can use partial-key matching. Locate moves the cursor to the first row matching a specified set of search criteria. However, by explicitly using indexes, FindKey, GotoKey and other similar methods of TABSTable can improve over the searching performance provided by the Locate and Lookup methods. These methods enable you to search on any type of columns in any dataset. ![]() You can search against any active table or query using the Locate and Lookup methods.
0 Comments
Leave a Reply. |