4D Doc Center : SQL CANCEL LOAD

Home

4D v14.3

SQL

SQL CANCEL LOAD


	SQL CANCEL LOAD

	Does not require any parameters

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:

 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

System variables and sets

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