Kbase 13067: Using Temporary Tables in a UIB Browser
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Using Temporary Tables in a UIB Browser
Technical Support is frequently asked if it is possible to create
browsers on temporary tables using the UIB. This can be done using
FREEFORM query in version 8 in the UIB; however in version 7.2 and 7.3
you must connect to a temporary database that is defined
to be like your temporary table.
For example, users can create a separate local database
(i.e.: TMPTAB.db) which has files defined exactly like all of the
temporary tables that the developers will be using. At design time,
the developer can be connected to this database and specify the
option to not qualify table names with the database name (when using
the UIB to create Browsers). This will enable the developer to use
the UIB to create browsers against these temporary tables. Developers
should add code like:
&IF DEFINED(UIB_is_running) = 0 &THEN
DEFINE TEMP-TABLE ...
&ENDIF
When running in production mode, the TMPTAB.db will not be connected
and the real temp-tables will be used instead.
Progress Software Technical Support Note # 13067