Thread: Best way of retrieving tablename from a query ?

Best way of retrieving tablename from a query ?

From
lothar.behrens@lollisoft.de
Date:
Hi,

my last question seems to be overseen.

Isn't there a good way to get the table name from a given SQL query
without inspecting the query it self ?

My last try to use SQLColumns was partially usable. It returned a table
name, but it does not stay in relation to my query.

Thanks

Lothar

--
Lothar Behrens    |    Rapid Prototyping ...
Rosmarinstr 3        |
40235 Düsseldorf      |    www.lollisoft.de




Re: Best way of retrieving tablename from a query ?

From
lothar.behrens@lollisoft.de
Date:
Hi,

now I have found the function for this requirement.

SQLColAttribute with SQL_DESC_BASE_TABLE_NAME as the third parameter
gives me what I need.

Lothar

--
Lothar Behrens    |    Rapid Prototyping ...
Rosmarinstr 3        |
40235 Düsseldorf      |    www.lollisoft.de