I sometimes need to change data manually. I double-click on the table, I navigate to the Data tab in the Object Details window, I find the record, then I attempt to modify the record, but as soon as move off the record I invariably get the message: Concurrency Violation. Expected to update 1 row(s), but actually updated 0 row(s).
My question is this. All my tables have primary keys. Why isn’t Toad able to figure out automatically the update statement it has to run to update the record? Yes, if I configure the update/delete/insert statements by selecting the Define Custom Editing option it works, but why do I have to do that, since all the information needed to infer the three statements is there already.
Is there an option to tell Toad to do it automatically?