[fpc-devel]Triggers

[Michael Van Canneyt]

On Tue, 22 May 2001, Andrew Higgs wrote:

> Hi all,
>
> I have a trigger (before insert) on a table which does three things..
>
> 1 - Insert a line number from a generator.
> 2 - Updates a field by adding 1 to it.
> 3 - Updates a DateTime field.
>
> Can anyone explain to me why when I do an insert through isql all 3 steps are
> taken care of, but when I do an insert from an fpc (1.0.5) app using TIBQuery,
> TIBTransaction and TIBDatabase only the first step is performed? I have checked
> this a couple of times.

Do you explicitly put a value into all the fields ?
If so, the action of the trigger is cancelled.

Michael.