Re: Strange problem ? - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: Strange problem ?
Date
Msg-id 20060124133712.GC29619@soptik.pzkagis.cz
Whole thread Raw
In response to Re: Strange problem ?  (Lothar Behrens <lothar.behrens@lollisoft.de>)
Responses Re: Strange problem ?  (Lothar Behrens <lothar.behrens@lollisoft.de>)
List pgsql-odbc
> My wrappers code (AFTER calling SQLExecDirect(...)):
                    ^^^^^^^^^^^^^^^^^^^^^^^^^^^
                    This could be the problem. You open cursor and then
                    you want change the type ...

I'm not expert in this question. I don't use ODBC frequently.

>     // Why this construct ??
>     SQLINTEGER csrType = SQL_CURSOR_KEYSET_DRIVEN;
>
>     SQLSetStmtAttr(hstmt, SQL_ATTR_CURSOR_TYPE, (SQLPOINTER)
> csrType, 0);
>
> Dave's sample works with KEYSET_DRIVEN cursors.

Keyset driven cursor isn't full dynamic cursor (ODBC spec).
Keyset driven cursor doesn't detect added or deleted rows from
other transactions.

I'm sorry I can't help you more

Luf

pgsql-odbc by date:

Previous
From: "Alejandro D. Burne"
Date:
Subject: Re: Better version of ODBC to use with each version of Postgres
Next
From: "Luiz K. Matsumura"
Date:
Subject: Re: Better version of ODBC to use with each version of Postgres