[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