version 2004
ODBC CANCEL LOAD
Parameter | Type | Description | ||||
This command does not require any parameters |
Description
The ODBC CANCEL LOAD command ends the current SELECT request and initializes the parameters.
This command is used to execute several SELECT requests within the same connection (i.e. the same cursor) initiated by the ODBC LOGIN command.
Example
In this example, two requests are executed in the same connection:
C_BLOB(Myblob) C_TEXT(MyText) ODBC LOGIN("mysql";"root";"") SQLStmt:="SELECT blob_field FROM app_testTable" ODBC EXECUTE(SQLStmt;Myblob) While(Not(ODBC End selection)) ODBC LOAD RECORD End while `Resetting of cursor ODBC CANCEL LOAD SQLStmt:="SELECT Name FROM Employee" ODBC EXECUTE(SQLStmt;MyText) While(Not(ODBC End selection)) ODBC LOAD RECORD End while
See Also
System Variables or Sets
If the command has been correctly executed, the system variable OK returns 1. Otherwise, it returns 0.