RE: ODBC : trying to bind the bookmark column

Tech-Archive recommends: Fix windows errors by optimizing your registry



Please make sure:
1. SQLSetStmtAttr( SQL_ATTR_USE_BOOKMARKS ) is called.
2. Use SQLBindCol to bind the column #0 and columns you would like to update

There is a sample at:
http://msdn.microsoft.com/en-us/library/ms712471(VS.85).aspx
(esp. the section: Performing Bulk Updates by Using Bookmarks)

Thanks,
Ming.
WDAC Team, Microsoft.

P.S. We recommend customers to use the forum to ask questions in the future,
where you can obtain a faster response (Forum is at:
http://social.msdn.microsoft.com/forums/en-US/sqldataaccess/threads/)


"Leo" wrote:

Greetings .
My question is as follows . I have to do an Update of a row in a Table
(MSAccess) using SQLBulkOPerations (UPDATE_BY_BOOKMARK).
I have all the columns to update already bound , all I need is to bind the
"bookmark column" (that is , column 0, following MSDN instructions) .
Can I use the SQLBindCol () as I did with other columns ?
And which kind of buffer shoud I associate to the bookmark row ?
is there a code sample I can follow to solve this problem ?
Thank you in advance.

leo

.



Relevant Pages

  • RE: ODBC : trying to bind the bookmark column
    ... Use SQLBindCol to bind the column #0 and columns you would like to update ... "Leo" wrote: ... And which kind of buffer shoud I associate to the bookmark row? ...
    (microsoft.public.data.odbc)
  • Re: Recovering keys from key events
    ... bind the key events that correspond to these actions, ... other bindings flow through. ... This is exactly how Leo works. ... making a unique callback for every binding. ...
    (comp.lang.tcl)