Re: [DUG]: Column Names

[Neven MacEwan]

Title: Message

Kyley   I still see it as a design limitation of TDataSet (or more precisely TField) since FieldName doesn't   a/ include a Table Qualifier or b/ defer to Origin for Uniqueness (my prefered solution)   in fact the whole naming of TField betrays its origin as SQL Tables do not have fields   Neven (not Nevan)   ----- Original Message ----- From: Kyley Harris To: Multiple recipients of list delphi Sent: Wednesday, October 02, 2002 9:23 AM Subject: RE: [DUG]: Column Names Nevan,   I wasn't implying that your SQL wasn't normal or correct. I was implying that the resulting renaming of the columns is perfectly normal also and has nothing at all to do with TDataset or Delphi, but the choice of naming on the database server being accessed.   I Agree that it would be nice for the server to more appropriately name columns based on origin, but it is hardly a TDataset function unless they chose to incorporate a SQL processor client side to duplicate the server functionality of interpretation.   regards   Kyley -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Neven MacEwan Sent: Wednesday, 2 October 2002 9:09 a.m. To: Multiple recipients of list delphi Subject: Re: [DUG]: Column Names Kyley   No it isn't   ''Select Store.StoreID, StoreCriteria.StoreID from Store JOIN StoreCriteria on Store.StoreID = StoreCriteria.StoreID"   is perfectly valid SQL, It stems more from the TDataSets non SQL heritage, and yes I could alias the column names but that isn't the point since the column names are unique anyway   Neven ----- Original Message ----- From: Kyley Harris To: Multiple recipients of list delphi Sent: Tuesday, October 01, 2002 5:44 PM Subject: RE: [DUG]: Column Names it is a standard SQL thing. "select Store.StoreID Store_StoreID, StoreCriteria.StoreID Crit_StoreID" naming them yourself might be more useful to you -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Neven MacEwan 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]