4D v14.3
SQL End selection
- 4D Language Reference
-
- SQL
-
- Overview of SQL Commands
- On SQL Authentication Database Method
- Begin SQL
- End SQL
- Get current data source
- GET DATA SOURCE LIST
- Is field value Null
- QUERY BY SQL
- SET FIELD VALUE NULL
- SQL CANCEL LOAD
- SQL End selection
- SQL EXECUTE
- SQL EXECUTE SCRIPT
- SQL EXPORT DATABASE
- SQL EXPORT SELECTION
- SQL GET LAST ERROR
- SQL GET OPTION
- SQL LOAD RECORD
- SQL LOGIN
- SQL LOGOUT
- SQL SET OPTION
- SQL SET PARAMETER
- START SQL SERVER
- STOP SQL SERVER
- USE EXTERNAL DATABASE
- USE INTERNAL DATABASE
SQL End selection
| SQL End selection -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| Function result | Boolean |
|
Result set boundaries reached | |||||
The SQL End selection command is used to determine if the boundaries of the result set have been reached.
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 ifThis code will return in the 4D vName variable the emp names (ename) stored in the table named emp.
Product: 4D
Theme: SQL
Number:
821
Created: 4D 2004
4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)
