Progress
Programming
Handbook
Characteristics of Work Tables
Work tables are to database tables what variables are to database fields. Like a variable, a work table:
- Must be defined in any procedure that uses it.
- Is a temporary structure stored in memory rather than in the database, and can either be local to a single procedure or shared among multiple procedures.
- Can be defined to be LIKE a database table (much like a variable can be defined to be LIKE a database field). Work tables also have the option to adopt the same dictionary validation specified for the corresponding database table.
- Does not have indexes, therefore you cannot do a FIND work-table. However, you can do a FIND FIRST work-table.
NOTE: Because Progress stores and processes work tables in memory, the number of work tables and the number of records in a work table that you can use is limited by the memory available on your system.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |