Download the free trial version
Basic4android Video
Features
Tutorials and manuals
Showcase
Screenshots

Go Back   Android Development Forum - Basic4android > Basic4ppc (Windows Mobile) > Questions (Windows Mobile)
Documentation Wiki Register Members List B4P Search Today's Posts Mark Forums Read

Questions (Windows Mobile) Post any question regarding Basic4ppc.

Date save as zero (0) in the SQLite database

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 04-01-2008, 10:15 AM
Senior Member
 
Join Date: Mar 2008
Location: Dhaka, Bangladesh
Posts: 164
Default Date save as zero (0) in the SQLite database

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
Reply With Quote
  #2 (permalink)  
Old 04-02-2008, 07:21 AM
Erel's Avatar
Administrator
 
Join Date: Apr 2007
Posts: 15,733
Awards Showcase
Basic4ppc Founder 
Total Awards: 1
Default

Try:
Code:
"insert into geo values('" & date(calender1.values) & "')"
Reply With Quote
  #3 (permalink)  
Old 04-02-2008, 09:25 AM
Senior Member
 
Join Date: Mar 2008
Location: Dhaka, Bangladesh
Posts: 164
Default

It works.
Thank you very much sir.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
setting calendar value from a sqlite date Ricky D Questions (Windows Mobile) 2 01-23-2009 12:54 PM
Graphic in SQLite Database Picard Questions (Windows Mobile) 1 08-23-2008 11:03 AM
Command to create a database in sqlite mozaharul Questions (Windows Mobile) 5 03-30-2008 03:38 AM
Convert Any Database to SQLite (source & exe) dzt Code Samples & Tips 6 02-28-2008 07:39 AM
How to convert an Access database to a sqlite database Peter Code Samples & Tips 5 07-24-2007 03:20 PM


All times are GMT. The time now is 09:09 AM.


Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.3.0