I want to learn how to create a sqlite3 database.
lazarus / 16-Databases

----------------------------------------------------------------------
Kadaft Dantas · 2011-09-05 20:47

My program: A book.
Fields: strBook; intChapter; intVerse; strVerse.

strBook (string) = "Genesis, Exodus, Leviticus ... Matthew, Mark ..."
intChapter (integer) = "1,2,3,4,5,6 ..."
intVerse (integer) = "1,2,3,4,5,6 ..."
strVerse (memo?, or text?, or blob? ...) = "long text formatted html
code"

Lazarus for Linux

Thanks

----------------------------------------------------------------------
LuizAmérico · 2011-09-05 20:56

http://sqlite4fpc.yolasite.com/documentation.php

----------------------------------------------------------------------
eny · 2011-09-05 20:57

Can be done with http://sqliteadmin.orbmu2k.de/

----------------------------------------------------------------------
Silvio Clécio · 2011-09-05 21:06

Best SQLite administrator tool:

http://sqlitestudio.one.pl

Good luck.

----------------------------------------------------------------------
Kadaft Dantas · 2011-09-05 22:03

Sorry all, the question was which type to use in strVerse?
Memo, Text, Blob, or other. What is used for long strings in sqlite3?
I will put in this field, formatted html code:

Code: [Select]<HTML>
<HEAD>
<TITLE>Matthew</TITLE>
</HEAD>
<BODY>
<b>1</b> Verse - long text....kjfladfjakljhasfdjasfdf
</BODY>
</HTML>

----------------------------------------------------------------------
Silvio Clécio · 2011-09-05 22:11

QuoteMemo, Text, Blob, or other. What is used for long strings in
sqlite3?
Text. See: http://imagebin.org/171179

----------------------------------------------------------------------
Kadaft Dantas · 2011-09-05 22:37

Thanks