Kbase 19861: Error 6431 When Running SmartObjects on V9.0B - Dsrv ODBC
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.0B
ODBC DataServer
SYMPTOM(s):
ADM2
Dynamic queries are not supported by the ODBC DataServer (328) (6431)
QUERY-OPEN for query <name> requires a previous QUERY-PREPARE. (7312)
You might get the following errors when running a SmartObject (ADM2)
against an ODBC datasource:
Dynamic queries are not supported by the ODBC DataServer (328) (6431)
Query Prepare in initProps failed QUERY-OPEN for query Query-Main requires a previous QUERY-PREPARE. (7312)
CAUSE:
Beginning with Progress Version 9.1A, the ODBC DataServer supports only dynamic queries. The new SmartObjects implemented in Version 9.0B (ADM2) use static queries. For DataServer ODBC 9.0B, you must use the Progress Version 8.x SmartObjects.
FIX:
Use the Version 8.x objects to build your application to avoid the Error 6431 messages.
To use Version 8.x SmartObjects with Version 9.0B follow these steps:
1) Open the Progress AppBuilder tool.
2) Choose Use Custom in the menu on the palette window.
3) Select ADD > Files.
4) Select the smartv8.cst file.
5) Click OK in all screens.
6) Go to File > NEW. Look at the Version 8.x SmartObjects (SmartV8Browser, SmartV8Viewer, SmartV8Query,etc).
7) Use the new buttons on the palette for the Version 8.x SmartObjects.