4D v16.3

SQL CANCEL LOAD

Home

 
4D v16.3
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.



See also 

SQL LOAD RECORD
SQL LOGIN

 
PROPERTIES 

Product: 4D
Theme: SQL
Number: 824

The OK variable is changed by the command

 
HISTORY 

Created: 4D 2004

 
ARTICLE USAGE

4D Language Reference ( 4D v16)
4D Language Reference ( 4D v16.1)
4D Language Reference ( 4D v16.2)
4D Language Reference ( 4D v16.3)