ADO field... retrieve table

[Guest]

If I have an ADO recordset that was retrieved from a SQL Select statement, how do I determine the table name associated with a particular field?

For example if it was "Select [xxx] from [yyy]", then I want something like adoRecordset.Field("xxx").tablename to return yyy

 

[Cor Ligthert]

Hi Eric,

When it was a dataset it would be dataset.tables(0).tablename, a recordset
is in my opinion a very complex object, however maybe you can find it here.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adosql/adoprg04_6qes.asp

Cor

 

[Guest]

Discovered the answer on my own: gadoRecordset.Fields("FieldName").Properties("BASETABLENAME").value is the right syntax. The recordset must be opened and connected, however. I was getting nulls when I simply retrieved the recordset with the execute method.