Re: [ psqlodbc-Bugs-1000510

From: Ludek Finstrle <luf(at)pzkagis(dot)cz>
To: Milton <milton(dot)siqueira(at)mapcardoso(dot)com(dot)br>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ psqlodbc-Bugs-1000510
Date: 2006-01-09 19:45:40
Message-ID: 20060109194540.GA2750@soptik.pzkagis.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Ludek Finstrle 2006-01-09 19:57:28 Re: [ psqlodbc-Bugs-1000509 ] TextAsLongVarchar=0 don't work
Previous Message noreply 2006-01-09 19:35:07 [ psqlodbc-Bugs-1000509 ] TextAsLongVarchar=0 don't work