Flowfields or variables?

poppinspoppins Member Posts: 647
Hi everyone,

I have to display some fields in a page that are coming from another table.
What is the better/cleaner solution? Add the fields as flowfields in the table and just show them in the page? or add them as variables directly on the page?
The fields do not require any calculation, just showing names and bank details...

Thanks in advance :smile:

Answers

  • mohana_cse06mohana_cse06 Member Posts: 5,503
    if the no. of flowfields on page are less then I prefer folowfields
  • Slawek_GuzekSlawek_Guzek Member Posts: 1,690
    If the table is a sort of history/ledger type, where I should show the data as of when the record has been created then I am creating normal fields un a table and populate them accordigly.

    If I need something which shows me the current state of master data then I am using flowfields. Thats my basic rule of thumb.

    In my view flowfields are generally better as they let me avoid coding to keep fields synchronised, and also are saving a bit of the databasew space - at the cost of performance.

    Coding on a page is my least favourable technique as it generally performs a tad slower that the flowfields (as in new NAV flowfields are calcuated by the SQL Server not the client), and user cannot sort or filter on a calculated field.

    My £0.01

    Slawek



    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
Sign In or Register to comment.