John, Thanks for the suggestion, which I will try at some stage here. In the interim I've got around the problem by using the ADOQuery object instead of the ADOTable object.
Eric From: [email protected] To: [email protected] Date: Wed, 16 May 2012 15:17:28 +1200 Subject: Re: [DUG] MSSQL DBGrid Refresh You could try DBGrid.Datasource:=nil; DBGrid.Datasource:=ADOTable1; //this should force a redisplay, as nilling it clears the grid. Thats a tip I saw in the help for KBMemTable (superset of ClientDataSet) which had all sorts of tips for speeding up loading and displays. That tip will speed up posting lots of data etc as the DBGrid will not be showing the updates (which also can cause flickering). Turning it on afterwards shows the current state after all the updates have finished. John Bird From: Eric A Sent: Tuesday, May 15, 2012 8:51 PM To: [email protected] Subject: [DUG] MSSQL DBGrid Refresh 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. _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe _______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
_______________________________________________ NZ Borland Developers Group - Delphi mailing list Post: [email protected] Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to [email protected] with Subject: unsubscribe
