JoelBrabant

PI-RDBMS When source table gets updated

Discussion created by JoelBrabant on Dec 16, 2011
Latest reply on Dec 16, 2011 by JoelBrabant

Is there a way to use PI-RDBMS when the source table will have some of its fields updated after the insert?

 

Works well when records are inserted but the problem is that I need to update tags at the timestamp of the insert when original record is updated.

 

It is about the reel table in a replix database.  reels are created with some fields at null and after a while, they are updated.

 

I thought about using a trigger on the source table and use a custom table to store inserted and updated timestamp and key and do a join using that table and the source but I haven't yet figured it out completely.

 

If someone has ever done something like this...

 

 

 

Thanks

Outcomes