[www.theword.net]

Twitter live feed  
View unanswered posts | View active topics It is currently Thu Sep 21, 2017 11:15 pm



Reply to topic  [ 2 posts ] 
 Custom Cross Reference file SQLite Trigger 
Author Message

Joined: Sun Jun 04, 2017 8:24 am
Posts: 1
Post Custom Cross Reference file SQLite Trigger
Hello, I'm using a custom.xrefs.twm cross reference file with theWord for pc and MySword for Android and when I browsed the file with SQLite Expert Personal, I noticed a trigger called "xrefs_bcv". The http://theword.net/docs/tw3-book-module-spec.doc file has the following explanation on page 13:

Quote:
f stand for from, t for to, b for book, c for chapter, v for verse, i for index. So:
fbi is the book index (1 through 66)
fci is the starting chapter of the book
tci is the ending chapter of the book
fvi is the starting verse of the book+starting chapter
tvi is the ending verse of the book+ending chapter

Does anyone know what the symbols "<<" mean in the trigger and what the digits "24", "16", or "8" mean? Does this trigger basically help create a faster cross reference search index?
Code:
INSERT INTO [xrefs]
    ( [id], [vi1], [vi2] )
    VALUES (
   [new].[id],
   ([new].[fbi] << 24) + ([new].[fci] << 16) + ([new].[fvi] << 8) + ([new].[fspan]),
   ([new].[tbi] << 24) + ([new].[tci] << 16) + ([new].[tvi] << 8) + ([new].[tspan])
   );

Thanks in advance.
Ben


Attachments:
2017-06-04 01_41_52-SQLite Expert Personal 4.2 (x64)_LI.jpg
2017-06-04 01_41_52-SQLite Expert Personal 4.2 (x64)_LI.jpg [ 363.33 KiB | Viewed 151 times ]
Sun Jun 04, 2017 9:33 am
Profile

Joined: Wed Sep 23, 2009 4:13 pm
Posts: 604
Location: Brasília, Brazil
Post Re: Custom Cross Reference file SQLite Trigger
These are bit shift operators.

_________________
Rúbio R. C. Terra
Brasília/DF - Brasil


Wed Jun 14, 2017 2:13 pm
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.