Quote:
Originally Posted by anacreon
This is what I wanted, and I found sqlitespy and downloaded it. But I can't find any tutorial on how to create new lines (I need 2) or copy lines and modify them.
|
Not a tutorial, but it's the best I can do
Using the image 3, from my previous post, as a reference...
- Double-click on the Dictionary entry in the left column to display the contents of the current Dictionary table.
- In the top right box where image 3 shows select * from ... type
Code:
insert into Dictionary values('-fr-de','Français - Deutsch','true',1594055,'','true')
N.B: the value 1594055 needs to be the exact size of your dicthtml-fr-de.zip file in bytes.
- Once you have constructed the above SQL command with the correct size value, press [F9] to run it (or using menu Execute > Execute SQL).
- Check your result, if successful, the Dictionary table will have closed. Repeat step 1 to view it again. Your new row will be displayed - probably as the last row.
I recommend making a copy of the database on your PC first so you can practice running an SQL command.
Alternatively, if the above is too confusing it may be worth having a look at the different SQLite utility used by surquizu in the post I linked in my previous post. It looks like it might be more of a "fill-in-the-boxes" way to add a new row.