Hi,

I didn't say triggers will not fire but are useless

In some cases, your application may need to know the value generated to
your PK (i.e. to refresh your dataset). And the only way with IBX is to
generate it by yourself (in your application) and not waiting for the
trigger does.

Your trigger will always fire but if it tests "if (new.pk is null) then"
it will never generate a new value

about your knowledge of embedded version, you're right.

Thierry

Sergio H. Gonzalez a écrit :

>
>
> > be careful, depending on how you set up your ibdataset, you may have to
> > generate your value by code in your application (or through the IBX
> > components using the according properties) (yes, in that specific case,
> > triggers are useless)
>
> Thanks for the input! May I ask again? I don't quite undestand... In
> what case
> triggers are useless? Shouldn't the trigger fire anyway no matter which
> component I'm using to generate the SQL ???
>
> As far as I know embeded version is *exactly* the same than client/server
> version. Except that the database can only be accessed locally. Is
> that true?
> Probably I'm missing something here... any light on this matter will
> be truly
> apreciated!!
>
> -s
>
>