Kbase P30774: INSERT INTO gives error 7587 syntax error
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/07/2003 |
|
Status: Unverified
SYMPTOM(s):
INSERT INTO gives error 7587 syntax error
CAUSE:
Not using double-quotes around a hyphenated field name.
FIX:
Use double-quotes around a hyphenated field name.
For example, with a copy of the sports database:
INSERT INTO pub.customer ("cust-num", name, address, city. state)
VALUES
(85, 'Smith', '#10 Riverside', 'NY', 'NY');