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
_______________________________________________________