Reading and writing from BLOB field

bobbySrivastava
bobbySrivastava Member Posts: 30
edited 2004-10-20 in NAV/Navision Classic Client
Hi,

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

Thanks

Comments

  • kine
    kine 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.
  • pduck
    pduck 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
  • awarn
    awarn 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

Categories