version 2004
ODBC End selection Boolean
Parameter | Type | Description | ||||
This command does not require any parameters | ||||||
Function result | Boolean | Result 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.