Kbase P167247: A DATA-SOURCE handles QUERY:PREPARE-STRING attribute set to ? after being detached from a DATASET
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
03/06/2010 |
|
Status: Unverified
SYMPTOM(s):
Program creates DataSet with three temp-tables in it
Each temp-table has a dynamic query created and attached to a DATA-SOURCE object
The query string passed to the QUERY-PREPARE method is retained as long as the DATA-SOURCE objects remain attached to the temp-tables in the DataSet
When the DATA-SOURCE objects are detached from the temp-tables using DETACH-DATA-SOURCE some of the DATA-SOURCE objects have there associated query objects reset to the unknown value
Customer expects the query objects to retain their queries so that the PREPARE-STRING attribute can be referenced after the DETACH-DATA-SOURCE method is invoked
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.0x
CAUSE:
It is standard behavior to reset the DATA-SOURCE objects associated query when the query references temp-tables that are part of the DataSet that the DATA-SOURCE object is no longer attached to. This is done to prevent GPF's from happening because the DATA-SOURCE object is no longer logically correct once it has been detached from the DataSet.
FIX:
Since this is expected behavior, if you expect to access the PREPARE-STRING attribute of the DATA-SOURCE objects associated query you need to access this and save it off prior to detaching the DATA-SOURCE object from the DataSet.