Hello,
I've recently begun using the v7.01.0010 ODBC driver Hiroshi made
available. I'm issuing the following SQL statement:
"SELECT id, id FROM WaterResource"
Using VC++ I'm executing the following:
++++++++++++++
while (!rsNewRecords.IsEOF())
{
rsNewRecords.GetFieldValue("id", vID, SQL_C_SLONG);
rsNewRecords.GetFieldValue(strFieldName, strValue);
[...]
rsNewRecords.MoveNext();
}
++++++++++++++
When execution hits the second .GetFieldValue() call with strFieldname
being = "id" I get an exception, something that did not happen using the
v7.01.0008 driver
As I understand, when .GetFieldName() is used once to retrieve the value
of a field, a subsequent call to retrieve the exact same field fails.
But in the case of selecting (and thus retrieving) a column twice,
shouldn't two calls be possible/allowed for reading that field's value
twice?
Thanks,
-Kristis