FindFirst - method of object PmDatabase

Searching for the string in the database table from the begin of the table.
FindFirst(sFilter As String) As Long
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.

VBScriptSelect and copy to clipboard

'Searching for the value John Saruman in the column of the text type named Customer
n = oDb.FindFirst("Customer = 'John Saruman'")

'Searching for the numeric item
n = oDb.FindFirst("Price > 10000")

'Searching for the time item. The time is set: - #month day year hour:minute:second#
n = oDb.FindFirst("Time > #10 24 2018 12:10:37#")
PROMOTIC 8.3.30 SCADA system documentation - MICROSYS, spol. s r.o.

Send page remarkContact responsible person
© MICROSYS, spol. s r. o.Tavičská 845/21 703 00 Ostrava-Vítkovice