Can't drop table from database

Solar2D General Questions/Discussion
#1

I have this block of code:

[lua]local path = system.pathForFile(“data.db”, system.DocumentsDirectory)
db = sqlite3.open( path )

local tablesetup = [[DROP TABLE score_floors;]]
db:exec( tablesetup )

for row2 in db:nrows(“SELECT * FROM score_floors”) do
print("---->ID: " … row2.id )
end[/lua]

And output shows data from ‘dropped table’

Can anyone help me please? Thanks
[import]uid: 208600 topic_id: 34692 reply_id: 334692[/import]

#2

And I can only do CREATES and INSERTS, I can’t do UPDATES

Edit: I found the solution:

The name of table can’t have ‘_’ character [import]uid: 208600 topic_id: 34692 reply_id: 137859[/import]

#3

And I can only do CREATES and INSERTS, I can’t do UPDATES

Edit: I found the solution:

The name of table can’t have ‘_’ character [import]uid: 208600 topic_id: 34692 reply_id: 137859[/import]