ODBC LOAD RECORD

4D - Documentation   Français   English   German   4th Dimension 2004, Command Theme List   4th Dimension 2004, Command Alphabetical List   4th Dimension 2004, Constant Theme List   Back   Previous   Next

version 2004


ODBC LOAD RECORD {(numRecords)}

ParameterTypeDescription
numRecordsIntegerNumber 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.


4D - Documentation   Français   English   German   4th Dimension 2004, Command Theme List   4th Dimension 2004, Command Alphabetical List   4th Dimension 2004, Constant Theme List   Back   Previous   Next