Sqlite3, problems with DELETE

Solar2D General Questions/Discussion
#1

I have been working with a Sqlite3. I made a database and was adding records reading them, and working on functions to get at data. At some point I had a lot of extra stuff in in the table I was using, I decided to delete the table with “DROP TABLE tableName”. Now I can’t seem to recreate a table. 

I was wondering if there was a way to delete or reset the database used by Corona? 

On a related question, I’m also using a json file to store some preferences. This works fine in the Simulator but, I’d like to delete this file to test my app starting up and initializing the preferences. Where are these files stored on the desktop? I’m using system.pathForFile( “file.json”, system.DocumentsDirectory ).

#2

I can’t answer the SQLite question, but if you click on File->Show Project Sandbox, a window will open showing the project directory with the files you created for it.

#3

your SQLite database will also be in that sandbox folder and you can just delete it from the operating system.

Rob

#4

I can’t answer the SQLite question, but if you click on File->Show Project Sandbox, a window will open showing the project directory with the files you created for it.

#5

your SQLite database will also be in that sandbox folder and you can just delete it from the operating system.

Rob