SQLNext (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / Managing databases / SQL functions

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.

Warning This function must be used when browsing the result of a SQLFirst/SQLCol query. For more details, see Types of SQL browse.

Example

ResSQL = SQLExec("SELECT NOMCLI FROM FACT", "REQ1")
IF ResSQL = True THEN
	SQLFirst("REQ1")
	WHILE NOT SQL.Out
		ListAdd(LISTE_LISTENOM, SQLCol("REQ1", 1))
		SQLNext("REQ1")
	END
ELSE
	// Erreur SQLEXEC
END
SQLClose("REQ1")

Syntax

SQLNext(<Query name>)

<Query name>: Character string

Name of the query:
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: wd300hf.dll