B
Bully
If I have an SQL call e.g. SELECT * FROM Customers
In the returned recordset, how to I access the data with the table
name e.g.
rs("Customers.ID")
rs("Customers.Name")
rs("Customers.Address")
I can only get it to work without the table name e.g.
rs("ID")
rs("Name")
rs("Address")
My SQL string can change at runtime, and I may have duplicate field
names so I want to make sure I'm accessing the correct field from the
correct table.
Thanks
Jon
In the returned recordset, how to I access the data with the table
name e.g.
rs("Customers.ID")
rs("Customers.Name")
rs("Customers.Address")
I can only get it to work without the table name e.g.
rs("ID")
rs("Name")
rs("Address")
My SQL string can change at runtime, and I may have duplicate field
names so I want to make sure I'm accessing the correct field from the
correct table.
Thanks
Jon