[Solved] Problem in post record-changes: tsqlquery + firebird

[rretamar]

Hi.
I have a problem with tsqlquery component in attemp to write changes in a record (post): if the table contains lookup fields or calculated fields, the program stops and show error in ApplyUpdates with these fields. "The field xxxx don't exist in dabatase"....but these fields than cause the error are lookups or calculared. WTF ????

Using the zeosllib components instead lazarus native components, the post work fine. 

Thanks ! 

[taazz]

attach a small example including the database and a form with a post button that shows the problem.

[LacaK]

Check ProviderFlags of your calculated fields.
You must exclude pfInUpdate

[rretamar]

Check ProviderFlags of your calculated fields.
You must exclude pfInUpdate

I try yo set pfInUpdate to false in all lookups and calculated fields. Work OK for loopup fields, but calculated fields continues generating error "unknown field" in TSqlquery.Applyupdates event. 

Thanks !

[BigChimp]

attach a small example including the database and a form with a post button that shows the problem.

[rretamar]

Solved !!!!

Setting the ProviderFlags properties in lookups and calculated fields as:

pfInUpdate := False

and

pfInWhere := false

The lookups and calculated fields are ignored in post. Thanks !!!!