too many rows affected by update

[Bryan]

I keep getting this error message when I try to do an update batch. Can anybody make any sense of it?

 

[Bryan]

sometimes the error will look like this:

 

[Bryan]

I keep getting this error message whenever I try to run a rs.updatebatch() in VB.NET. Can anybody make heads or tails of this?

 

[Bryan]

and sometimes the error looks like this:

 

[Derek Stone]

Youre either not providing the correct arguments or providing too many. Why are you using COM anyway?

 

[Bryan]

because I havent had time to learn ADO.NET

 

[Sysdev2]

At a guess Id say you are using some kind of grid control here. You will get this message when you try and update a row because, VB is saying, "hey theres nothing unique enough for me to single out this row for update". The easy solution is to add a unique key field to your table ( if you havent already got one ) and include it in the query that populates the grid. That way VB has something to unique to work with when trying to update your chosen row.

 

[Bryan]

Im not using a grid control in any way. It is just pure Database manipulation.