<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
No, I've tried the Requery method and as I understand it the Requery method is effectively doing the same as the Open and Close sequence, i.e. forcing the select statement to be reissued against the database.<br><br>For record deletion I call the nbDelete button method on the DBNavigator followed by closing/opening the ADOQuery and that does result in the data being refreshed in the DGBrid. <br><br>For adding and editing records I am using the ADOTable "Append"/"Edit" and "Post" methods on the table followed by closing/opening the ADOQuery (or ADOQuery.Requery) and for some reason (which presently escapes me) the data is not refreshed in the grid.<br><br>The question is should I even be using the ADOTable and would I better off just issuing raw SQL commands via the ADOCommand or similar component?<br><br>Eric<br><br><div><div id="SkyDrivePlaceholder"></div><hr id="stopSpelling">Date: Tue, 15 May 2012 21:09:31 +1200<br>From: vikas.image@gmail.com<br>To: delphi@listserver.123.net.nz<br>Subject: Re: [DUG] MSSQL DBGrid Refresh<br><br>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="ecxgmail_quote">
On Tue, May 15, 2012 at 8:51 PM, Eric A <span dir="ltr"><<a href="mailto:eaa603@hotmail.com">eaa603@hotmail.com</a>></span> wrote:<br><blockquote class="ecxgmail_quote" style="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">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">delphi-request@listserver.123.net.nz</a> with Subject: unsubscribe<br></blockquote></div><br><br clear="all"><div><br></div>
-- <br> vikas<br>
</div>
<br>_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi@listserver.123.net.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request@listserver.123.net.nz with Subject: unsubscribe</div> </div></body>
</html>