SQLNext (Function)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

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 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 the Android applications (accessing the external databases via a Webservice).

This function is now available for the 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 the Android applications (accessing the external databases via a Webservice).

This function is now available for the 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 the Android applications (accessing the external databases via a Webservice).

This function is now available for the 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 (with or without quotes)

Query name:
created and run by SQLExec (with quotes),
run by SQLExecWDR (with or without quotes).
The queries created in 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 : wd250hf.dll