Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Computed Field - Strange Error
Wed, Aug 14 2013 1:01 PMPermanent Link

Chris Clark

Hi

ElevateDB 2.13 Build 3

I am using a lot of computed fields within my database and I have something unusual occurring.

Throughout the application I use forms which have computed fields which update in the user interface as I change fields the computation relies upon as soon as I exit the control the computed fields are updated. This works great.

I have just created a new form, and am using a newly created table within the database and the behaviour seems to have changed. The values for those fields are now only displayed when I focus the computed field control.

None of this really makes any sense, as the forms I have previously been working on still work as expected. The only thing I can figure out which is different is that this table has been created within the database after an upgrade to 2.13 b3.

Any Suggestions greatly appreciated.
Wed, Aug 14 2013 1:18 PMPermanent Link

Chris Clark

Hi

I have discovered the issue. Adding persistent fields to the query object brought them in as fkdata instead of fkinternalcalc. Changing this has fixed everything.

I've actually checked this by dropping a new query on a form, setting the SQL and opening a query. If I add all fields it brings computed fields in as fkdata and not fkinternalcalc.

Hope this helps.
Image