Table Columns

[Daniel Canham]

Does anyone know of a way to query a table and receive back the names of the columns in that table. Basically
what I want to do is make a generic function that you pass a table name tol bind all column names for creating SQL
queries. If anyone knows of a way to do this, I would be appreciative.

-Dan

[David Langis]

You can retrieve a column name and data type with CDaoRecordSet::GetFieldInfo for DAO database or SQLColAttributes with SQL_COLUMN_NAME as the descriptor type for ODBC.