Kbase P26344: Column not found/specified (7520) when using SQL-92 DELETE 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 DELETE statement.
Executing the statement:
DELETE FROM pub.customer WHERE city = "Boston";
CAUSE:
The statement:
DELETE FROM pub.customer WHERE city = "Boston";
fails because the character field value "Boston" is enclosed in double quotes.
FIX:
Enclose all SQL-92 character field values in single quotes:
DELETE FROM pub.customer WHERE city = 'Boston';