Kbase P24683: SQL: Error when using the value ? (unknown) in an INSERT com
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/7/2003 |
|
Status: Unverified
SYMPTOM(s):
** Unable to understand after -- "INSERT". (247)
** Invalid statement. (254)
SQL command: INSERT INTO db1.tablex (name, date) VALUES ( ?, ?).
CAUSE:
Invalid syntax, the value ? is not valid.
FIX:
Use instead the keyword NULL and replace the "?" character.
Example:
INSERT INTO db1.tablex (name, date) VALUES (NULL, NULL).