RE: ODBC : trying to bind the bookmark column
- From: Pak-Ming Cheung - MSFT <PakMingCheungMSFT@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 20 May 2009 21:39:00 -0700
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
- Follow-Ups:
- References:
- Prev by Date: RE: SQLNumParams not called
- Next by Date: Re: Cannot Create System Dsn Odbc Data Souce as Administrator
- Previous by thread: ODBC : trying to bind the bookmark column
- Next by thread: RE: ODBC : trying to bind the bookmark column
- Index(es):
Relevant Pages
|