Subject Can't edit field after insert
Author michaelgaihede
Hi,

I'm extending an old application developed using IBO 3.6d.
When inserting a new record into a joined-query with an
attached "InsertSQL" property/statement - using a TIB_Grid - the
first two fields are inserted (using lookup combos) without any
problems, while the last field - a decimal - becomes read-only in
the grid.

I've tried setting a value on the underlying field on the "After
Insert" event. That works fine and the value is displayed correctly
in the grid - but still cannot be edited.

When editing a record in the grid (using the "EditSQL" statement),
the field can be edited without any problems.
The generated "InsertSQL" statement is as follows:

INSERT INTO TSA_M_UNIT_COST(
COSTTYPE, /*PK*/
COUNTRYCODE, /*PK*/
TIMEUNITCOST)
VALUES (
:COSTTYPE,
:COUNTRYCODE,
:TIMEUNITCOST)

The problematic field - TIMEUNITCOST - is *not* declared read-only.

Any ideas will be greatly appreciated.
Best regards and thanks,

Michael