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
