I'm in a rock and a hard spot here. I agree that length 1 probably isn't a
great idea, where to from here?

Some people want the trimming and others don't. I even get people
complaining saying that the BDE would trim for them and others complain that
the BDE didn't trim on them.

What shall we do here?

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "staff@belding" <russell@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, March 21, 2001 6:07 PM
Subject: Re: [IBO] ib_query ignores my data!


> Jason
>
> See below; trimming or not depending on the length of a field is I suggest
> not wise.
>
> ----- Original Message -----
> From: Jason Wharton <jwharton@...>
> To: <IBObjects@yahoogroups.com>
> 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
> 1.
>
> 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
> trimming.
> Users should be allowed to retain right spaces.
>
> Regards
>
> Russell
>
> > 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
> mode
> > of trimming spaces on the right appropriate for CHAR( 1 ) columns?
Should
> it
> > 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
> > http://www.ibobjects.com