You can override the fields trimming behavior I believe. Make the setting at
the connection level once and be done with it. FieldsTrimming?

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

----- Original Message -----
From: <paulhope@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, January 26, 2001 3:47 AM
Subject: [IBO] Re: ib_query ignores my data!


> Jason
>
> I got round the above problem with a very messy workround - select
> field||'X' as field, then
> myvalue=copy(fieldbyname('field').AsString,1,1)
>
> The problem lies in IBA_Column.IMP - TIB_ColumnVarText.GetValue.
> ApplyTrimming. You are right trimming non-key string fields.
>
> I'm not sure why you provide this service (is it related to padding
> of char() fields?) and am therefore not sure how to get round it
> - maybe not trim if only spaces
> - maybe not trim if only one character
> - or maybe not trim at all
> - or provide another property :-( 'TrimFields:Boolean'.
>
> I don't think the BDE trims.
>
> Regards
> Paul
>
> --- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> > This is rather strange. I'll log this as a bug. Not sure when I
> will get it
> > resolved however.
> >
> > Thanks,
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: <paulhope@a...>
> > To: <IBObjects@egroups.com>
> > Sent: Thursday, January 25, 2001 11:53 AM
> > Subject: [IBO] ib_query ignores my data!
> >
> >
> > > Just come accross 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
> > >
> > > 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.
> > >
> > > Regards
> > > Paul
> > >
> > >
> > >
> > >
> > >
>
>
>
>