OnCalcField Firing multiple times.

Karen · Post by **Karen** » Wed 24 Aug 2005 21:30

We are migrating our application from BDE to latest version of ODAC with Delphi 2005. The problem we are facing is that OnCalcField event on OraTable fires for every field change in Table, instead once per record.
It fires only once per record on BDE (tried under Delphi 2005).
We also tried to set AutoCalc to False, but we are not able to dropdown combobox which are based on calcualted Fields.

Any help will be highly appreciated.

Alex · Post by **Alex** » Thu 25 Aug 2005 12:36

We tried your problem under D2005 but couldn't find behaviour difference from BDE.
Please describe your problem more detailed. Show how do you change the record (in DbGrid or by code), also specify if you use filtering/sorting.
If it is possible send to ODAC support address small demo project that demonstrates it.

Karen · Post by **Karen** » Thu 25 Aug 2005 13:26

We use Filter on OraTable. Will try to send demo to support email.

Karen · Post by **Karen** » Thu 25 Aug 2005 21:42

We found out that onFilterRecord event is firing 3 times when Accept value is true for each record and 2 times when Accept Value is False . If we set the option ScrollableCursor True it fires 2 times for True & 1 Time for False Accept Value.

Any help please.