SQL LOAD RECORD

version 2004

SQL LOAD RECORD {(numRecords)}

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 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 SQL 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.

SQL CANCEL LOAD, SQL EXECUTE.

If the command has been executed correctly, the system variable OK returns 1. Otherwise, it returns 0.