Yes, this is valid sytax. My project compiles and runs ... just leaves a
little to be desired when it runs. I will try doing everything with
FieldByName and see if that fixes it -- just hate typing all of that if I
don't have to though. Call me lazy -- I probably am. I always take the
easiest route that will acheive a given goal -- if possible.

Thanks,

Eddie

----- Original Message -----
From: Helen Borrie <helebor@...>
To: <IBObjects@egroups.com>
Sent: Wednesday, January 24, 2001 1:15 PM
Subject: Re: [IBO] IB_Query Fields -- Accessing via default array and
FieldByName accessor


> At 01:13 PM 24-01-01 -0800, you wrote:
> >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.
>
> qryATable.FieldByName('AField').AsType is correct - it is a property of
the
> object.
>
> qryATable.Fields[index].AsType is also valid.
>
> qryATable['AField'] or qryATable['ATable.AField'] don't come to mind as
> anything I recognise..
>
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________
>
>
>
>