Promotic
WikipediaLinkedInYoutubeTwitterFacebook

FindPrev - method of the PmaDatabase object

Description:
Searching for the string in the database table from the current position backward.
Syntax:
Long FindPrev(String sFilter)
Parameters:
sFilter(String) Text string in the syntax of the SQL language statement 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.

This method is not functional if the "Technology" configurator is set to Access through ODBC.

See also:
Example:
JavaScriptVBScriptSelect and copy to clipboard

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

//Searching for the numeric item
n = oDb.FindPrev("Price > 10000");

//Searching for the time item. The time is set: - #month day year hour:minute:second#
n = oDb.FindPrev("Time > #10 24 2020 12:10:37#");
PROMOTIC 9.0.13 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