version 1.5
OP Get record numbers (connectionID; tableID; recordNumbers{; firstRecordNumber{; lastRecordNumber}}) Longint
Parameter | Type | Description | |
connectionID | Longint | Connection ID with target server | |
tableID | Longint | Number of the table in the database | |
recordNumbers | Array | Absolute record numbers in target table | |
firstRecordNumber | Longint | Relative number of first record | |
in the current selection | |||
lastRecordNumber | Longint | Relative number of last record | |
in the current selection | |||
Function result | Longint | Error 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 Code | Description |
-108 | Not enough memory to perform this operation. |
-9972 | Table number is out of range. |
10128 | The 4D Open for 4th Dimension package has not been initialized. |
10135 | Invalid parameter type. |
10136 | The connection does not exist. |
10154 | This 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.