[DUG] MSSQL DBGrid Refresh

[Vik Vasudev]

Hi Eric,

With AdoQuery you can try Requery method.

This article might help.
http://edn.embarcadero.com/article/23011.

Hope it helps

Regards
Vik

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20120515/e1e18eb5/attachment.html