Quote:
Originally Posted by jackie_w
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. |
Dear Jackie,
Thank you for your help. The version I found fo SQLiteSpy doesn't have the select * from like yours, but just Dictionary. I inserted your line all the same with the number I found in "properties", but F9 brings an error message: near "[CODE]": syntax error.
I had doubts about whether there were spaces or not around the - between Français and Deutsch so I tried both (as a matter of fact I inverted everything since my dictionary is the Deutsch - Français).
I had already saved the database.
EDIT: here is what I wrote
Code:
insert into Dictionary values('-de-fr','Deutsch-Français','true',5018977,'','true')
I'd tried it first as
Code:
insert into Dictionary values('-de-fr','Deutsch - Français','true', 5018977,'','true')