Options

Reading and writing from BLOB field

bobbySrivastavabobbySrivastava Member Posts: 30
Hi,

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

Thanks

Comments

  • Options
    kinekine Member Posts: 12,562
    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
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    pduckpduck Member Posts: 147
    there are also some examples for streams when opening the programmers help (C/SIDE Reference Guide) ... open Information / Code Examples for Streams
  • Options
    awarnawarn Member Posts: 261
    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
Sign In or Register to comment.