I have an application using TADODataSet and TADOConnection to connect with SQL Server database.
I would like to detect any modification that happens in the database.
modifications = Insert, Update, Delete
I want to know which TADODataset or which table has been modified.
I'm doing this because I have a multi-user application that works over local network. The users may add, delete or edit records in tables so I want to refresh the datasets to show the new modifications.
Also I want this to build a log.
I don't want to use TTime to keep watching the modifications.
I don't want to use triggers
I prefer a message from TADOConnection.
I'm using SQL Server 2005 and Delphi 2007 with ADO components.
New modification : I need it on SQL Server 2000
Regards.
Maybe not the answer you expect but I think you should evaluate Bold for Delphi. My employer Attracs has successfuly used Bold over ten years in a big multiuser application. Bold have many features that simplify development when application grows and things got really complicated. Currently Bold do not support Unicode so it can only be used with D2007 or older. But we have plans to fix this in the future.
Bold solve your problem by having automatic updates of gui components when another user make changes to the database.
For more information about Bold see my blog at boldfordelphi.