Progress
Programming
Handbook


Static and Dynamic Temp Tables

A static temp–table is created with the DEFINE TEMP–TABLE statement and configured at compile time. A dynamic temp–table is created with the CREATE TEMP–TABLE statement which creates a dynamic handle to a temp–table object whose fields and buffers are configured at runtime. It is possible to associate a dynamic BUFFER object with a static temp–table which allows a certain amount of runtime manipulation. It is also possible to associate a temp–table object with a static temp–table as follows:

DEFINE VARIABLE tth AS WIDGET-HANDLE.
DEFINE TEMP-TABLE tmptblx LIKE customer.
tth = tmptblx:HANDLE. 

Creating a handle to a static temp–table is especially useful if you want to pass it as a parameter. See the "Dynamic Temp–tables as Local and Remote Parameters" section for more information on temp–tables as parameters


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