Trimfixeschar

Guest · Post by **Guest** » Thu 19 May 2005 20:01

Trimfixedchar options is wrong run or I am wrong use. How can I use trimfixedchar options.

I need get trimed field when I call field from SQL Server.

NOTE : I have bad english. I am sorry everybody.

Ikar · Post by **Ikar** » Fri 20 May 2005 08:39

TrimFixedChar works only for fields with fixed length. See description of this property in SDAC help.

Guest · Post by **Guest** » Mon 23 May 2005 11:48

I know that, but I am using varchar field. It is running only char field, but not run varchar field. What are you proposing to me.

Ikar · Post by **Ikar** » Mon 23 May 2005 14:44

We couldn't reproduce the problem.
Please send us (sdac*crlab*com) complete small sample to demonstrate it and include script to create server objects.

jfpicard · Post by **jfpicard** » Tue 06 Dec 2005 21:22

Got the same problem here with TrimFixedChar and I think that I know how to reproduce it.

If I have a varchar(6) field on the BD and the field got trailing blanks like
'05 ', when I do FieldByName on that Field, it returns '05 '. On BDE, it returns '05'.

Hope you will find and correct the problem soon

Thanks.

Ikar · Post by **Ikar** » Thu 08 Dec 2005 10:12

VARchar is field type with variable length. As I said before, TrimFixedChar works only for fields with fixed length.

jfpicard · Post by **jfpicard** » Thu 08 Dec 2005 15:04

I'm doing the conversion from BDE to SDAC here and we got problems with fields that are varchar and got trailing space (probably from the conversion of char to varchar). We got over 300 programs and 2500 tables. We can't do a varchar to char conversion of all tables or add TrimRight to all ours programs.

Maybe we can come to a compromise. How about addind a new property named TrimTrailingSpaces that will trim the trailing space of all string and char fields ? This way, we can have the same behavior as BDE with the TMSQuery.

Thanks.

Ikar · Post by **Ikar** » Fri 09 Dec 2005 12:03

Thank you for information. We reproduced the problem and fixed it. This fix will be included in next build.
As temporary solution just set TMSQuery.Options.FlatBuffers to True.

jfpicard · Post by **jfpicard** » Tue 03 Jan 2006 14:49

If I may ask, I was thinking that the problem was corrected in the 3.55.2.22 version.

But I've recompiled all my packages to get the same result with a varchar field on my DB. If i got a varchar(2) field named test that contain 'A ' and I do the following code (With TrimFixedChar to true) :

MSQuery1.FieldByName('test').AsString = 'A'

the result is false.

Can you give me the details of the bug fix in the version 3.55.2.22 about TrimFixedChar ?

Thanks.

Ikar · Post by **Ikar** » Thu 05 Jan 2006 13:56

> the result is false.
Do you mean SDAC 3.55.2.21 and earlier?

> Can you give me the details of the bug fix in the version 3.55.2.22 about TrimFixedChar ?

It's rather complicated, but in a few words bug appeared only if FlatBuffers property is set to True and field type is varchar and field length > 32

jfpicard · Post by **jfpicard** » Thu 05 Jan 2006 14:40

No, the result is false with the new version 3.55.2.22.

But I worked a fix in the components (We bought the source code). So maybe I can send you the files with the fixes and my little improvement on TVirtualTable ?

Thanks.

Ikar · Post by **Ikar** » Fri 06 Jan 2006 10:41

> No, the result is false with the new version 3.55.2.22.

Please send us (sdac*crlab*com) a complete small test project to reproduce the problem; it is desirable to use Northwind or Master schema objects otherwise include definition of your own database objects; don't use third party components.

> But I worked a fix in the components (We bought the source code).
> So maybe I can send you the files with the fixes and my little
> improvement on TVirtualTable ?

Usually we don't apply improvements from users.

Devart Forums

Trimfixeschar

Trimfixeschar

TrimFixedChar BDE vs SDAC