Subject Re: [IBO] Cannot Locate Record To Update
Author Geoff Worboys
> We continually run into the error "Record not located to
> 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.

This situation (can insert but not update) can arise if
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