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:

CLIENT_NUMBER=GEN_PK_ORGANIZATION

At the connection level (applies globally):

ORGANIZATION.CLIENT_NUMBER=GEN_PK_ORGANIZATION

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.

Helen