|
|
|
|
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. 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|