Subject Re: [IBO] Newbie Insert SQL question.
Author Helen Borrie
At 04:29 PM 25/02/2005 -0500, you wrote:

>OK, I figured it out. The TField component for the primary key has to be
>set Required = False, then it works. I was deceived into thinking the
>error came from FB, not from the component, because it said "EDataBaseError".

In IBO you have the option to set GeneratorLinks for your inserts. At the
dataset level:


At the connection level (applies globally):


By this means, IBO will get the sequence number during the BeforeInsert
event and it will be available to the application before anything is posted
to the database.

Btw, EDatabaseError is a client-side exception, thrown on the basis of the
application's knowledge of the metadata. Exceptions returned from the
server are EIB_IscError and EIBO_IscError descendants, respectively.