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