n = oDb.FindFirst(sFilter)
|sFilter||(String) String in the syntax of the SQL language statement WHERE that defines the condition for searching|
If the search is successful, the method returns an index of the found record and the pointer (of the current position) is set to this record, otherwise it returns the value -1 and the current position remains unchanged.
The method is not functional if the Technology configurator is set to Access through ODBC.
n = oDb.FindFirst("Customer = 'John Saruman'")
n = oDb.FindFirst("Price > 10000")
n = oDb.FindFirst("Time > #10 24 2017 12:10:37#")