VB6 / ADO / MS Sql Server field name resolution.
Posted on 2000-02-13
Using ADO to connect to MS Sql Server from VB6 we access the names of fields in the following manner.
FieldName = rs.Fields(r&).Name
In our SQL queries we sometimes need to implicitly name the table with the field name especially where joins are concerned see example...
Select Person.FullName, Person.FirstName from Person etc....
The problem is that the table name is not returned in the fieldname as it is with many of the other backend databases that we are familiar with.
Is it possible to get the source table for each field in the recordset?