Skip to main content
Version: 20 R7 BETA

SQL End selection

SQL End selection : Boolean

ParameterTypeDescription
Function resultBoolean←Result set boundaries reached

This command is not thread-safe, it cannot be used in preemptive code.

Description​

The SQL End selection command is used to determine if the boundaries of the result set have been reached.

Example​

The code below connects to an external data source (Oracle) using the following parameters:

 var vName : Text
 
 SQL LOGIN("TestOracle";"scott";"tiger")
 If(OK=1)
    SQL EXECUTE("SELECT ename FROM emp";vName)
    While(Not(SQL End selection))
       SQL LOAD RECORD
    End while
    SQL LOGOUT
 End if

This code will return in the 4D vName variable the emp names (ename) stored in the table named emp.