Kbase 18389: Cannot Do SELECT * From SPORTS.Order Against Progress DB
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Unsupported Products
SYMPTOM(s):
Cannot do SELECT * from SPORTS.Order against a Progress database
Apptivity Query Editor
Parsing of the given SQL statement failed. Returning.
CAUSE:
This happens with OpenLink and Intersolv drivers.
ORDER is an SQL keyword and this is causing a problem parsing the SQL.
FIX:
The only known workaround is to rename the Order table and create a new set of triggers.