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?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
Code: Select all
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])
);
Ben