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
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>