4D v14.3

SQL LOAD RECORD

Home

 
4D v14.3
SQL
SQL LOAD RECORD

SQL LOAD RECORD 


 

SQL LOAD RECORD {( numRecords )} 
Parameter Type   Description
numRecords  Longint in 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 settings are only useful when the retrieved data is associated with 4D arrays or 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

The OK variable is changed by the command

 
HISTORY 

Created: 4D 2004

 
SEE ALSO 

SQL CANCEL LOAD
SQL EXECUTE

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)