Flowfields or variables?

poppinspoppins Posts: 640Member
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 Posts: 5,420Member
    if the no. of flowfields on page are less then I prefer folowfields
  • Slawek_GuzekSlawek_Guzek Posts: 962Member
    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



Sign In or Register to comment.