About wxODBC

Hi, all

The class wxDb has a method: GetCatalog(const wxChar *userID)
We can use it to retrieve tables' info.

But, this method return a pointer to wxDbInf.
The class wxDbInf has some fields:
wxChar catalog[128+1];
wxChar schema[128+1]; // typically means owner of table(s)
int numTables; // How many tables does this datasource have
wxDbTableInf *pTableInf; // Equals a new wxDbTableInf[numTables];

The problem is that the schema field looks wrong.
When there are multiple schemas in corresponding database,
it is the first one's name(alphabetic).
And the class wxDbTableInf don't include schema-name.

Do you know how to get full table list and their schema?
I had tried some wxWidgets methods, did not found.

If it can't, we have to let user input a SQL statement manually.

And under MS-Windows, we can use ODBC API: SQLTables method to do this.

Thanks.

-----------------------------------------------
Quan Zongliang
quanzongliang(at)gmail(dot)com
CIT Japan: http://www.cit.co.jp
CIT China: http://www.citbj.com.cn