MS SQL Server ODBC - How to get the table name from a resultset.

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

How to get the table name from a resultset.

Kim Andersen

2005-04-26, 9:23 am

Hello.

When I do a query - "SELECT tablealias._name FROM _user as tablealias"

How do I get the new table name via ODBC SQL calls?

I can get the column name with a SQLDescribeCol.

But when I try to get the table name with a SQLColAttribute -
SQL_COLUMN_TABLE_NAM
E.

i get the wrong table name and not "tablealias".

Can anybody help ?

/Kim

Sponsored Links