PDA

View Full Version : FrontBase : insert a date


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

loicDu28
02-25-2009, 10:10 AM
hello,

I managed to solve my problem as a single.

thank you to you.