Ricardo Uzcategui wrote:

> It's gona be in firebird 2.5 ?

I certainly hope not. The trigger can cancel the operation
that caused it to fire, but it can't change the state of
a transaction. If you want a condition found by a trigger
to cause your transaction to roll back, return an error and
act on it in the application.

Good luck,

Ann

>
>
> 2010/2/10 Ann W. Harrison <aharrison@...>
>
>>
>> Ismael L. Donis García wrote:
>>> I want something like:
>>>
>>> if (new.IDE > 10) then
>>> TRANSACTION ROLLBACK;
>>>
>> You can't do that. Neither triggers nor stored procedures
>> can commit or rollback transactions. Transaction control
>> belongs to the client application.
>>
>> Good luck,
>>
>> Ann
>>
>>
>
>
>