| From: | Ludek Finstrle <luf(at)pzkagis(dot)cz> |
|---|---|
| To: | Lothar Behrens <lothar(dot)behrens(at)lollisoft(dot)de> |
| Cc: | pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: Strange problem ? |
| Date: | 2006-01-24 13:37:12 |
| Message-ID: | 20060124133712.GC29619@soptik.pzkagis.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luiz K. Matsumura | 2006-01-24 14:16:18 | Re: Better version of ODBC to use with each version of Postgres |
| Previous Message | Alejandro D. Burne | 2006-01-24 13:32:20 | Re: Better version of ODBC to use with each version of Postgres |