This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 4D Language Reference
-
- SQL
-
-
Overview of SQL Commands
-
On SQL Authentication Database Method
-
Begin SQL
-
End SQL
-
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 current data source
-
SQL GET DATA SOURCE LIST
-
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
-
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 v20 R7)
