How to Force a Field Calculation / Field Concatentation

This forum is for application developers who are integrating HanDBase into their solutions via the HanDBase API (HAPI) or other means. It's also a great place to discuss runtime development.

How to Force a Field Calculation / Field Concatentation

Postby hudsonhawk » Thu Mar 26, 2020 9:07 am

I've an on-going issue which I've assumed is a bug(s) but want to try and hammer at long last: my field calculations do not always work! Note this is on iOS.

I've seen this in two instances - either when the field formula is very complex involving multiple fields or most consistently when using the "Concatenate" function.

The former will happen often under the following:
- when doing calculations with multiple dependent fields
- when doing calculations with child records

The latter (concatenation) will often result in the following:
- I have the feature turned on to do it with every field edit
- what will happen is that the concatenation will often miss a field or have an incorrect value.

The fix for both of these is to open the record, edit it, and save it. Or if it involves child records, opening every child record and doing the same and then going back to the master record.

Any tips or best practices are most appreciated. Thank you.
hudsonhawk
 
Posts: 13
Joined: Sun Nov 27, 2016 4:49 pm

Re: How to Force a Field Calculation / Field Concatentation

Postby aa6vhDave » Fri Mar 27, 2020 10:35 am

Interesting.

On my Android device, the calculations are done in physical column order. So if the calculation is dependent on a column declared after the calculated column, that dependency may not yet have been updated properly. Of course, running the calculation a second time would find the dependency already updated, and would now work. Something to verify on your database.
aa6vhDave
 
Posts: 60
Joined: Mon Aug 19, 2013 1:42 pm


Return to HanDBase - Developers

Who is online

Users browsing this forum: Bing [Bot] and 1 guest

cron