Program detection of strong's numbers in user module
Posted: Fri Jun 19, 2020 3:45 am
will the word program detect strong's numbers in a user module?
Official forum for "theWord" Bible software
https://forum.theword.net/
Code: Select all
This info applies to version 3.
All non-Bible modules have an extension .twm (TheWordModule). These files are sqlite3 database files.
To read more about the sqlite database see here: http://www.sqlite.org
To edit these files you may use any of the free editors that can work with sqlite files. Please, see list here: http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
I personally use the following 3 programs to edit the .twm files:
1. http://www.sqliteexpert.com/ (Personal edition which is free)
2. http://www.singular.gr/sqlite/
3. http://www.yunqa.de/delphi/doku.php/products/sqlitespy/
Although i prefer the first one, the second provides unicode support. It seems that may be better tools that these, it's just a personal opinion.
Since the word 'database' seems to intimidate some people, let me write shortly what it is:
A database file is just a structured file that contains data organized in tables (columns and rows). In order to change the content of a database file, instead of using an editor, you can use a language that is called SQL. The tools above make it easy to give such commands in order to read or alter these files. You don't need to worry how the data are organized in the file itself, the tools above can show you these data in tabular format (something like excel).
The twm files contain a number of tables each where the actual data are stored. The structures are quite simple to understand. As an example, i will tell how you can add to a dictionary the flag that it is a strong dictionary.
All twm file contain a table called 'config'. This table contains 2 columns, one called 'name', the other called 'value'. As you can see, this is used to store parameters (name=value).
In order for a dictionary to be flagged as containing strong definitions, one row should be added with name=strong and value=1. To do that, you open the file with one of the tools and you just execute the following SQL command:
Code:
insert into config(name,value) values('strong',1);
In order to check all the values of this table, just write
Code:
select * from config;
For sqlite explorer: in order to execute one of these statements, you just type it and press Execute (F9). The result are shown below.
I hope this is clear, if not i can add more details,
Costas