Subject Re: [IBO] ib_query ignores my data!
Author staff@belding

See below; trimming or not depending on the length of a field is I suggest
not wise.

----- Original Message -----
From: Jason Wharton <jwharton@...>
To: <>
Sent: Thursday, March 22, 2001 12:37 PM
Subject: Re: [IBO] ib_query ignores my data!

> Paul,
> > Just come across a little problem with ib_query.
> >
> > I have a char(1) field which sometimes contains a letter and
> > sometimes a space - IB_query.Fieldbyname('myfield').asstring
> > interprets a space as blank :-(
> >
> > Length(IB_query.Fieldbyname('myfield').asstring)=0
> Here's what I would like to do here. I want to make it so that by default
> there is no trimming of spaces when the SQLLen of the text column is only

I suggest this is not a good idea, having the behaviour of the field
dependent on the length of the field.
Length 1 is not "special". The argument for treating length 1 special could
also be made for length 2, ......
I also suggest the default behaviour should be no trimming, not right
Users should be allowed to retain right spaces.



> If it is more than one character long then I will allow it to use the
> existing default. This will solve your problem and I think behave in a
> manner that is more expected.
> Does anyone object to this shift in behavior? In short, is the default
> of trimming spaces on the right appropriate for CHAR( 1 ) columns? Should
> be for VARCHAR columns too or just CHAR?
> > no column attributes, no field properties, all default query
> > properties except connection and sql. V3.6A
> > Could really do with a quick fix/work around.
> Sorry this wasn't so quick.
> I do hope that you set the FieldsTrimming to NONE since it defaults to
> RIGHT. This would have fixed it.
> Thanks,
> Jason Wharton
> CPS - Mesa AZ
> Your use of Yahoo! Groups is subject to