I can't get Lita (SQLite) to work with Corona SDK :/

Solar2D General Questions/Discussion
#1

I’ve just started to build a simple database with Lita (http://www.dehats.com/drupal/?q=node/58) and once I created a table called myTable I go to the SQL tab and press “Save in SQL File”. I put the file in the User/Library/Application Support/Corona Simulator/myApp/Documents folder and I name it myDatabase.db

Then in Corona I write this:

  
local path = system.pathForFile("myDatabase.db", system.DocumentsDirectory)  
db = sqlite3.open(path)  
--print all the table contents  
for row in db:nrows("SELECT \* FROM myTable") do  
 local text = row.content.." "..row.content2  
 local t = display.newText(text, 20, 30 \* row.id, null, 16)  
 t:setTextColor(255,0,255)  
end

When I start my app, the Corona Terminal says:

no such table: myTable

[import]uid: 24111 topic_id: 20167 reply_id: 320167[/import]

#2

Got it to work with SQLite Database Browser (http://sqlitebrowser.sourceforge.net/) but I want it to work with Lita too since I think that is easier [import]uid: 24111 topic_id: 20167 reply_id: 78779[/import]

#3

Interesting. I am having the same issue. I am getting the "no such table: " error as well. and the table does exist and nothing has change except a new version of the SDK… [import]uid: 66859 topic_id: 20167 reply_id: 78786[/import]

#4

Type nil instead of system.DocumentsDirectory
I had the same issue and when I used a nil value for location it worked for me. [import]uid: 147340 topic_id: 20167 reply_id: 106205[/import]

#5

I have the same problem but the nil value generates a different error for me:
bad argument #1 to ‘open’ (string expected, got nil)

local path = system.pathForFile("data.sqlite", nil)  
 db = sqlite3.open(path)

Edit: printed the path and checked in the folder given in the path, it’s there.
[import]uid: 206953 topic_id: 20167 reply_id: 144888[/import]

#6

I have the same problem but the nil value generates a different error for me:
bad argument #1 to ‘open’ (string expected, got nil)

local path = system.pathForFile("data.sqlite", nil)  
 db = sqlite3.open(path)

Edit: printed the path and checked in the folder given in the path, it’s there.
[import]uid: 206953 topic_id: 20167 reply_id: 144888[/import]

#7

I have the same problem but the nil value generates a different error for me:
bad argument #1 to ‘open’ (string expected, got nil)

local path = system.pathForFile("data.sqlite", nil)  
 db = sqlite3.open(path)

Edit: printed the path and checked in the folder given in the path, it’s there.
[import]uid: 206953 topic_id: 20167 reply_id: 144888[/import]

#8

I have the same problem but the nil value generates a different error for me:
bad argument #1 to ‘open’ (string expected, got nil)

local path = system.pathForFile("data.sqlite", nil)  
 db = sqlite3.open(path)

Edit: printed the path and checked in the folder given in the path, it’s there.
[import]uid: 206953 topic_id: 20167 reply_id: 144888[/import]