Kbase P6949: Error 7587 when creating view from a SELECT containing ORDER BY clause
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/2/2005 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
SYMPTOM(s):
Error (7587) when creating view from a SELECT containing ORDER BY clause
[JDBC Progress Driver]:Syntax error (7587)
Using SQL-92
CAUSE:
The SQL-92 standard does not include ORDER BY on CREATE VIEW.
FIX:
Create the View without the ORDER BY and add the ORDER BY clause when querying the View:
CREATE VIEW v1 (name) AS SELECT Name FROM pub.customer;
SELECT name FROM v1 ORDER BY name;