Kbase P22068: SQL Explorer: Syntax error (7587) when using double quotes
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
SYMPTOM(s):
Error using SQL INSERT command: INSERT INTO PUB.table (field) values("abc").
Using SQL EXPLORER
Syntax error (7587)
CAUSE:
SQL Explorer does not accept double quotes for an string value.
FIX:
Replace double quotes to single quote.
Example:
INSERT INTO PUB.table (field) values('abc').