Quote:
Originally Posted by anacreon
Thank you for your help. The version I found fo SQLiteSpy doesn't have the select * from like yours, but just Dictionary.
|
That's fine, the
select * from... was just me trying to point you at the correct box on the screen into which you needed to type your SQL code
insert into....
Quote:
Originally Posted by anacreon
I inserted your line all the same with the number I found in "properties", but F9 brings an error message: near "[CODE]": syntax error.
|
That looks as if it may just be a problem with your copy/paste. When I posted the sample SQL it was wrapped in [CODE] tags, which it looks like your copy selection may have accidentally picked up.
Quote:
Originally Posted by anacreon
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'd tried it first as
Code:
insert into Dictionary values('-de-fr','Deutsch - Français','true', 5018977,'','true')
|
Your first attempt was correct. I just tried to run that SQL command on a copy of my database and it ran OK.
Keep trying, we'll get there in the end
P.S. It's possible that you may need to reboot the Kobo once you've successfully managed to update the database.