Thread: [ psqlodbc-Bugs-1010864 ] CODBCFieldInfo field type (m_nSQLType) is incorrect
Bugs item #1010864, was opened at 2010-08-05 14:39 You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010864&group_id=1000125 Category: None Group: None Status: Open Resolution: None Priority: 3 Submitted By: Mark Richardson (markmapo) Assigned to: Nobody (None) Summary: CODBCFieldInfo field type (m_nSQLType) is incorrect Initial Comment: Using the CRecordset.GetODBCFieldInfo() function to retrieve a CODBCFieldInfo about the field give incorrect values for thetypes. I only checked a couple types agains an access database... db_table_type postgres_value access_value int 4 5 double 6 8 What are the values supposed to be? Far as I can tell they are the values which come from "atldbcli.h" & "oledb.h" - butthese don't match with the access values either (poor documentation on what these values are supposed to be from MS aboutODBC - suprise?no) Also, the CRecordSet.GetTableName() is unset (so is the access database value). I don't like the way that a table name isassigned to an entire CRecordset, as each field MAY be from a different table. I prefer the way postgres has a table namefor each field - but we're stuck using the ODBC interface. Thanks guys for all the great work! Mark ---------------------------------------------------------------------- You can respond by visiting: http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1010864&group_id=1000125