Hi All,

I'm struggling with a join of which I would like one field to be updateable:

simplified query:

Select A.* , B.Color from tableA A
Left join tableB B
On A.Colorid = B.Id
order by A.name

TableA has PK on field id, tableB has PK on field id.

in tableA there is a fiel PRICE. This is the ONLY field I would like to
be NOT readonly.

Using an IBOQuery, I get the message that it cannot find the record to
be updated.

I've set keylinks = A.id

and the updatesql to:

UPDATE TABLEA SET
PRICE = :PRICE
WHERE
ID = :OLD_ID

Furthermore it seems necessary to have the insert- and deletesql as
well, or the field will remain readonly?


Should I set more properties to make this one field updatable?

Thanks!

John