Lookup Forms with FlowFields disabled

Eugene
Eugene Member Posts: 309
edited 2007-09-16 in NAV Tips & Tricks
once i had a problem with slow lookup of Item Ledger Entries.
After some analysis it became clear that the flow fields based on "Value Entry" table data were to be blamed.

so in the form 38 "Item Ledger Entries" i check for lookup mode and if it is lookup mode i make flow fields invisible.

Another alternative would be to pass temporary table (pre-filled with required records from a real one) to the lookup form

Comments

  • garak
    garak Member Posts: 3,263
    when the fields are invisible, i mean, they will still calcaulated.

    Why you does'nt run your own form :?: when you need the lookup mode
    Do you make it right, it works too!
  • kriki
    kriki Member, Moderator Posts: 9,121
    garak wrote:
    when the fields are invisible, i mean, they will still calcaulated.
    Not true. Once I had a problem with a flowfield that was 0 all the time. I noticed that it was 0 when it was NOT on the form. But for SQL, it is advised NOT to put flowfields on list-forms, even if they are not visible.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories