Kbase P12912: Column not found/specified (7520) when using SQL-92 UPDATE statement.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
SYMPTOM(s):
Column not found/specified (7520) when using SQL-92 UPDATE statement.
Executing a statement similar to:
UPDATE pub.customer SET city = "Boston" WHERE Cust-Num = 10;
CAUSE:
The statement:
UPDATE pub.customer SET city = "Boston" WHERE Cust-Num = 10;
fails because the field name Cust-Num includes a dash '-' and needs to be enclosed in double quotes.
FIX:
Enclose field names that include the dash '-' character with double quotes:
UPDATE pub.customer SET city = "Boston" WHERE "Cust-Num" = 10;