Can i use settableview sending a temporary table?

navusermarf
navusermarf Member Posts: 1
in NAV/Navision Classic Client
Hi friends,

How to run a form object variable whose SETTABLEVIEW has Temporary Record set.
Actually I want to see real data & temp data from the same form object.

Best Answer

  • vaprog
    vaprog Member Posts: 1,161
    Answer ✓
    What object type?

    Anyway, you need to pass in the temporary record as a parameter or build the temporary table within the object.

    Obviously, you cannot mix temporary and "real" data in one repeater / dataitem. You need to use a second dataitem, or copy the required records to the temporary table.

    SETTABLEVIEW is the same as GETVIEW on the parameter and SETVIEW on the first dataitem with the same table id. Therefore it passes on filters and key only. Not sure if all filtergroups are respected (like COPYFILTERS), or only filters in the current filtergroup (like GETFILTERS or GETVIEW).

Answers

  • vaprog
    vaprog Member Posts: 1,161
    Answer ✓
    What object type?

    Anyway, you need to pass in the temporary record as a parameter or build the temporary table within the object.

    Obviously, you cannot mix temporary and "real" data in one repeater / dataitem. You need to use a second dataitem, or copy the required records to the temporary table.

    SETTABLEVIEW is the same as GETVIEW on the parameter and SETVIEW on the first dataitem with the same table id. Therefore it passes on filters and key only. Not sure if all filtergroups are respected (like COPYFILTERS), or only filters in the current filtergroup (like GETFILTERS or GETVIEW).

Categories