SQLNext (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

SQLNext (Function)

In french: SQLSuivant

Positions on the next 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, SQLNext is used in a read loop with SQLFirst.

Caution: This function must be used during an SQLFirst/SQLCol browse of query result. For more details, see Types of SQL browse.

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

ResSQL = SQLExec("SELECT CUSTNAME FROM INVOICE", "QRY1")
IF ResSQL = True THEN
SQLFirst("QRY1")
WHILE NOT SQL.Out
ListAdd(LIST_NAMELIST, SQLCol("QRY1", 1))
SQLNext("QRY1")
END
ELSE
// SQLEXEC error
END
SQLClose("QRY1")

Syntax

SQLNext(<Query name>)

<Query name>: Character string

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

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 row.

Component: wd270hf.dll