4D v13.4

SQL CANCEL LOAD

Home

 
4D v13.4
4D Language Reference
SQL
SQL CANCEL LOAD

SQL CANCEL LOAD 


 

SQL CANCEL LOAD  
Does not require any parameters

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:

 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

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

 
PROPERTIES 

Product: 4D
Theme: SQL
Number: 824

The OK variable is changed by the command

 
INDEX

Alphabetical list of commands

 
HISTORY 

Created: 4D 2004

 
SEE ALSO 

SQL LOAD RECORD
SQL LOGIN