SQL CANCEL LOAD
SQL CANCEL LOAD
| Does not require any parameters |
|---|
This command is not thread-safe, it cannot be used in preemptive code.
Description
The SQL 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 SQL LOGIN command.
Example
In this example, two requests are executed in the same connection:
var Myblob : Blob
var MyText : Text
SQL LOGIN("mysql";"root";"")
SQLStmt:="SELECT blob_field FROM app_testTable"
SQL EXECUTE(SQLStmt;Myblob)
While(Not(SQL End selection))
SQL LOAD RECORD
End while
//Resetting of cursor
SQL CANCEL LOAD
SQLStmt:="SELECT Name FROM Employee"
SQL EXECUTE(SQLStmt;MyText)
While(Not(SQL End selection))
SQL LOAD RECORD
End while
System variables and sets
If the command has been correctly executed, the system variable OK returns 1. Otherwise, it returns 0.