Promotic
WikipediaLinkedInYoutubeTwitterFacebook

FindLast - method of object PmDatabase

Description:
Searching for the string in the database table from the end of the table.
Syntax:
FindLast(sFilter As String) As Long
Calling:
n = oDb.FindLast(sFilter)
Parameters:
sFilter(String) String in the syntax of the SQL language command WHERE that defines the condition for searching
Note:

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.

Example:
Searching for the value John Saruman in the column of the text type with the name Customer
n = oDb.FindLast("Customer = 'John Saruman'")
Searching for the numeric item
n = oDb.FindLast("Price > 10000")
Searching for the time item. The time is set: #month day year hour:minute:second#.
n = oDb.FindLast("Time > #10 24 2016 12:10:37#")
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice