[DUG] MSSQL DBGrid Refresh

[Eric A]

I am using a DBGrid with an ADOQuery component for display, with modifications to table data (edits, deletes, adds) being done using a ADOTable component.  CRUD operations are done using the table methods rather than raw SQL code.  There's a lot of fields in the database table so coding the operations in SQL would be a pain.

Despite trying to refresh the data in the DBGrid by closing then re-opening both the ADOTable and the ADOQuery component the data in the DBGrid is not updated (unless I exit the application and restart.

I've seen this problem mentioned in various postings but haven't yet seen a solution.  Can someone supply the elusive technique to get the DBGrid data to refresh after the ADOTable data is changed?   

Eric.
 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20120515/50b6ad29/attachment.html