... | ... | @@ -144,13 +144,24 @@ The CSV Bible importer strips all formatting except the line break(>br>) from th |
|
|
1. Type `update verse set text = ' ` as the start of the sql command.
|
|
|
1. Place your pointer over the 'Text' column for the row that you want to edit. In my case this is Genesis 1:1.
|
|
|
1. Right click and select 'Copy to SQL Text' from the pop up menu. The text in the 'Text' column will be added to your SQL command.
|
|
|
1. Add the following to the end of the SQL command: `' where book_id = 2 AND chapter = 1 AND verse = 1` Please use the information from your screen for the row you are working on....Be careful to gt the values right as you will be updating the database in a few more steps!
|
|
|
1. Add the following to the end of the SQL command: `' where book_id = 2 AND chapter = 1 AND verse = 1` Please use the information from your screen for the row you are working on....Be careful to get the values right as you will be updating the database in a few more steps!
|
|
|
1. Place the cursor on the SQL Command between the single quote and the word 'Chapter' and type `<strong>`.
|
|
|
1. Place the cursor on the SQL Command between the word 'World' and the start of the line break(<br>) and type `</strong>` Your SQL Command should look similar to:<br>
|
|
|
`update verse set text = '<strong>Chapter 1 The Creation of the World</strong><br><br>1:1 In the beginning God created the heavens and the earth.' where book_id =2 AND chapter = 1 AND verse = 1`
|
|
|
1. Press the 'run' button. The Row you were working on should now be updated to include the `<strong>` and `</strong>` tags.
|
|
|
1. Save the database.
|
|
|
1. Start OpenLP and display Genesis 1:1. You should see a Bold Chapter heading with the verse in normal text.<br>
|
|
|
**Italics**<br>
|
|
|
1. Locate the Row for Genesis 2:4
|
|
|
1. Locate the Row for Genesis 2:4.You can look through the verses or you can create a SQL command to show you the verse...The SQL command for my database would be `Select * from verse where book_id = 2 AND chapter = 2 AND verse = 4`.
|
|
|
1. Type `update verse set text = ' ` as the start of the sql command.
|
|
|
1. Place your pointer over the 'Text' column for the row that you want to edit.
|
|
|
1. Right click and select 'Copy to SQL Text' from the pop up menu. The text in the 'Text' column will be added to your SQL command.
|
|
|
1. Add the following to the end of the SQL command: `' where book_id = 2 AND chapter = 2 AND verse = 4`
|
|
|
1. Place the cursor on the SQL Command just before the word 'The' and type `<i>`.
|
|
|
1. Place the cursor on the SQL Command just after the word 'woman' and type `</i>`. Your SQL Command should look similar to:<br>`<br><br><strong><i>The Creation of Man and Woman</i></strong><br><br>2:4 These are the generations of the heavens and of the earth when they were created, in the day that Jehovah God made earth and heaven.`
|
|
|
1. Press the 'run' button. The Row you were working on should now be updated to include the `<i>` and `</i>` tags.
|
|
|
1. Save the database.
|
|
|
1. Start OpenLP and display Genesis 2:4. You should see a Italics sub heading with the verse in normal text.
|
|
|
|
|
|
|
|
|
**Adding Red Text Color to the words of Jesus** |
|
|
\ No newline at end of file |