Disable Posting Of Changed Fields?

[Robertio]

Hi,

We have a select statement which selects records from more than one table.
ie: select t1.c1, t1.c2, t1.rowid, t2.c1 from t1, t2 where t2.c1=t2.c2

Where we want to be able to post changes made to t1, but ignore any changes made to t2. At the moment on post (whenever t2.c1 has been changed) we get an invalid column error.

Is there any way of doing this?

Thanks

 

[Marco Kalter]

You can either set the FieldKind property of the lookup fields to fkInternalCalc, or you can set TOracleDataSet.OracleDictionary.FieldKinds to True.

------------------
Marco Kalter
Allround Automations