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
