This is the sql file I should change, almost 4 elements have been inserted with its 4 descriptions .I must be able to edit that file, eliminating these 4 elements that are already entered. I tried to edit the file, but once updated and re entered the app, the app tells me that the file has problems.
how can I edit the file?
I have just tried your file with the Firefox Plug-in - SQLite Manager and it works fine. I can see the four records in the
item table and you also have a
location table with 4 records as well.
You should be fine editing the file.
You can always use the DROP TABLE Syntax and then recreate the table using the same CREATE TABLE syntax you first used.
You need an SQLite Editor to do it outside of your app. It is a DATABASE file and as such needs to be edited properly. There is a free addon for firefox (SQLite Manager :: Add-ons for Firefox) that can be used.
Think you can help? Login to answer this question!