Try OpenEdge Now
skip to main content
ABL Reference
Handle Attributes and Methods Reference : KEYS attribute
 

KEYS attribute

Returns a comma-separated list of key fields for a buffer.
Data type: CHARACTER
Access: Read-only
Applies to: Buffer object handle, Data-source object handle
For a data-source object buffer, this attribute returns a comma-separated list of key fields defined in an associated KEYS clause for the specified buffer. If there are no defined key fields, this attribute returns a comma-separated list of key fields in the buffer's unique primary index (if any). If there are no defined key fields and no unique primary index, this attribute returns the string "ROWID".

Syntax

Following is the syntax for accessing this attribute for a data-source object buffer:
data-source-handle:KEYS ( buffer-sequence-number )
data-source-handle
The handle to the data-source object.
buffer-sequence-number
An integer that represents the sequence number of a buffer in the list of buffers for the data-source object. Specify buffer-sequence-number to identify a buffer in the data-source object when the data-source object is defined against more than one database table buffer.
Note: Sequence numbers for buffers of a query start at one, where one represents the top level and subsequent numbers represent lower levels of a join, if any.

Syntax

Following is the syntax for accessing this attribute for a buffer directly:
buffer-handle:KEYS
buffer-handle
The handle to the buffer.