So I have a DBGrid filled with an SQL query. I want the query to be read only so the table isn't locked up while the program is running. The problem is when it is set to read only I can't edit the table at all.
What I want to do is be able to edit the fields on the DBGrid while in readonly mode and then update it after all at once so I don't have to leave the connection open.
I'm not really sure how to do this though. DBGrid doesn't have an OnChange event, so I can't just run an update query every time a cell is changed.
Anyone have some ideas?