[DUG] Delphi 7 ADO - Autorefresh of Dataset on Changes by Other Users
Eric A
eaa603 at hotmail.com
Fri Mar 11 09:12:45 NZDT 2011
I have aMicrosoft SQL Server database which has two automatic processes as "users" and one operator-driven application.
On occasions the system operator needs to delete a record and the operator's DBGrid display needs to be updated when one of the other process changes a field value in a record.
The form has a DBGrid object connected via a DataSource object to an ADOQuery object - pretty standard stuff. The only reason for using a Query object as opposed to a Table object is that I need to order the records in the DBGrid on a field other than the primary key (I didn't design this database).
How do I get the query object's data to auto refresh when one of the other processes changes or deletes a record, or alternatively how can I get notification of that event? Is there a property on the ADO Query object that I can set that will do this?
Eric
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://listserver.123.net.nz/pipermail/delphi/attachments/20110311/0e1d635e/attachment.html
More information about the Delphi
mailing list