When clicking in a data grid, Toad locks the rows whether we intend to edit it or not. This locks the table even when just reviewing (not editing) data. Is there a way to keep Toad from locking even if just viewing?
The "select only" option disabled all ability to edit, but there are still times that update in the data grid are necessary, so this won't be an option.
Toad does not lock records until the data has been edited.
One click just selects the cell and it is not in edit mode, and there is no lock. A 2nd click puts that cell into edit mode. Or double clicking on a cell puts it into edit mode. It shouldn't lock till a user types something in. Similarly in single record view, the lock is not placed till the value of the data is changed.
Veirfy for how a users clicks in the grid.
To release the lock run a commit or rollback.
Enable the Spool SQL from the Database menu | Spool SQL | Spool to Screen, to watch the commands that Toad sends out. The lock will not be set till the value in the cell is changed and this will be reflected in the spool.
This applies to various versions of Toad.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy