version 2004
ODBC LOAD RECORD {(numRecords)}
Parameter | Type | Description | |
numRecords | Integer | Number of records to load |
Description
The ODBC LOAD RECORD command retrieves one or more record(s) in 4th Dimension coming from the ODBC source open in the current connection.
The optional numRecords parameter is used to set the number of records to retrieve:
If you omit this parameter, the command will retrieve 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 will retrieve numRecords records.
If you pass the ODBC All Records constant (value -1), the command will retrieve 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.
See Also
ODBC CANCEL LOAD, ODBC EXECUTE.
System Variables or Sets
If the command has been executed correctly, the system variable OK returns 1. Otherwise, it returns 0.