Positions on the previous 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, SQLPrevious
is used in a read loop with SQLLast
: This function must be used during an SQLFirst/SQLCol browse of query result. For more details, see Types of SQL browse
ResExec = SQLExec("SELECT CUSTNAME FROM INVOICE", "QRY1")
IF ResExec THEN
// Transfer the name into LIST_NAMELIST
WHILE NOT SQL.Out
ListAdd(LIST_NAMELIST, SQLCol("QRY1", 1))
// Processes the error
<Query name>: Character string
The queries created with 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 line.