Reading and writing from BLOB field

bobbySrivastava

Hi,

Can anyone guide me on reading from BLOB and writing to a BLOB field.

Thanks

kine

Look into C/AL Symbol menu, which functions you can use on BLOB field (select the field and click on right arrow under the listbox) - EXPORT, IMPORT, HASVALUE, CREATEINSTREAM, CREATEOUTSTREAM

pduck

there are also some examples for streams when opening the programmers help (C/SIDE Reference Guide) ... open Information / Code Examples for Streams

awarn

Try this line of code:

Result := "your field name".IMPORT('*.bmp',TRUE);

If this returns a true value then the file uploaded correctly. Note that to display this value on a form / report you have to do a CALCFIELDS. If you don't do a calcfields you won't be able to see what is in the value, it is possible if you have tried unsuccessfully already it may be that the value is in there but you just haven't been able to see it.

CALCFIELDS("your field name");

-a