Kbase P166455: Some SQL views cannot be seen in Crystal Reports
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
21/05/2010 |
|
Status: Unverified
SYMPTOM(s):
Some SQL views cannot be seen in Crystal Reports
Some SQL views cannot be seen in Corvu
View was made from the procedure editor
View can be seen in the Data Dictionary
FACT(s) (Environment):
Using odbc connection
PUB views can be seen
SYSPROGRESS views can be seen
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
SQL89 Views can not be used within SQL92.
The procedure editor can only generate SQL89 statements.
FIX:
Make a connection to the database using a SQL92 client (eg. SQL Explorer) and remake the view using the SQL92 tool.