Kristis Makris wrote:
> 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);
> 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
Hmm both field have the same field name "id" and the driver
couldn't distinguish them. Couldn't you change the query like
"select id, id as id2 from WaterResourec"
In response to
pgsql-odbc by date
|Next:||From: Jean-Michel POURE||Date: 2002-02-20 07:35:29|
|Subject: Re: UTF-8 data migration problem in Postgresql 7.2|
|Previous:||From: kuolung lin||Date: 2002-02-20 02:28:20|