This is probably me being stupid but.....
I have written a simple 1 page app that grabs data from a local sqlite DB. This runs correctly in the simulator and I have made sure I have an updated copy in both the file location and sandbox location but when I build it for Android (or HTML5 and even Windows) it comes up with a runtime error saying the table does not exist.
I have tried to put the DB in a folder and on the root folder but still get the same error.
local sqlite3 = require( "sqlite3" ) local path = system.pathForFile( "duniversity.db", system.DocumentsDirectory ) local db = sqlite3.open( path )
above is how I am calling my DB.
Is there a limitation to the free version or do I have to purchase a plugin/license to compile with sqlite DB?
(While posting this I noticed system.DocumentsDirectory in the path location, does this mean I need to create a new folder?
Thanks in advance