Kbase P159415: SQL: Syntax error executing a query using RECID keyword
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/02/2010 |
|
Status: Unverified
SYMPTOM(s):
SQL: Syntax error executing a query using RECID keyword
Syntax error in SQL statement at or about "RECID(customer) = 195." (10713)
Executing a statement similar to:
select name, state, city, recid from pub.customer where recid = 195;
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge Category: SQL
CAUSE:
Although the RECID is a valid keyword and a function in 4GL/ABL syntax, it is neither a valid keyword nor a recognized function of SQL-92.
FIX:
Use ROWID instead. For example, the following variation of the above offending statement executes without error:
select name, state, city, rowid from pub.customer where rowid = 195;