Kbase P97301: long sql insert statement gives error 210056 (10713) - syntax error Syntax error in SQL statement at
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
09/11/2004 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.x
SYMPTOM(s):
long sql insert statement gives ErrorCode 210056 (10713)
[JDBC OpenEdge Driver]:Syntax error in SQL statement at or about "type,prog,oms,parent,beveil,persi) value" (10713)
insert into test (id,type,prog,oms,parent,beveil,persi) values ('','','','','','','')
NEGATED SYMPTOM(s):
insert into test (id) values ('hallo')
CAUSE:
Reserved keyword "type" was used as column name
FIX:
Don't use OpenEdge SQL reserved words as column names