Data Set Data Model: _getRecordInfo

Data Set Data Model: _getRecordInfo

Returns a list of information about the current row

Syntax
Information List
Details

Syntax

CALL SEND (object-id, '_getRecordInfo', info-list);

Argument Type Description

info-list
N specifies the identifier of an SCL list to contain information about the current row. This list may contain the items described in the Information List table following.

Argument	Type	Description
info-list	N	specifies the identifier of an SCL list to contain information about the current row. This list may contain the items described in the Information List table following.

Information List
Item Type Description

'CURROW' N the absolute row number for the current row. It returns a missing value if the row is new. It returns -1 under the following conditions:

[bull] there are no rows in the table

[bull] no rows meet the WHERE clause

[bull] the access engine used to read the table does not support absolute row numbers.

'LOCKED' C the ability to lock the row

'Y' unable to obtain a lock on the row

'N' able to obtain a lock on the row

'NEW' C the row is pending

'Y' another process has a lock on the row (the row is unavailable)

'N' no other process has a lock on the row (the row is available)

'ISMODIFIED' C the row has been modified

'Y' data in the current row have been modified, even if the values are the same as before

'N' data in the current row have not been modified

A row is considered modified if changes to the values are entered interactively or through SCL. The changes can be to any columns, including computed columns.

'DATACHANGED' C the data in the row (table or computed columns) have been changed

'Y' data in the current row have been changed

'N' data in the current row have not been changed

'SELECTED' C the locking status of the current row

'Y' the current row is locked

'N' the current row is not locked

Details

This method returns information similar to the OBSINFO SCL function.

Chapter Contents
Previous
Next
Top of Page