Importing BLOB from SQL view into NAV table

tfranzen

Hi everybody,

I have a similar question as in thread viewtopic.php?f=23&t=33300

I have a SQL-Database with existing BLOB's. The field type is image. There is a view in the NAV-DB for this table and a NAV-Table which is using this view.

When I try to move this blob from the View to a real NAV-Table (Rec1.CALCFIELDS, then Rec2.BlobField := Rec1.BlobField, etc) the blob is truncated. In the Nav-DB the blob fields are set to 'uncompressed'.

Does anybody has some expierience with this behaviour and some advice for me?

Thanks in advance

Thomas

bylle

Hi

You should be able to use ADO to stream or move/insert the image to the Navision blob field.
Take a look here http://techblog.byllemos.com/2008/05/importing-image-from-a-non-navision-table-to-blob-field/ - it's a post on how to do it.