Release 10.1A: OpenEdge Development:
Progress 4GL Handbook

> ## Temp-table attributes

> This section describes the attributes you can access through a temp-table handle.

> ##### DYNAMIC attribute

> This `LOGICAL` attribute returns true if the temp-table is dynamic and false if is static.

> ##### NAME attribute

> This is the name of the temp-table. For a static temp-table, it is the name you gave it in the `DEFINE TEMP-TABLE` statement. For a dynamic temp-table, it is the name you specify in the `TEMP-TABLE-PREPARE` method. Thus, the `NAME` attribute is not defined for a dynamic temp-table until you have prepared it.

> ##### PREPARED attribute

> This `LOGICAL` attribute returns true if the temp-table has been prepared and false otherwise. It always returns true for a static temp-table.

> ##### DEFAULT-BUFFER-HANDLE attribute

> Every temp-table, whether static or dynamic, has a default buffer. This attribute holds the handle of that buffer. You use the buffer to create or delete records in the table. The default buffer has the same name as the temp-table, just as the default buffer for a database table has the same name as the table. The default buffer handle is not assigned until the temp-table is prepared.

> ##### PRIMARY attribute

> This `CHARACTER` attribute holds the name of the primary index for the table. You can inherit the definition of the primary index from another table, in the `CREATE-LIKE` method, or you can define a temp-table index to be primary. This is the index the records in the table are sorted on, if there are no other sort criteria or if another index is not used to satisfy selection criteria of a `WHERE` clause on the table. You can set the value of the `PRIMARY` attribute for a dynamic temp-table only if the temp-table has not yet been prepared.

> ##### UNDO attribute

> This `LOGICAL` attribute is true if the temp-table has undo properties and false if it is `NO-UNDO`. Because the static `DEFINE TEMP-TABLE` statement allows you to specify the `NO-UNDO` keyword on the definition, just as you can for variables, the default value of `UNDO` for a static temp-table is true. For a dynamic temp-table, the default value of `UNDO` is false. You can set the `UNDO` attribute for a dynamic temp-table only before it has been prepared.

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