Click to See Complete Forum and Search --> : SQLTables()


oren y
April 23rd, 1999, 02:43 AM
hi,
i am failing to use SQLTables() to check if a given table exists in my MSAccess db.
what is wrong with this? :

CRecordset crecordset(&dbData);
retcode = SQLTables(crecordset.m_hstmt,NULL,0,NULL,0,strTable,SQL_NTS,NULL,0);

the function returns: retcode == SQL_SUCCESS, but the recordset is always empty.
any suggestions?
oren.