Subject Re: [IBO] Re: ib_query ignores my data!
Author Jason Wharton
Look in the TIB_Query component editor. It is given a user interface there.

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


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


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