Hi Eric,<div><br></div><div>With AdoQuery you can try Requery method.</div><div><br></div><div>This article might help.</div><div><a href="http://edn.embarcadero.com/article/23011" target="_blank">http://edn.embarcadero.com/article/23011</a>.</div>
<div><br></div><div>Hope it helps</div><div><br></div><div>Regards</div><div>Vik<br><br><div class="gmail_quote">
On Tue, May 15, 2012 at 8:51 PM, Eric A <span dir="ltr"><<a href="mailto:eaa603@hotmail.com" target="_blank">eaa603@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div dir="ltr">
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.<br>
<br>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.<br><br>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? <br>
<span><font color="#888888"><br>Eric.<br> </font></span></div></div>
<br>_______________________________________________<br>
NZ Borland Developers Group - Delphi mailing list<br>
Post: <a href="mailto:delphi@listserver.123.net.nz" target="_blank">delphi@listserver.123.net.nz</a><br>
Admin: <a href="http://delphi.org.nz/mailman/listinfo/delphi" target="_blank">http://delphi.org.nz/mailman/listinfo/delphi</a><br>
Unsubscribe: send an email to <a href="mailto:delphi-request@listserver.123.net.nz" target="_blank">delphi-request@listserver.123.net.nz</a> with Subject: unsubscribe<br></blockquote></div><br><br clear="all"><div><br></div>
-- <br> vikas<br>
</div>