2 Replies Latest reply on Nov 25, 2009 10:14 PM by capsheetal

    Inserting Date in SQLite DB

    capsheetal Level 1

      Hi all,

      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 flash.data::SQLStatement/internalExecute()
          at flash.data::SQLStatement/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.