Kbase P27031: How to set the PUB qualifier in the Windows registry to avoid prefixing it in existing reports?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/02/2010 |
|
Status: Verified
GOAL:
How to avoid setting the pub qualifier before each table name in a Crystal Report ?
GOAL:
How to set the pub qualifier in Windows registry?
GOAL:
How to use existing SQL-89 Crystal Reports with SQL-92 ?
GOAL:
How to set the default schema in the registry?
GOAL:
How to use existing SQL-89 code with SQL-92?
FACT(s) (Environment):
Progress 9.1x
OpenEdge 10.x
Crystal
FIX:
All 4GL tables, by default, are owned by PUB. When using SQL-92, all queries must specify the table owner. This was not the case when using SQL-89.
Add the "DefaultSchema" string value set to "PUB" in the registry:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\<your DSN name>
- OR -
HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\<your DSN name>
This entry allows you to keep your existing code written with the ODBC SQL-89 Driver. Reconnect to the database with the client and test the application again.