Kbase P124463: Error 20713 when retrieving a field named DBA
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
19/06/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
Progress 9.x
All Supported Operating Systems
SYMPTOM(s):
Error 20713 when retrieving the DBA field
Table contains a field with name DBA
Error: Syntax error in SQL statement at or about "dba FROM..." (20713)
(State:S1000, Native Code:FFFCCB78)
CAUSE:
DBA is reserved word for Progress SQL engine
FIX:
Use double quote aroudn DBA name.
Example: SELECT "DBA" FROM PUB.<table-name>