F00165 Media Object text attachment

I'm upgrading from Xe to 8.12 and found that the spec of F00165 has been changed. Text attachment was stored as long string in rtf format but now has become blob. I'm using crystal report to get the text attachment but now it doesn't work. Can anyone enlighten me how to do it with blob?

I'm not sure about Crystal reports. For a different application we had to read the media object from the blob and then write it to a large string in work table to get the information out using UBE before the third party application could grab it.

There's also a Crystal reports forum below that you might try asking in.

Steven

What database do you use?

Kenny,
If you search on media object you should get good previous post on this topic which explains how you can directly get the text from database thru SQL and stored procedure.

Chan

Ya I found one very useful, thank you very much!!

http://www.jdelist.com/ubb/showflat.php?Cat=0&Board=Crystalreports&Number=123971&page=0&view=collapsed&sb=7&o=&fpart=1