Trigger UPDATE with ObjectPtr

[Ruslan Zasukhin]

On 18/1/08 4:41 AM, "danhc at mail.dk" <danhc at mail.dk> wrote:

Hi Dan,

> Could You help me on this:
> 
> How do I in SQL create a Trigger that on an update of 1 table updates
> records in an other table, but only the ones that have an ObjectPtr
> pointing back at the table containing the Trigger.
> 
> I can't find out how to refer to the RecID og the Table containing the
> Trigger.
 
> I am using Valentina 3.5.1 for RealBasic and Mac OSX 10.4.11

You can Reffer RecID of updated record using

    NEW.RecID       for BEFORE UPDATE trigger
    OLD.RecID       for AFTER UPDATE trigger

It seems to me, you need use Stored Procedure to update records of linked
table. And call this procedure from trigger.

Ivan ?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]