RE: [DUG]: Column Names

[Stacey Verner]

Title: Message

Just alias the columns and you will have no trouble. Otherwise look at TField.Origin. It sound contain DatabaseName.TableName.FieldName. I would alias it though.   eg.   select Store.StoreID as StoreStoreID, StoreCriteria.StoreID as CriteriaStoreID ...   Stacey -----Original Message----- From: Neven MacEwan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 1 October 2002 1:42 p.m. To: Multiple recipients of list delphi Subject: [DUG]: Column Names Hi all   TADOQuery given a query of "select Store.StoreID, StoreCriteria.StoreID from Store JOIN StoreCriteria on Store.StoreID = StoreCriteria.StoreID" ie 2 columns with the same 'name' but not will cause a fieldname of 'StoreID' and StoreID_1 is there any way to determine which is which ie is 'StoreID' Store.StoreID or  StoreCriteria.StoreID (without parsing the SQL) or is this an problem with TDataSet    Regards Neven  N.K. MacEwan B.E. E&E  Ph 649 621 0001  Fax 649 621 0400  [EMAIL PROTECTED]