60
Hello everyone,
I have this question confusing me since forever, When do I use fields and when to use variables to have dynamics values calculated when opening a page?
what's wrong with the use of fields from a table instead of variables ?
Thanks in advance
Could you please give an example of what you mean for "dynamics values"?
If you mean flowfields, these are automatically calculated when the field is bounded to the page and it opens.
You could also do some exercises related to Autocalcfields property and SETAUTOCALCFIELDS function
docs.microsoft.com/.../setautocalcfields-function--record-
to better understand when and how these are calculated.
Be aware of the performance payload in always calculating fields, when you have a lot of records in the underlying tables.
Basically, flowfields are declared within a table and are part of the table / tableextension that you are using.
Variables, calculates values on the fly and might fit best when
a. these are used spot (e.g. just in one page or one report)
b. values comes from etherogenous sources (e.g. multiple different tables)
Up to you, as developer, to find out the best solution that fits your specific needs.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
Share
Report
All responses (
Answers (