[Gambas-user] Sqlite and Gambas and image blobs

[Matti]

Hi M. Cs.,

I'm not really sure what you want.

Is it: the user chooses a picture directory, and you want to display the
thumbnails of the pictures? In PictureBoxes, or frames containing PictureBoxes?

Then you wouldn't need any database, and I could help you. Did this with just an
array of file names, and a function that looks for the system thumbs, or creates
them if they don't exist.

Just tell me if you need something like that.
Matti


Am 05.02.2010 14:05, schrieb M. Cs.:
> Hi,
> I'd like to know how can I store image thumbnails (~10 KByte each) inside
> the sqlite database using Gambas. I'd like to use the stored thumbs as
> preview images, so I'd have to know how to read the blob data out of
> database and use it as a content of a Picture container.
> 
> Once more:
> CREATE TABLE thumbs(name TEXT, img BLOB);
> I suppose that would create a table for thumbnails. How to write into
> thumbs, and how to get back the image, let say into PicFrame?
> Thanks!
> ------------------------------------------------------------------------------
> The Planet: dedicated and managed hosting, cloud storage, colocation
> Stay online with enterprise data centers and the best network in the business
> Choose flexible plans and management services without long-term contracts
> Personal 24x7 support from experience hosting pros just a phone call away.
> http://p.sf.net/sfu/theplanet-com
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>