SQL CANCEL LOAD

version 2004

SQL CANCEL LOAD

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.

In this example, two requests are executed in the same connection:

   C_BLOB(Myblob)
   C_TEXT(MyText)
   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 

SQL LOAD RECORD, SQL LOGIN.

If the command has been correctly executed, the system variable OK returns 1. Otherwise, it returns 0.