thanks, that worked.. I sort of get it I think, Im putting the control in
insert mode, but the server is requiring a the field to have a value, but it
doesnt cuz the trigger hasnt been set? I am assuming this wouldnt be an
issue if I were to issue a SQL insert statement? In otherwords, this is a
BDE design thing..

Gordon Hamm

----- Original Message -----
From: "Lucas Franzen" <luc@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, July 17, 2001 5:10 PM
Subject: Re: [IBO] IBO Help files?


>
> 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/
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>