ADO - Resync datasets

I want my users to see each others committed changes immediately.
Is there a way automatically resync Client Datasets?
Can i make a trigger (or something similar) to send a signal to my application telling a record has been updated?

I'm using SQL Server 2000 and Borland Delphi 7 with ADO 2.7.Yes you can esely create a trigger that can send you an allert to your application.
I'm not working with Delphi for a long time but i think that it's possible.
Send more details in order to give you some usefull help.

Paulo

Originally posted by Olivier_Peter
I want my users to see each others committed changes immediately.
Is there a way automatically resync Client Datasets?
Can i make a trigger (or something similar) to send a signal to my application telling a record has been updated?

I'm using SQL Server 2000 and Borland Delphi 7 with ADO 2.7.|||My question is:
- how should the trigger look like in SQL Server.
- how do i catch it in delphi

I've done this before with interbase:

CREATE TRIGGER "T_ORDER_AI" FOR "T_ORDER"
ACTIVE AFTER INSERT POSITION 0
AS
BEGIN
POST_EVENT 'ORDER_UPDATE';
END

When IBEvents Triggers

procedure TFrmRestaurantMain.IBEventsEventAlert(Sender: TObject;
EventName: String; EventCount: Integer; var CancelAlerts: Boolean);
begin
if EventName = 'ORDER_UPDATE' then begin
...
end;
end;
end;