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
> >
> >
> >
> >
> >