Kbase P80821: Only wants to retrieve three fields from temp-table, depending on how code is written either no data
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/05/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.0A
SYMPTOM(s):
Defining temp-table like a database table
Adding temp-table to ProDataSet
Only wants to retrieve three fields from temp-table
Depending on how code is written either no data comes back or all fields in temp-table come back
CAUSE:
Misunderstanding of how ProDataSets work. ProDataSets hold one or more temp-tables, associated queries (data sources) for those temp-tables, and definitions of relationships (if any) between the temp-tables.
FIX:
Modify the source code to define the temp-table so that it only contains the fields that are needed (i.e. do not do a define temp-table like db.table)