Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Interbase DB help
Message
General information
Forum:
Politics
Category:
Other
Miscellaneous
Thread ID:
00627162
Message ID:
00627474
Views:
16
>>************************************
>>create trigger colTeste For mt_input
>>after update as
>>begin
>>
>> update mt_output
>
>You are calling 'update' inside a trigger defined as firing AFTER an update.....

Yes, but I want to update table mt_OUTput after an update in mt_INput. Since it is not the same table, there would be no reason for a infinite loop.

>you've set up an infiniate loop that probably crashes after user resources are consumed...

Interbase doesn't even let me create the trigger.....

I have the same trigger in an Oracle Database and it works just fine.
Like Frank said: "I did it... MY WAY!"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform