bug in memo field

scoluccia · Post by **scoluccia** » Fri 14 Sep 2007 09:32

Hi,
if I save a text in a memo field defined BLOB SUB_TYPE 1 SEGMENT SIZE 80 I lost last char insead if I define a field memo like BLOB SUB_TYPE 0 SEGMENT SIZE 80 it's work fine.
I've a big database with a lot of Memo fileds what can I do?
Thanks

Challenger · Post by **Challenger** » Tue 18 Sep 2007 15:05

Please specify the version of Delphi you use.

scoluccia · Post by **scoluccia** » Wed 19 Sep 2007 07:00

Delphi 2007 upd3, you can try with your demo Demos\Win32\BlobText\ only change the source line " ' TEXT BLOB SUB_TYPE 0' with ' TEXT BLOB SUB_TYPE 1'

Challenger · Post by **Challenger** » Fri 28 Sep 2007 06:47

According to the results of our invetigation there is no possibility to update Memo fields because of a bug in dbExpress code. Please specify the source code of the TDBXPlatform.StrToBytes function that you can find in the DbxPlatform unit. Try to perform the same operation using the standard CodeGear driver.

scoluccia · Post by **scoluccia** » Tue 02 Oct 2007 15:22

I've tried with upscene driver and it works fine, codegear driver fail when use firebird db with the follow error "Incorrect values within SQLDA
structure"
I've also tried TDBXPlatform.StrToBytes but it returns the correct number of bytes.
How can I solve this problem? I've to buy upscene driver?
thanks

Challenger · Post by **Challenger** » Wed 03 Oct 2007 08:30

The bug with truncation of memo fields is fixed. It will be included in the next build of DbxIda which will be available at the beginning of the next week. If this doesn't suit you, please contact us by e-mail at dbxida*crlab*com.