Description:
The following operations cause the edit button for a result set to become disabled and the program continually asks if you want to discard the changes you just made to the result set.
Basically, I was editing some data in a result set and realized I needed another column for data I wanted to enter. I immediately added the column to the table but then I needed to run the select query again to retrieve the data in the new structure. At this point, the query browser asks if I want to discard the data but can't resolve what table I was working on.
How to repeat:
I had just selected results from a table
select * from a table;
Then, I clicked the edit button to edit the results (yes, this table has a primary key)
I changed a value in the table (the field color changes on the table)
Then, edit the table structure and add a new field
Apply the table structure changes.
Run the select query again.
Since you have changes in the table data, the browser will ask you if you want to discard the changes. However, it no longer recognizes the table you were working on and can't get itself out of it. New selects will bring up data but you can no longer click on the edit button. The buttons states for edit/apply changes/discard changes at the bottom of the screen will be stuck in their states from the previous table structure.
Suggested fix:
No real suggestions though it shouldn't be too hard to find in the code.
My work arounds are:
1. Discard changes before editing the table structure.
2. If problem occurs, reconnect to the database and close the old query brower window (it will ask one more time if you want to discard the changes).
