Why variables are used on statistics pages and not fields?

(1) Share

Report

Posted on by Junior_Consultant992

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

All responses (1)

Answers (1)

Verified answer

THE Italian on at

Like (1)

Report

RE: Why variables are used on statistics pages and not fields?

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.