1. 

   mozaharul Active Member Licensed User

   In the SQLite insert command the "insert into geo values(calender1.values)" save the date as ticks.
   
   But if I use " insert into geo values(date(calender1.values))" then it saves zero (0) in the database.
   
   
   Please help
   
   
   regards

    

   mozaharul, Apr 1, 2008

   #1
2. 

   Erel Administrator Staff Member Licensed User

   Try:
   

   Code:

   "insert into geo values('" & date(calender1.values) & "')"

    

   Erel, Apr 2, 2008

   #2
3. 

   mozaharul Active Member Licensed User

   It works.
   Thank you very much sir.

    

   mozaharul, Apr 2, 2008

   #3

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?

Stay logged in