OP Get record numbers

4D - Documentation   Français   English   German   4D Open for 4D, Command Theme List   4D Open for 4D, Command Alphabetical List   Back   Previous   Next

version 1.5


OP Get record numbers (connectionID; tableID; recordNumbers{; firstRecordNumber{; lastRecordNumber}}) Longint

ParameterTypeDescription
connectionIDLongintConnection ID with target server
tableIDLongintNumber of the table in the database
recordNumbersArrayAbsolute record numbers in target table
firstRecordNumberLongintRelative number of first record
in the current selection
lastRecordNumberLongintRelative number of last record
in the current selection
Function resultLongintError code result for the function

Description

OP Get record numbers returns in recordNumbers the record numbers for the selection of records in tableID.

recordNumbers is an array of type Longint or Real.

You can enter values in the optional firstRecordNumber and lastRecordNumber parameters to limit the number of records whose numbers are returned in recordNumbers. If firstRecordNumber = 0, OP Get record numbers returns the record numbers of all selected records. Remember that firstRecordNumber and lastRecordNumber are selected record numbers, but the numbers returned in the recordNumbers array are record numbers.

Error Codes

If OP Get record numbers executes successfully, it returns 0. Otherwise, this function returns one of the following errors:

Error CodeDescription
-108Not enough memory to perform this operation.
-9972Table number is out of range.
10128The 4D Open for 4th Dimension package has not been initialized.
10135Invalid parameter type.
10136The connection does not exist.
10154This command cannot be executed right now.

Example

See example for OP Delete record.


See Also

OP Current Record Number, OP Delete record, OP Selection to array, OP Single query, SELECTION TO ARRAY.


4D - Documentation   Français   English   German   4D Open for 4D, Command Theme List   4D Open for 4D, Command Alphabetical List   Back   Previous   Next