title: Delphi Edit DBGrid and Update Database in Read Only Mode?
body: <p>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. </p>
  
  <p>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.</p>
  
  <p>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. </p>
  
  <p>Anyone have some ideas?</p>