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".

Following is the syntax for accessing this attribute for a data-source object buffer:

 

Syntax 

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.

Following is the syntax for accessing this attribute for a buffer directly:

 

Syntax 

buffer-handle:KEYS

buffer-handle

The handle to the buffer.