UpdateBatch method and checking for conflicts

[AndyHicks]

I'm having trouble checking to see if any conflicts have occurred when writing a disconnected record set back to SQL server 7.

The piece of code that I'm using works when there is just 1 record in the set, however, if there are more, then it doesn't find any conflicts.

I've doubled checked the syntax with several websites and my fellow co-workers have checked to make sure that I'm not being a complete muppet!!

Any help would be greatly appreciated and will no doubt result in my beer intake being reduced.

 

[Thead7]

It sounds like I was having the same problems with my disconnected recordsets, mine were only updating the first conflicting record and not the rest and even this did not seem to be consistant. I could find no help on this to show why this was happening, in the end I had to replace the batch update with a SQL statement.
I would really like to know why this seems to be happening, if you manage to retrieve any more info on this I would be grateful if you could let me know.
thanks.