[firebird-support] About trigger

2012-02-02 Thread nathanelrick
Hello, when i execute several insert (or update or delete), is it possible to create a trigger that will be raise not on each insert/update/delete but at the end of these "bulk" inserts ? i can off course call the stored procedure from the program but for good database integrity i prefer that t

Re: [firebird-support] About trigger

2012-02-02 Thread Tomasz Tyrakowski
Hi, I've pondered on the problem for some time. All I was able to come up with was to add an extra insert at the end of the batch, with a "special" value in one of the fields, which would be recognized by the trigger and would cause it to execute its code (otherwise the trigger just exists imm

AW: [firebird-support] About trigger

2012-02-02 Thread Nikolaus Kern
ird-support@yahoogroups.com Betreff: Re: [firebird-support] About trigger Hi, I've pondered on the problem for some time. All I was able to come up with was to add an extra insert at the end of the batch, with a "special" value in one of the fields, which would be

RE: [firebird-support] About trigger

2012-02-02 Thread Svein Erling Tysvær
>Hello, > >when i execute several insert (or update or delete), is it possible to create >a trigger that will be raise not on each >insert/update/delete but at the end of these "bulk" inserts ? i can off course >call the stored procedure from the program >but for good database integrity i prefe