How can i get the "true" name of an aliased field?

Does any anyone know how can I get the real name of a field when using
aliases ?
I'm opening an ADO recordset with an SQL string which goes something
like
"SELECT Surname & ' ' & Name as Operator FROM People"
I'm doing this mainly for descriptive reasons, but I also need the
true source of the field ( = Surname & ' ' & Name).
DAO used to have the SourceField() method, which is not supported by
ADO.
Is there an alternative ?

Thanks! :-)

Patrick

.

Relevant Pages

  • ADO recordset
    ... I am opening a ADO recordset based on a SQL statement. ... Prev by Date: ...
    (microsoft.public.access.formscoding)
  • Re: How can i get the "true" name of an aliased field?
    ... I'm opening an ADO recordset with an SQL string which goes something ... Use rs.Source to get the sql statement that was used to populate the ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: How can i get the "true" name of an aliased field?
    ... I'm opening an ADO recordset with an SQL string which goes something ... I'm doing this mainly for descriptive reasons, ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Perform SQL command on Disconnected ADO Recordset
    ... I have an ADO recordset that I created by declaring it as new and ... perform a SQL string on it to do aggregation and other things that SQL ... Prev by Date: ...
    (microsoft.public.excel.programming)