Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    7

    Question Unanswered: 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.

  2. #2
    Join Date
    Feb 2003
    Location
    @ home
    Posts
    163

    Re: ADO - Resync datasets

    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.

  3. #3
    Join Date
    Sep 2003
    Posts
    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;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •