dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

DB Change Trigger - Progress Database

This is a discussion on DB Change Trigger - Progress Database ; Hi, with a Trigger like ON write OF cm_mstr: DO: message "customer master changed" view-as alert-box. END. I can find out when there is a change of this table during the program run. But I want to get notifications for ...



Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 11-06-2008, 12:44 PM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default DB Change Trigger

Hi,

with a Trigger like


ON write OF cm_mstr:
DO:
message "customer master changed" view-as alert-box.
END.


I can find out when there is a change of this table during the
program run.

But I want to get notifications for change of all tables,
is this also possible ?

Greetings,
Chris


Reply With Quote
  #2  
Old 11-12-2008, 11:47 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: DB Change Trigger

On 6 nov, 17:44, Christian Steins wrote:
> Hi,
>
> with a Trigger like
>
> ON write OF cm_mstr:
> DO:
> * *message "customer master changed" view-as alert-box.
> END.
>
> I can find out when there is a change of this table during the
> program run.
>
> But I want to get notifications for change of all tables,
> is this also possible ?
>
> Greetings,
> Chris


Hi ! sorry for my bad english (i'm french so ...)

i wrote little procedure that create all triggers for alls tables and
compile triggers .p

the prog is available from http://julien.arator.free.fr/progress/
Reply With Quote
  #3  
Old 11-12-2008, 11:51 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: DB Change Trigger

On 12 nov, 16:47, Julien.Ara...@gmail.com wrote:
> On 6 nov, 17:44, Christian Steins wrote:
>
>
>
> > Hi,

>
> > with a Trigger like

>
> > ON write OF cm_mstr:
> > DO:
> > * *message "customer master changed" view-as alert-box.
> > END.

>
> > I can find out when there is a change of this table during the
> > program run.

>
> > But I want to get notifications for change of all tables,
> > is this also possible ?

>
> > Greetings,
> > Chris

>
> Hi ! sorry for my bad english (i'm french so ...)
>
> i wrote little procedure that create all triggers for alls tables and
> compile triggers .p
>
> the prog is available fromhttp://julien.arator.free.fr/progress/


i'm sorry, run ProcInstall for select tables and create triggers.
Modify triggersCommon.p for manage the event
Reply With Quote
  #4  
Old 11-12-2008, 11:53 AM
Database Bot
 
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: DB Change Trigger

Julien.Arator@gmail.com schrieb:

>> i wrote little procedure that create all triggers for alls tables and
>> compile triggers .p
>>
>> the prog is available fromhttp://julien.arator.free.fr/progress/

>
> i'm sorry, run ProcInstall for select tables and create triggers.
> Modify triggersCommon.p for manage the event


Mercy,
will have a look on this...

Chris

Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -4. The time now is 06:29 AM.