SQLLast (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

SQLLast (Function)

In french: SQLDernier

Sets the position on the last 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, SQLLast is used in a read loop with SQLPrevious.

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

Example

ResExec is int
// Exécution d'une requête
ResExec = SQLExec("SELECT NOMCLI FROM FACT", "REQ1")
IF ResExec = True THEN
	// Transfert du nom dans LISTE_LISTENOM
	SQLLast("REQ1")
	WHILE NOT SQL.Out
		// Ajout du résultat dans une liste
		ListAdd(LISTE_LISTENOM, SQLCol("REQ1", 1))
		SQLPrevious("REQ1")
	END
ELSE
	// Traite erreur
END
SQLClose("REQ1")

Syntax

SQLLast(<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