[ 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