I am inserting data in my sqlite db,and when i use Datefield i am using selected date to insert into the column which has type DateTime.
i am getting an sql excep.-
SQLError: 'Error #3115: SQL Error.', details:'could not convert string value to date', operation:'execute'
at CampaignCreator/onZimbleeDBOpened()[E:\AIR workspace\CampaignCreator\src\CampaignCreator.mxml:46]
Also i tried typecasting it as Date(value),but it gives same exception.
Please share your solutions on this.
I hit this same problem and Googled for an answer.
Most people seem to say just stuff the date in a VARCHAR, so that's what I did.
If this post answers your question or helps, please mark it as such.
Thanks Greg,tht was helpful.