SQLPrevious (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLPrevious (Function)

In french: SQLPrécédent

Positions on the previous row of the query result. This row becomes the current row.

If controls or variables are associated with the columns of query result (SQLAssociate), the values found in the current row are automatically assigned to these elements.

In most cases, SQLPrevious is used in a read loop with SQLLast.

Caution: This function must be used during a SQLFirst/SQLCol browse of query result. See Types of SQL browse for more details.

Versions 19 and later

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for Android applications (accessing the external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).

New in version 19

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for Android applications (accessing the external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).

This function is now available in Android Widget mode (accessing the external databases via a Webservice).

This function is now available for Android applications (accessing the external databases via a Webservice).

This function is now available for iPhone/iPad applications (accessing the external databases via a Webservice).

Versions 21 and later

This function is now available in Universal Windows 10 App mode.

New in version 21

This function is now available in Universal Windows 10 App mode.

Example

ResExec = SQLExec("SELECT CUSTNAME FROM INVOICE", "QRY1")
IF ResExec THEN
// Transfer the name into LIST_NAMELIST
SQLLast("QRY1")
WHILE NOT SQL.Out
ListAdd(LIST_NAMELIST, SQLCol("QRY1", 1))
SQLPrevious("QRY1")
END
ELSE
// Processes the error
END
SQLClose("QRY1")

Syntax

SQLPrevious(<Query name>)

<Query name>: Character string (with or without quotes)

Query name:
created and run by SQLExec (with quotes),
run by SQLExecWDR (with or without quotes).
The queries created with the query editor must be specified in the format of a character string with quotes.

Remarks

If the pointer is located outside the query file, the SQL.Out variable is set to True.
The SQL.Current variable contains the number of the current line.

Component: wd260hf.dll