Kbase 13339: How to define a shared query for a temp-table or work file
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
How to define a shared query for a temp-table or work file
Users may attempt to define a shared query for, say, a temp-table as
follows:
DEF NEW SHARED TEMP-TABLE t FIELD f AS CHAR.
DEF NEW SHARED QUERY q FOR t.
This will give error 3324:
** Buffer t in QUERY q must be a shared buffer since query is
shared. (3324)
To use a shared query, one needs to have a shared buffer defined on
the table being accessed, regardless of the type of table being used.
This is true of database tables, temp-tables, and work-tables.
The code above would compile if it was changed to the following:
DEF NEW SHARED TEMP-TABLE tt FIELD f AS CHAR.
DEF NEW SHARED BUFFER t FOR tt.
DEF NEW SHARED QUERY q FOR t.
Progress Software Technical Support Note # 13339