Oracle BLOB/CLOB + TSmartQuery + TDBRichEdit, display error in TDBRichEdit.

Denggh · Post by **Denggh** » Sun 16 Jan 2005 14:28

Base on demos BlobPictures or Clob, I only change TDBImage/ TDBMemo VCL to TDBRichEdit, and the demos can run well while Blob/Clob field's size is not large(smaller than 64K? maybe smaller than 32K), DBRichEdit can display correct Font, Table or paragraph.
But while I'm inserting/modifying a large enough data( copy from MS word, then paste to DBRichEdit, the word document is 403K), before posting, DBRichEdit dipslay correctly, but after posting, DBRichEdit can't display correctly, no font, no table, etc... It just like opening a *.rtf file with MS notepad. And if I copy all the content in DBRichEdit to a *.txt file, save it as *.txt and then open it with MS Riched, it can display correctly.

I don't know if there is something wrong with ODAC or TDBRichEdit, it trouble me for a long time. Can anyone help me?

Oh, my OS is MS windows xp with sp1.

Thinks In Advance!

Denggh

Alex · Post by **Alex** » Mon 17 Jan 2005 13:19

It's not ODAC bug it's TDBRichEdit problem, you can get the same result with BDE components. We suggest you to ask your question to Borland support

Denggh · Post by **Denggh** » Tue 18 Jan 2005 07:29

Hi Alex,
I found that while using Oracle client, these errors wouldn't occur.
But if working with ODAC net, while the content of DBRichedit is smaller than 64K, it works well too. while larger than 64K, post action is correctly, and the Oracle Database contain the correct data excepted. After posting action, if no refresh action is taken, the display of DBRichedit is smart. But after refreshing, the error occurs, it seems that the SmartQuery Dataset can only fetch the first 64K data, and the DBRichedit display incorrectly, with no font, no table, but a lot of '\par' strings(rtf's tag).

Base on Clob demo, I only change TDBMemo to TDBRichedit.

Is it some bug with ODAC net? my environment is Oracle 9i + MS win xp.

Best regards.

Denggh

Alex · Post by **Alex** » Tue 18 Jan 2005 10:19

Please specify exact versions of ODAC that you have tested and send us complete small sample to demonstrate the problem and include script to create server objects to ODAC support address.
The problem similar to your description was fixed since ODAC 5.10.1.7, we suggest you to try ODAC 5.10.4.13 available for download from our site.

Denggh · Post by **Denggh** » Tue 18 Jan 2005 15:08

Oh, my odac version is 5.10.0.5, I will download the new version and have a try the next day, thanks.

Denggh