[www.theword.net]

Twitter live feed  
View unanswered posts | View active topics It is currently Thu Jan 18, 2018 11:51 am



Reply to topic  [ 2 posts ] 
 Merging two dictionaries 
Author Message

Joined: Wed Sep 29, 2010 10:04 pm
Posts: 341
Post Merging two dictionaries
Does anyone have some SQLite tips or code for merging two dictionaries into one.
For example I have a Spanish Vines in Hebrew and another in Greek and I'd like to merge them.

If possible I'd like to sort the topics list alphabetically at the same time. Since there are also some Spanish topics.

Thanks


Sat Nov 18, 2017 2:12 am
Profile
User avatar

Joined: Wed Jun 04, 2008 7:34 pm
Posts: 3539
Post Re: Merging two dictionaries
You can do some of this within theWord. Have both modules as "user editable", then select all the topics in the one module and "drag n drop" to the topics list in the target module.
Then I would try some sql on the module either of these should do something, though I am just borrowing past code here.
Of course you should only try this on backup copies until you are sure all is well.

create table x (rel_order integer primary key autoincrement, id, subject);
insert into x(id,subject) select id,subject from topics order by subject;
update topics set rel_order = (select rel_order from x where id = topics.id);
drop table x;
vacuum;
---------------------------------
create table x (rel_order integer primary key autoincrement, id, subject);
insert into x(id,subject) select id,subject from topics order by lower(subject);
update topics set rel_order = (select rel_order from x where id = topics.id);
drop table x;
vacuum;

_________________
Jon
the
Word 5 Bible Software
OS for testing; Windows 10
Beta Download ------Beta Setup Guide------On-line Manual------Tech doc's and Utilities------Copyright Factsheet


Sat Nov 18, 2017 10:10 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.