SQL End selection

Home

4D v16.3

SQL

SQL End selection


SQL End selection -> Function result

Parameter	Type	Description
Function result	Boolean	Result set boundaries reached

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:

 C_TEXT(vName)

 

 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.