Re: [DUG]: Column Names

[Neven MacEwan]

Title: Message

Stacy   Thanks, I'll use the origin (as I'm creating my own TFields) Origin is actually blank for a dynamically created fields   Neven ----- Original Message ----- From: Stacey Verner To: Multiple recipients of list delphi Sent: Tuesday, October 01, 2002 1:45 PM Subject: RE: [DUG]: Column Names 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]