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
: This function must be used during an SQLFirst/SQLCol browse of query result. For more details, see Types of SQL browse
ResExec is int
// Run a query
ResExec = SQLExec("SELECT CUSTNAME FROM INVOICE", "QRY1")
IF ResExec = True THEN
// Transfer the name into LIST_NAMELIST
WHILE NOT SQL.Out
// Add the result into a list
ListAdd(LIST_NAMELIST, SQLCol("QRY1", 1))
// Processes the 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.