View Single Post
  #2 (permalink)  
Old October 11th, 2003, 07:35 AM
Jeff Mason Jeff Mason is offline
Friend of Wrox
Join Date: Jun 2003
Location: Hudson, MA, USA.
Posts: 839
Thanks: 0
Thanked 1 Time in 1 Post

It's not possible in ADO or anything else.

The alias in the SELECT clause names the column in the SQL resultset, before something like ADO even sees it. A column only has one name, which by default is the name of the original column.

You could duplicate the column in the resultset, i.e.:
SELECT ClientID, ClientID AS ID, ...
(I can't imagine why anyone would want to do this to themselves. :) I'd be interested in hearing the explanation, even if it is long...)

Jeff Mason
Custom Apps, Inc.
Reply With Quote