View Single Post

   
  #4 (permalink)  
Old 04-16-2008, 02:47 AM
Ludek Finstrle
 
Posts: n/a
Default Re: Strange problem ?

> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply With Quote