Re: [ psqlodbc-Bugs-1000510 - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: [ psqlodbc-Bugs-1000510
Date
Msg-id 20060109194540.GA2750@soptik.pzkagis.cz
Whole thread Raw
In response to [ psqlodbc-Bugs-1000510 ] Access the rdoResultset´s column is NULL in the second access  (<noreply@pgfoundry.org> )
List pgsql-odbc
> When you click the first time in the button "Column value", i call
> first access. In the second time, i call the second access

The problem was I use "Use Declare/Fetch". I can reproduce the problem now.

I see no problem in psqlODBC driver. ADO use SQLGetData for text.
ODBC API say:
http://msdn.microsoft.com/library/en-us/odbc/htm/odbcsqlgetdata.asp?frame=true
...
1. Returns SQL_NO_DATA if it has already returned all of the data for
   the column.
...

The driver do it right this way. Are you sure you can read the data
more times? Integers and other types are picked up by another way
(SQLBindCol, SQLFetch - integer versus SQLFetch, SQLGetData - text).

Regards,

Luf

P.S. Cc: pgsql-odbc - maybe someone has some idea.

pgsql-odbc by date:

Previous
From:
Date:
Subject: [ psqlodbc-Bugs-1000509 ] TextAsLongVarchar=0 don't work
Next
From: Ludek Finstrle
Date:
Subject: Re: [ psqlodbc-Bugs-1000509 ] TextAsLongVarchar=0 don't work