Can I retrieve column names using MFC classes

[Charles Liu]

I am developing a MFC-based program (using CRecordset and CDatabase) dealt with MS Access. I want to retrieve the column names of a table. Could I do that without using ODBC APIs?

[DiWa]

As far as I know, there is no way to get the column names with CRecordset or CDatabase. You can only use the m_hdbc member to feed it in the SQLGet**** - functions.

[tomiczek]

You can use member GetODBCFieldInfo of CRecordset: void GetODBCFieldInfo( short nIndex, CODBCFieldInfo& fieldinfo ); // Definition of CODBCFieldInfo struct CODBCFieldInfo { CString m_strName; //thats what you want SWORD m_nSQLType; UDWORD m_nPrecision; SWORD m_nScale; SWORD m_nNullability; };

[Charles Liu]

Sorry,I found that I hadn't expressed myself clearly. What I want to know is all the column names of the table, not only the names in the recordset.

[DiWa]

I think you got to do it this way (in pseudocode): SQLExecDirect( "Select * from ") SQLNumResultCols(); for( i < NumResultCols ) { SQLDescribeCol( i ) } that should do the trick. dirk