ODBC End selection

4D - Documentation   Français   English   German   4th Dimension 2004, Command Theme List   4th Dimension 2004, Command Alphabetical List   4th Dimension 2004, Constant Theme List   Back   Previous   Next

version 2004


ODBC End selection Boolean

ParameterTypeDescription
This command does not require any parameters
Function resultBooleanResult set boundaries reached

Description

The ODBC 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)

   ODBC LOGIN("TestOracle";"scott";"tiger")
   If (OK=1)
      ODBC EXECUTE("SELECT ename FROM emp";vName)
      While(Not(ODBC End selection))
         ODBC LOAD RECORD
      End while
      ODBC 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   4th Dimension 2004, Command Theme List   4th Dimension 2004, Command Alphabetical List   4th Dimension 2004, Constant Theme List   Back   Previous   Next