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
: This function must be used during an SQLFirst/SQLCol browse of query result. For more details, see Types of SQL browse
ResSQL = SQLExec("SELECT CUSTNAME FROM INVOICE", "QRY1")
IF ResSQL = True THEN
WHILE NOT SQL.Out
ListAdd(LIST_NAMELIST, SQLCol("QRY1", 1))
// SQLEXEC error
<Query name>: Character string
The queries created in the query editor must be specified in the format of a character string.
- 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.