Subject | Can't edit field after insert |
---|---|
Author | michaelgaihede |
Post date | 2004-09-25T13:14:11Z |
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
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