Fill BLOB from VB.NET

kine

Hello,

I am testing some code in vb.net and now I want to write some text from text box into BLOB field, to be able export this text into file and show it from Navision. The field is in vb.net showed as Base64 field, I tried to write data encoded into Base64, but when I want to export data within navision, this error is reised: "The xxx table contains a BLOB field with invalid compression data: Record:... Field:..."

How to write data into blob field on MS SQL from vb.net to be able to export this data within Navision?

And one information for you:

I am newbie in VB.NET... ;-)

Thanks

fb

See the help in the C/SIDE Reference Guide on the 'Compression' property.

The finsql client (and cfrontsql.dll) do some sort of compression on BLOB contents unless the Compression property is turned off. You have to turn compression off for those BLOBs that you wish to read/write using external tools.

kine

Thanks, I overlooked this property... I'll try it...