spudgun0 wrote: > 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......
255 columns? Sounds like bad database design to me. As soon as I go over about 10 columns in a table design, I start seriously considering serialization. Anything over 10 columns hurts to think about. Anyway, here is what MSDN Library has to say on how to do updates using bookmarks/SQLBulkOperations(): http://msdn.microsoft.com/en-us/library/ms714840(VS.85).aspx If you are doing all of that and it isn't working then maybe the underlying driver for the database doesn't support that operation (in which case you could try updating both the database and ODBC manager drivers). A standard error code should be returned letting you know what the problem is. -- Thomas Hruska CubicleSoft President Ph: 517-803-4197 *NEW* MyTaskFocus 1.1 Get on task. Stay on task. http://www.CubicleSoft.com/MyTaskFocus/
