>>> The other day some book recommends (weird sybase consultant) to avoid
>>> Triggers ,
>>> I don't know for me in interbase/firebird seems natural to use them
>>> and i didn't have any issues with them
>>> I fact i can't imagine life without triggers or views or transactions.
>>> Anyone knows when they were introduced in interbase?
>>>
>>
>> Triggers, views, and transactions were part of InterBase V1.0 - circa
>> 1985. Views did not include group by or outer joins. From the start
>> InterBase had multiple triggers per time/action (e.g before insert)
>> and a sequence number to order them.
>>
>>
>
> Not quite. gds/Galaxy 1.0 (later renamed Interbase) has a single
> trigger per operation type per table. I didn't have the foggiest idea
> of how popular triggers would be, and how much of a pain in the butt
> combining a bunch of independent triggers into a single one would be.
> Version 2.0 supported multiple triggers per operation per table with a
> sequence number to determine firing order.
>
> Something that I've learned over the ages is that users will always
> surprise me.

From a user: having multiple triggers per action is great!!

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com