Source language: Translate to:

Sqlite and Blob/Picture

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

Sqlite and Blob/Picture

Postby cp4w » Tue Oct 02, 2007 8:33 am

I created a column on a sqlite table as a picture field and I would like to store a graphic in it.

I used
Code: Select all
SetVar "[mydb.tbl1.thegraphic]" "C:\Documents and Settings\MHControl\My Documents\My Pictures\bmps\Red Arrow Up 16 n m.bmp"

It does not store the graphic but just the file name.

What am I doing wrong?
Posts: 533
Joined: Sun Apr 03, 2005 4:37 pm
Location: Great Neck, NY

Postby Wrangler » Tue Oct 02, 2007 8:36 am

Dont' know much about sqlite, but I believe you have to declare the field a BLOB field. Otherwise it treats it as a string field, which will only store the file path.
"You never know about a woman. Whether she'll laugh, cry or go for a gun." - Louis L'Amour

Windows 7 Ultimate SP1 64bit
16GB Ram
Asus GTX 950 OC Strix
Software made with NeoBook
User avatar
Posts: 1513
Joined: Thu Mar 31, 2005 11:40 pm
Location: USA

Postby David de Argentina » Tue Oct 02, 2007 9:12 am

Hi shx,

Did you try my NeoSqlite Manager?

Feel Free to try it... ...

It does exactly you need... and free...

Greetings from Buenos Aires,

David de Argentina
User avatar
David de Argentina
Posts: 1590
Joined: Mon Apr 04, 2005 4:13 pm
Location: Buenos Aires, Argentina

Postby Neosoft Support » Tue Oct 02, 2007 10:36 am

Unfortunately, each database engine handles support for picture/blob fields differently. There is no standard picture format, so DBPro must deal with each database engine differently. Currently, DBPro does not support SQLite blob fields. We will try to correct this in the next update. In the mean time, you will need to use one of the other database formats, such as MS Access or MySQL. Sorry for the inconvenience.
NeoSoft Support
Neosoft Support
NeoSoft Team
Posts: 5620
Joined: Thu Mar 31, 2005 10:48 pm
Location: Oregon, USA

Return to NeoBookDBPro

Who is online

Users browsing this forum: No registered users and 1 guest