4D v13.4
SQL LOAD RECORD
- 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
4D v13.4
SQL LOAD RECORD
SQL LOAD RECORD
| SQL LOAD RECORD {( numRecords )} | ||||||||
| Parameter | Type | Description | ||||||
| numRecords | Longint |
|
Number of records to load | |||||
The SQL LOAD RECORD command retrieves one or more record(s) in 4D coming from the data source open in the current connection.
The optional numRecords parameter sets the number of records to retrieve:
- If you omit this parameter, the command retrieves the current record from the data source. This principle corresponds to the retrieval of data in a loop where one record is received at a time.
- If you pass an integer value in numRecords, the command retrieves numRecords records.
- If you pass the SQL All Records constant (value -1), the command retrieves all the records of the table.
Note: These last two parameters are only meaningful if the data retrieved are associated with arrays or with 4D fields.
If the command has been executed correctly, the system variable OK returns 1. Otherwise, it returns 0.
PROPERTIES
Product: 4D
Theme: SQL
Number:
822
INDEX
HISTORY
Created: 4D 2004
SEE ALSO
© 1985-2013 4D SAS / 4D, Inc. All rights reserved.