loicDu28
02-24-2009, 09:50 AM
Hello,
I like FrontBase database and I want to insert a date through the SQL language, here is what to do:
INSERT INTO AttributParArticleDate VALUES(7, 7, 2003-04-23)
Here is the error message I get:
Encountered an error while executing SQL:
INSERT INTO AttributParArticleDate VALUES(7, 7, 2003-04-23)
Semantic error 231. INSERT value doesn't match column: valeur.
Semantic error 485. Near: INSERT INTO "AttributParArticleDate" VALUES(7,7,2003-4-23);.
Semantic error 485. Near: 23.
Exception 363 (40:000). Transaction rollback.
How can I do?
thank you in advance
I like FrontBase database and I want to insert a date through the SQL language, here is what to do:
INSERT INTO AttributParArticleDate VALUES(7, 7, 2003-04-23)
Here is the error message I get:
Encountered an error while executing SQL:
INSERT INTO AttributParArticleDate VALUES(7, 7, 2003-04-23)
Semantic error 231. INSERT value doesn't match column: valeur.
Semantic error 485. Near: INSERT INTO "AttributParArticleDate" VALUES(7,7,2003-4-23);.
Semantic error 485. Near: 23.
Exception 363 (40:000). Transaction rollback.
How can I do?
thank you in advance