Release 10.1A: OpenEdge Development:
Progress 4GL Reference

> ## KEYS attribute

> Returns a comma-separated list of key fields for a buffer.

> Data type: CHARACTER

> Access: Readable

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

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095