Subject | Re: [IBO] Cannot Locate Record To Update |
---|---|
Author | Geoff Worboys |
Post date | 2003-07-17T19:05:16Z |
> We continually run into the error "Record not located toThis situation (can insert but not update) can arise if
> update". The database object is a TIBOTable connected to
> a TIBODatabase object. The record is created using a
> DBNavigator control, and a couple of fields are set. We
> then post using the DBNavigator.
the primary key of the table is generated in a trigger, but
you have not defined the generator to the dataset at the
client.
In the GeneratorLinks entry define
field_name=generator_name
You also need to be sure that the triggers on your table
are configured to ONLY assign a new primary key value on
insert if no value is given.
IF (New.FIELD_NAME IS NULL)
New.FIELD_NAME = gen_id(...
HTH
--
Geoff Worboys
Telesis Computing