Gordon,

after all these "complaints" about IBO an answer to your question
(before it's completely OT).

If you set a Query in INSERT mode there will NEVER be a trigger fired
since the trigger "happens" on the database (ie the server) when the
record is inserted.
Calling the insert mode of a query will happen on the client, it will
just do things like setting DB-controls to Readonly=false (if not
declared differently) without any network traffic;
The trigger will fire when you POST the dataset.

There're almost three years gone now since I dropped the BDE but I can't
remember that the BDE did this differently.

If you want to supply a generator generated value as an ID you can use
the Generator links. Enter:
MY_ID_FIELD=MY_GENERATORNAME
in the QueryEditor on the MasterLinks-Page in the GeneratorLinks
section.

This will cause IBO to fetch a generator value from the database for the
given generator and assign it to your keyfield (in easy(?) terms: it
will do sth. like assigning your IDField to the result of a GEN_ID (
G_MYGEENRATOR, 1 ) call.)

HTH

Luc.


Gordon Hamm schrieb:

>
> Hi, Just getting started converting an app to interbase using IBO.
>
> 1. Im trying to use existing code, where I do a simple insert. I have set up
> a trigger to create a customer number when an new rec is created, it works
> fine using console, but doesnt seem to get triggered when calling insert
> method. Im sure its something simple..
>
> 2. I cant find any help files etc. , Am I looking in the wrong place?
>
> Gordon Hamm
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/