Maxmix
Member³
Scenario:
1. We select single row from index-organized table with the syntax:
select a, b, c from U1.T1 for update
2. We select selected row (with the mouse) and click sequentially "Edit data", "Delete record", "Post changes".
PLSD replies with "1 row deleted" in the status line.
In reality, the deletion has not taken place (if we re-run the query then the row is still there).
It seems, the only one robust way is to include rowid into SELECT-LIST?
1. We select single row from index-organized table with the syntax:
select a, b, c from U1.T1 for update
2. We select selected row (with the mouse) and click sequentially "Edit data", "Delete record", "Post changes".
PLSD replies with "1 row deleted" in the status line.
In reality, the deletion has not taken place (if we re-run the query then the row is still there).
It seems, the only one robust way is to include rowid into SELECT-LIST?
