Odbc Api

Hi,

I have two questions regarding ODBC API:

1) When using the create table sql statement how do I retrieve the results?

2) (Stupid question but it is escaping me at the moment) How can I get the string in a CString to a SQLCHAR array?

Thanks

Needaname16

This may not be entirely safe, but you can probably do this:
CString str(_T("Hello, Man"));
SQLCHAR *sqlstr = (SQLCHAR*)strdup((const char*)str);
// Call SQL function
free(sqlstr);

Thanks for the reply,

I will give that a try,

I Just noticed my first question I actually typed wrong (what can I say I haven't had much sleep lately), the sql function I need to retrieve the results from is actually the catalog function SQLTables().

Any Help on that topic would be appreciated.