Jason

> You can override the fields trimming behavior I believe. Make the

setting at

> the connection level once and be done with it. FieldsTrimming?
>

Found the property and this is the associated help . .

# Global property used to centralize settings for column attributes.
#
# Applies to
# TIB_Connection
# Declaration
# Property FieldsTrimming : TIB_StringProperty;
# Description
#
# It is possible to put entries in here based on domain names if the
# FieldEntryType property is set to include handling of domain names.

Perhaps you could illustrate how to use this to stop a field being
trimmed - sorry, the above is meaningless to me :-(

Also - should fields be trimmed by default?

Regards
Paul

> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: <paulhope@a...>
> To: <IBObjects@y...>
> 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
> > > >
> > > >
> > > >
> > > >
> > > >
> >
> >
> >
> >