Blob field to icon

[SergioCavalcante]

sorry about my poor english, I speak portuguese...
I'm having a little problem that is driving me mad.I have to fill a image list with some icons from a blob field in my table, at run-time, and I don't know how to do that with the Oracle Query. I've tried to use the Lob Locator, using the Help example, using the fiel as a LobField, but an error ocurred, saying that the field isn't a lob field.
please, help me.

Sergio

 

[Marco Kalter]

What is the table definition and the query you are using?

------------------
Marco Kalter
Allround Automations

 

[SergioCavalcante]

the field is Long Raw.
theres a bitmap saved there.
soh I just want to know the comand to add the bitmap from the field do the imagelist.
like this that I tried unfortunatelly :

BM : TBitmap;

ImageList.Add(BM.Assign(Query1.Field('fieldname')));

if Exists a command that works, answer to me

 

[Marco Kalter]

I'm not sure how the TImageList or TBitMap works, but the Field function for a LONG RAW field returns a variant array of bytes. You have to copy this binary data to the bitmap. See the 'Long and Long Raw' section in the User's Guide or Help File for more information.

By the way: LOBField only works for BLOB's, CLOB's and BFILE's. It returns the field's TLOBLocator. Therefore it does not work for LONG and LONG RAW fields.

------------------
Marco Kalter
Allround Automations

 

[SergioCavalcante]

Ok I'll try it!
thank you very much for your help.

Sergio