This is a migrated thread and some comments may be shown as answers.

SQL Lite NOT working On apple ipad(IOS)

11 Answers 171 Views

iOS Devices

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

11 Answers, 1 is accepted

answered on 17 Jun 2013, 12:42 PM

Hello Arthanari,

SQLite requires that you enable the SQLite Cordova plug-in for your project, for more information see Add and Configure Plugins help article. However, Cordova plugins are not supported in the simulator, so the fact that your project works in the simulator does not necessarily mean it would work on device in your case. When you run the project in the simulator, it would fall back to Web SQL, which syntax is very much the same as SQLite and everything might seem alright.

The error from the log is thrown by SQLite itself and not by Icenium. You can take a look at stackoverflow for common causes for this error:

http://stackoverflow.com/questions/934237/sqlite-exception-no-such-table-error
http://stackoverflow.com/questions/13533619/sqlite-no-such-table

Regards,
Steve
Telerik

Looking for tips & tricks directly from the Icenium team? Check out our blog!
Missed our first webinar, watch it here.
Share feedback and vote for features on our Feedback Portal.

answered on 18 Jun 2013, 02:19 PM

db.txt

Hi steve,

I attached js file, in which it throws error
[Detected docs path: /var/mobile/Applications/F562885E-2D93-4750-ABBB-53DC834BAC06/Documents
using db name: /var/mobile/Applications/F562885E-2D93-4750-ABBB-53DC834BAC06/Documents/Todo
[LOG] DB opened: undefined
[LOG] Error: SQL statement error : no such table: comm

pls find this error

thanks in advance

Arthanari