Recent

Author Topic: Sqlite Blob Fields  (Read 7435 times)

davesimplewear

  • Sr. Member
  • ****
  • Posts: 307
    • Davids Freeware
Sqlite Blob Fields
« on: August 10, 2010, 02:22:58 am »
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
All things considered insanity seems the best option

jixian.yang

  • Full Member
  • ***
  • Posts: 173
Re: Sqlite Blob Fields
« Reply #1 on: August 10, 2010, 04:12:43 am »
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

  • Guest
Re: Sqlite Blob Fields
« Reply #2 on: August 16, 2010, 08:25:26 am »
May be, that your problem with BLOB is this:
http://bugs.freepascal.org/view.php?id=15314

 

TinyPortal © 2005-2018