When I edit data in an editable data grid, the data changes aren’t committed to the record in the row. It only commits if I close the query and TOAD prompts me that I have changes not committed would I like to commit them. Or if I manually write the update SQL.
The little green icon (Grid is editable) is showing in my results plan. I haven’t installed TOAD in Read only mode, and the same thing happens whether or not I have AutoCommit turned on.
It’s not that big of a deal as I can always write the update statement, but I’m curious as to why it isn’t working.
I’m connecting to an oracle 11g database with TOAD 22.214.171.1248