Subject | Re: [IBO] IB_Query Fields -- Accessing via default array and FieldByName accessor |
---|---|
Author | Eddie Bush |
Post date | 2001-01-25T02:11:11Z |
Ok. I actually didn't just paste that out of the control. I had ommitted
the table names, but had no whitespace surrounding the =. Now, when it
dies, I am put at a line in TIB_CustomGrid.UpdateRowCount:
BufferRowNum := DataRow[ TopRow + tmpInt ];
This is the line in the between try and finally. This is really weird.
Thanks again for your help!
Eddie
the table names, but had no whitespace surrounding the =. Now, when it
dies, I am put at a line in TIB_CustomGrid.UpdateRowCount:
BufferRowNum := DataRow[ TopRow + tmpInt ];
This is the line in the between try and finally. This is really weird.
Thanks again for your help!
Eddie
----- Original Message -----
From: Jason Wharton <jwharton@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, January 24, 2001 3:18 PM
Subject: Re: [IBO] IB_Query Fields -- Accessing via default array and
FieldByName accessor
> 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
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>
>
>
>