Can anybody explain to me why after calling SqlCeDataAdapter.Update the
RowUpdated event is called but the error information seems incomplete?
In the event hander RowsEffected sometimes = 0 so I get the idea that there
has been an error, as a succesfull RowUpdate in my case should have 1 row
effected. If I dont set the event argument Status to
System.Data.UpdateStatus.Continue an Exception is generated which in my case
often tells me there is a primary key constraint problem. However if I set
Status = System.Data.UpdateStatus.Continue no exception is thrown (as
expected) but nor can I get detailed error information in either the event
handler or the function that called Update. I dont understand why it isnt
available in the event handler since the Row is meant to already had been
attempted to be updated. Any ideas?
Thanks
Josh