Yes , I agree , but that's the way it is and i can't do anything about it ... seems like those 255 fields are not totally used, but may be in the future and so the designer tried to set it ready for the worst case scenario.
Anyway I am puzzled about how I can "bind a bookmark column" : is there a code sample I can look at ? Points in the MSDN article you refer say what to do (which I already knew ) , but not how to do it .... Have I got to set the bookmark column myself ? or is it already there ready for use ? and whcih kind of data is the column ? all these things I have to know prior to binding the column , and seems I can't find any useful info about them, both on MSDN and elsewhere ..... --- In [email protected], Thomas Hruska <thru...@...> wrote: > > 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/ >
