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.
Caution: 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
SQLLast("QRY1")
WHILE NOT SQL.Out
// Add the result into a list
ListAdd(LIST_NAMELIST, SQLCol("QRY1", 1))
SQLPrevious("QRY1")
END
ELSE
// Processes the error
END
SQLClose("QRY1")
Syntax
<Query name>: Character string
Query name:
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.