Bigtext problem

lubost

Hi guys,

there is a step by step description of my problem:
1. I have a picture file (JPG)
2. I have written a small program for conversion (Base64) -> file is converted
3. If I want to stream converted file into Bigtext variable I obtained error message "Overall number of characters in text can not exceeds ..."
My code

Image - Bigtext
Item - Record - 27
InS - Instream

Item.CALCFIELDS(Picture);
IF Item.Picture.HASVALUE then BEGIN
Item.Picture.CREATEINSTREAM(InS);
Image.READ(InS);
END;

What's wrong?
Thank you in advance

dmccrae

Not quite sure why you want it in a BigText. BigText is intended for large textual not binary data. You should stream into a BLOB instead, and from there it depends what your ultimate goal is - you could copy to a BLOB field, or another stream such as a file.

lubost

Thank you for your answer.
1. After Base64 conversion picture is in text representation, so it is not in binary format
2. I need to include this converted file to XML
3. Customer hasn't CG installed and CG granule, so can not use Biztalk way to fulfill requirement

Thanks in advance

rmv_RU

lubost wrote:

I need to include this converted file to XML

Try to use 'Microsoft XML, v6.0'.IXMLDOMText (xmlDomText) object:
1. Copy BLOB into file or stream object.
2. By using cycle, read data into a text variable and use the xmlDomText.appendData method.
3. Append xmlDomText node into the XML document.

dmccrae

OK, I'm with you. Does it error on the Image.READ? How big is the BLOB data in the SQL table?

ara3n

You don't need CG to do biztalk integration.
You can do integration using msmq with biztalk.