7 replies to this topic

[Tracey]

How can I configure a resource to display the notes when clicking on <Display Book Comments> or <Display Chapter Comments> or <Display Verse Comments> for 1 table?

I have notes that are (?associated? / ?indexed?) with the <Display Verse Comments>.
I tried adding 2 additional indices for the <Display Book Comments> and the <Display Chapter Comments>, but the notes do NOT appear when clicking on the icons (the <Display Verse Comments> icon still works).

 

I want to be able to choose any 1 of the 3 icons and the applicable notes appear.

Please advise.
Thanks, Tracey (SQL Newbie)
e-Sword 10, SQLite Database Browser v2.0b1, Windows 2000 Pro sp4

 

[Tracey]

If this is the wrong forum, is there another forum that I can use to post SQL questions for e-Sword?

 

I have created a simple Notes Resource, but the Book 2 Chapter 3 Comments do NOT appear when clicking on the <Display Chapter Comments> icon (separate tables this time).

I can not seem to see what I am doing wrong to enter the Book 2 Chapter 3 Comments.

 

Book 1 Comments and Book 3 Chapter 4 Verse 5 Comments both appear when selected.

 

Any help will be appreciated.

Please advise.

Thanks, Tracey (SQL Newbie)
e-Sword 10, SQLite Database Browser v2.0b1, Windows 2000 Pro sp4

BEGIN TRANSACTION;
CREATE TABLE 'Details' (Description NVARCHAR(255), Abbreviation NVARCHAR(50), Comments TEXT, Version INT);
INSERT INTO Details VALUES('<Test Margin Notes> Description NVARCHAR(255)','<Test Margin Notes> Abbreviation(50)','<Test Margin Notes> Comments TEXT',1);
CREATE TABLE 'Books' (Book INT, Comments TEXT);
INSERT INTO Books VALUES(1,'<Test Margin Notes> Book Comments TEXT');
CREATE TABLE 'Chapters' (Book INT, ChapterBegin INT, ChapterEnd INT, Comments TEXT);
INSERT INTO Chapters VALUES(2,3,3,'\b1 <Test Margin Notes> Chapter Comments TEXT\b0');
CREATE TABLE 'Verses' (Book INT, ChapterBegin INT, ChapterEnd INT, VerseBegin INT, VerseEnd INT, Comments TEXT);
INSERT INTO Verses VALUES(3,4,4,5,5,'\i1 <Test Margin Notes> Verse Comments TEXT\i0');
CREATE INDEX BookIndex ON Books (Book);
CREATE INDEX BookChapterIndex ON Chapters (Book, ChapterBegin);
CREATE INDEX BookChapterVerseIndex ON Verses (Book, ChapterBegin, VerseBegin);
COMMIT;

 

 

[Josh Bond]

Without seeing the database, I don't know the answer to the problem, or really, even understand what the problem is.

 

Why not just use ToolTip NT which will take the content you specify (book comments, chapter comments, and/or verse comments) and create the proper database scheme, rtf tags, etc.

 

Josh

[Tracey]

 

Josh Bond, on 15 Jun 2013 - 11:10 AM, said:

Without seeing the database, I don't know the answer to the problem, or really, even understand what the problem is.

Why not just use ToolTip NT which will take the content you specify (book comments, chapter comments, and/or verse comments) and create the proper database scheme, rtf tags, etc.

 

Josh

 

 

Without seeing the database, I don't know the answer to the problem 

I am baffled by your response because I pasted the SQL database into the topic as code: everything needed to build the demo database.

 

even understand what the problem is. 

The problem is when I select the 2nd Book, 3rd Chapter (of the Bible) and click on the <Display Chapter Comment> that no comment appears.

I assume that <Display Chapter Comment> function works and there is a type-o in the database, but I read and re-read it several times and I am unable to spot what/where is the error.

Book 1 Comments and Book 3 Chapter 4 Verse 5 Comments appear when selected and the applicable icon is clicked.

 

Why not just use ToolTip NT which will take the content you specify (book comments, chapter comments, and/or verse comments) and create the proper database scheme, rtf tags, etc

I would like to do that, but I tried using ToolTip NT and I get the error message: "The procedure entry point GetNativeSystemInfo could not be located in the dynamic link library KERNEL32.dll" then the program aborts/halts

See below/last regarding win32 applications in Windows 2000 (some of the text of an email I sent to Rick).

 

The only 1 other program that I have that has a similar type of error message is with Firefox, but Firefox does not abort, halt or crash: Firefox just continues to run just fine.

 

You could remove the abort/halt logic if GetNativeSystemInfo does not return what you expect or the OS is Windows 2000 (Win32 NTFS).

Maybe in that case assume it is an older OS that does not use the advanced/latest features/functions

 

The SQLite Database Browser v2.0b1 runs just fine in Windows 2000.

Please advise.

Thanks, Tracey

e-Sword 10, SQLite Database Browser v2.0b1, Windows 2000 Pro sp4

<snip>

Issue #2 Can you please keep e-Sword Windows 2000 compatible as much as reasonably possible (or at least do not deliberately exclude it)?

</snip>

<snip>

I tried installing e-Sword v10.1.0 EXE and the install failed due to the OS version, but it did unpack the MSI.

The e-Sword MSI file installed just fine and e-Sword v10.1.0 runs just fine Windows 2000.

</snip>

<snip>

Over a decade ago I was using Windows NT 4.0 Workstation and acquired a scanner with software designed for Windows 95.

The installer for the package aborted the install because I was not running Windows 95.

However, the individual modules installed just fine and I used the scanner with the original/supplied software applications/utilities for years.

</snip>

 

[Josh Bond]

Yeah, getting a modern program to run on a 14 year old operating system can be tricky. I don't believe even Microsoft supports 2000. So I can't help with T4 very much.

 

Your database schema is wrong, and that's why the Book and Chapter comments are not showing. See the screenshot for a comparison of the issues I saw.

Attached Files

•  schema-comparison.png   98.95K   34 downloads

[BH.]

CREATE TABLE 'Chapters' (Book INT, ChapterBegin INT, ChapterEnd INT, Comments TEXT);

 

Should be

:

CREATE TABLE 'Chapters' (Book INT, Chapter INT, Comments TEXT);

[Tracey]

2 questions regarding Verses for Notes:

#1 When a resource is referencing a verse in e-Sword, is it necessary to have all these fields in the Verses Table: ChapterBegin, ChapterEnd, VerseBegin, and VerseEnd or can Chapter and Verse be sufficient?

 

#2 Can ChapterBegin, ChapterEnd, VerseBegin, and VerseEnd be used for a range of chapters or a range of verses?

 

Please advise.

Thanks, Tracey

I see the following used in other files: CREATE TABLE 'Verses'(Book INT, ChapterBegin INT ChapterEnd INT, VerseBegin INT, VerseEnd INT, Comments TEXT), but the numbers for ChapterBegin and ChapterEnd INT are duplicated/identical and the numbers for VerseBegin INTand VerseEnd are duplicated/identical

I  am wondering if the duplication of data is necessary.

 

 

[BH.]

#1 - ALL

#2 - The numbers are the start verse and end verse and you specify all.  John 3:16-John 4:1 -->  43,3,4,16,1.

 

If just John 3:16, then it would be 43,3,3,16,16.