Kbase P18480: Error# 7587 when using an UPDATE SQL-92 Statement against a Progress database.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/17/2005 |
|
Status: Verified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
Getting error (7587) when updating a record from an Application via ODBC.
Syntax error (7587).
ERROR[42000][MERANT][ODBC PROGRESS driver][PROGRESS] syntax error (7587).
CAUSE:
The name of the table owner as well as the name of the actual table are being specified within the SET clause in the UPDATE command. There is no need to specify that information. e.g.:
UPDATE pub.Customer SET pub.Customer.name = 'Progress Software' WHERE pub.Customer.CustNum = 1
FIX:
Take the name of the table owner as well as the name of the actual table out of the SET clause within the UPDATE command. e.g.:
UPDATE pub.Customer SET name = 'Progress Software' WHERE Customer.CustNum = 1