This sounds quite strange to me ..... I can easily make an ADD without using any SQL statement, just by SQLBulkOperations() and binding the needed columns ... But I can't do an UPDATE using the same logics .... Anyway , using an SQL UPDATE is unconceivable in this case, because I should make up a statement string with 255 parameters , something that I would like to avoid as long as it is possible......
--- In [email protected], Thomas Hruska <thru...@...> wrote: > > spudgun0 wrote: > > hi everybody > > > > I am using ODBC to access a database and update rows. > > How can I update a row I just fetched from a previous statement, using > > SQLBulkOperations () ? > > I read I can make an update by bookmark , but the problem is that, while I > > can successfully bind all the columns I need before SQLBulkOperations(), it > > seems there's no way to bind a bookmark column , even though MSDN talks > > about it . > > > > Please give some advice . > > Thanks > > > > > > Leo > > I'm pretty sure that to do an update, you will have to use an UPDATE SQL > statement. > > -- > Thomas Hruska > CubicleSoft President > Ph: 517-803-4197 > > *NEW* MyTaskFocus 1.1 > Get on task. Stay on task. > > http://www.CubicleSoft.com/MyTaskFocus/ >
