Subject Re: [IBO] IB_Query Fields -- Accessing via default array and FieldByName accessor
Author Jason Wharton
Here are a few ideas.

First of all, masterlinks likes it when you include the name of the table
with the column separated by a period and it is always a good idea to omit
spaces around the '=' sign iin the string lists.

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


----- Original Message -----
From: "Eddie Bush" <eddie@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, January 24, 2001 6:03 PM
Subject: Re: [IBO] IB_Query Fields -- Accessing via default array and
FieldByName accessor


> FetchWholeRows = True
>
> The master relation is:
>
> Distribution(
> DistributionID Integer,
> ...
> )
>
> PK is DistributionID
>
> The detail relation is:
>
> DistributionItem(
> DistributionID Integer,
> ItemID Integer,
> Qty Integer
> );
>
> PK is DistributionID, ItemID
>
> Keylinks for the detail dataset are:
>
> DistributionID
> ItemID
>
> MasterLinks is set to DistributionID = DistributionID
>
> I set ItemID and Qty in response to use input.
>
> Any help is appreciated -- thanks!
>
> Eddie
>
> ----- Original Message -----
> From: Jason Wharton <jwharton@...>
> To: <IBObjects@egroups.com>
> Sent: Wednesday, January 24, 2001 2:36 PM
> Subject: Re: [IBO] IB_Query Fields -- Accessing via default array and
> FieldByName accessor
>
>
> > I wonder what you have for KeyLinks and if you have set the
FetchWholeRows
> > to false by mistake.
> >
> > Jason Wharton
> > CPS - Mesa AZ
> > http://www.ibobjects.com
> >
> >
> > ----- Original Message -----
> > From: "Eddie Bush" <eddie@...>
> > To: <IBObjects@egroups.com>
> > Sent: Wednesday, January 24, 2001 5:21 PM
> > Subject: Re: [IBO] IB_Query Fields -- Accessing via default array and
> > FieldByName accessor
> >
> >
> > > Ok, I aliased the fields that get updated. I still get the error:
> > >
> > > 'Field name: not found'
> > >
> > > This is really starting to irk me. I see no reason for this. It
> happens
> > > when the dataset is posted. Suggestions on things to look for?
> > >
> > > Thanks,
> > >
> > > Eddie
> > >
> > > ----- Original Message -----
> > > From: Jason Wharton <jwharton@...>
> > > To: <IBObjects@egroups.com>
> > > Sent: Wednesday, January 24, 2001 1:49 PM
> > > Subject: Re: [IBO] IB_Query Fields -- Accessing via default array and
> > > FieldByName accessor
> > >
> > >
> > > > The answer to your first question is no.
> > > >
> > > > My response to the second is to avoid having a blank field name by
> using
> > > an
> > > > alias name.
> > > >
> > > > HTH,
> > > > Jason Wharton
> > > > CPS - Mesa AZ
> > > > http://www.ibobjects.com
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: "Eddie Bush" <eddie@...>
> > > > To: <IBObjects@egroups.com>
> > > > Sent: Wednesday, January 24, 2001 2:13 PM
> > > > Subject: [IBO] IB_Query Fields -- Accessing via default array and
> > > > FieldByName accessor
> > > >
> > > >
> > > > > If you use table names in the query, must you also use them when
> > > accessing
> > > > the query via the default array and when using the
> > > > FieldByName('Field').AsType accessors?
> > > > >
> > > > > If my query is ...
> > > > >
> > > > > Select ATable.AField from ATable;
> > > > >
> > > > > Must I access AField by qryATable['AField'] or by
> > > > qryATable['ATable.AField']. I notice that this is how they show up
> when
> > > you
> > > > want to set the field for a data-aware control, but I have had luck
> > using
> > > > the non-qualified field names in the past.
> > > > >
> > > > > Currently, I have a problem where, when I refresh my dataset, it
> > claims
> > > it
> > > > cannot find a field -- the name of which is blank.
> > > > >
> > > > > Thanks in Advance!
> > > > >
> > > > > Eddie Bush
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
> >
>
>
>
>