Kbase P71107: View created in Procedure Editor cannot be seen in SQL Explo
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/04/2011 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
View created in Procedure Editor cannot be seen in SQL Explorer (and vice-versa)
CAUSE:
Expected behaviour ...
Views created from within the Procedure Editor are invisible to SQL Explorer: the former are pseudo-SQL89 views, the latter is proper SQL92 views, and they are invisible to each other.
FIX:
Need to use only one tool (SQL Explorer or Procedure Editor) to create and administrate the appropriate views.