Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    New to the CF scene
    Join Date
    Feb 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    FrontBase : insert a date

    Hello,

    I like FrontBase database and I want to insert a date through the SQL language, here is what to do:
    Code:
    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

  • #2
    New to the CF scene
    Join Date
    Feb 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hello,

    I managed to solve my problem as a single.

    thank you to you.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •