FORM1.RUN :- SETTABLEVIEW & Temporary Table

navuser1
navuser1 Member Posts: 1,334
edited 2014-09-26 in NAV/Navision Classic Client
Hi,

How to run a form object variable whose SETTABLEVIEW has Temporary Record set.
formobjcet.SETTABLEVIEW(TemporaryTable);
formobjcet.RUN;

kindly reply.
Now or Never

Comments

  • MBerger
    MBerger Member Posts: 413
    It is not possible to do this via a tableview, because the data isn't really in the database, and the form you are calling does not have access to the temporary table in the code you are calling from. What you can do is the following : Set "SourceTableTemporary" of the form you are calling to "yes", add a function that copies records from the original temp. table to the one of the form.
  • navuser1
    navuser1 Member Posts: 1,334
    and the form you are calling does not have access to the temporary table in the code you are calling from.

    Please explain.
    Now or Never
  • MBerger
    MBerger Member Posts: 413
    A temporary table is only in-memory for the code it is declared in and not really present in the database. SETTABLEVIEW would filter the form you are calling, but because that form will be looking at the real table in the database.
  • navuser1
    navuser1 Member Posts: 1,334 
    SourceTableTemporary" = "yes"
    Could it solve my both the purposes ?
    Actually I want to see real data & temp data from the same form object.

    In default Cronus Database, Item list form shows real data by default and now I change its
    SourceTableTemporary" = "yes" to show temp data (may be the pk which I want to display is not available in real database).

    Now will it work for both the purposes ?
    I've not tested it. :-#
    Now or Never

Categories