Sqlite Blob Fields
lazarus / 16-Databases

----------------------------------------------------------------------
davesimplewear · 2010-08-10 00:22

I have a sqlite db with a table containing a blob field for a dbmemo,
I enter Info into the dbMemo and save, but when I come back to the
record it is blank, is there a procedure for saving blob info to the
db or should I use a memo field?

Regards
Dave

----------------------------------------------------------------------
jixian.yang · 2010-08-10 02:12

The SQL statement can saving blob info to the db, for instance:
update p_table set BBLO = '222222222222222' where view_name = 'master'
read:
select BBLO from p_table where view_name = 'master'

You can read Zeoslib example 'examples\blobs' also, if the component
is Zeoslib.

----------------------------------------------------------------------
Lacak2 · 2010-08-16 06:25

May be, that your problem with BLOB is this:
http://bugs.freepascal.org/view.php?id=15314