SQL End selection

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 2004


SQL End selection Boolean

ParameterTypeDescription
This command does not require any parameters
Function resultBooleanResult 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.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next