SQLite Forum

sqlite DB + data file - write out all entries
Login
Thanks, but the .dat file is handled by the database, so I can do e.g.:

sqlite> .open Engelsk.gdb

sqlite> .tables
collocation_lookup1  entries2             reverse1           
collocation_lookup2  info                 reverse2           
dict_setup           lookup1              sound              
entries1             lookup2

SELECT * FROM lookup1;
....
355644|vinduespolerernes
355645|vinduespudsers
355646|vinduespudseren
355647|vinduespudseren
....

All the lemmas from "lookup1" are output. The English lemmas are in "reverse1" and other information about the DB are in the other tables. I suppose I need to form a query to print out an actual dictionary entry, which consists of the word to translate and its translation and iterate over all the lemmas. Could anyone help me in doing that? I am a database novice.

Thanks,
Morten