Subject | Re: [IBO] Newbie Insert SQL question. |
---|---|
Author | Helen Borrie |
Post date | 2005-02-25T22:13:19Z |
At 04:29 PM 25/02/2005 -0500, you wrote:
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
>OK, I figured it out. The TField component for the primary key has to beIn IBO you have the option to set GeneratorLinks for your inserts. At the
>set Required = False, then it works. I was deceived into thinking the
>error came from FB, not from the component, because it said "EDataBaseError".
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