[Solved] Problem in post record-changes: tsqlquery + firebird
lazarus / 16-Databases

----------------------------------------------------------------------
rretamar · 2014-07-29 06:01

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 · 2014-07-29 06:47

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

----------------------------------------------------------------------
LacaK · 2014-07-29 11:13

Check ProviderFlags of your calculated fields.
You must exclude pfInUpdate

----------------------------------------------------------------------
rretamar · 2014-07-29 12:16

Quote from: LacaK on July 29, 2014, 01:13:05 pmCheck 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 · 2014-07-29 12:18

Quote from: taazz on July 29, 2014, 08:47:09 amattach a small example
including the database and a form with a post button that shows the
problem.

----------------------------------------------------------------------
rretamar · 2014-07-29 15:20

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 !!!!