Michael Van Canneyt michael.vancanneyt at wisa.be
Tue May 22 14:34:33 CEST 2001

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.


More information about the fpc-devel mailing list