[DUG] MSSQL DBGrid Refresh

[Eric A]

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.

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.  

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.

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?

Eric

Date: Tue, 15 May 2012 21:09:31 +1200
From: vikas.image at gmail.com
To: delphi at listserver.123.net.nz
Subject: Re: [DUG] MSSQL DBGrid Refresh

Hi Eric,
With AdoQuery you can try Requery method.
This article might help.http://edn.embarcadero.com/article/23011.

Hope it helps
RegardsVik


On Tue, May 15, 2012 at 8:51 PM, Eric A <eaa603 at hotmail.com> wrote:






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: delphi at listserver.123.net.nz

Admin: http://delphi.org.nz/mailman/listinfo/delphi

Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe



-- 
  vikas




_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: delphi at listserver.123.net.nz
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to delphi-request at listserver.123.net.nz with Subject: unsubscribe 		 	   		  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20120516/2ad1e238/attachment-0001.html