5 Replies Latest reply: Apr 27, 2015 2:19 PM by Massimo Grossi RSS

    Resident Table Persistence

    Jason Freitas

      I'm trying to figure out if resident tables persist in a QVW after saving, allowing for future executions to reference those tables. I always thought they did, but I just noticed a problem with an application that suggests they don't (or something has changed in the environment that is causing different behavior).

       

      Here is an example of how I can recreate the error:

       

      Create script:

       

      Table1:

      LOAD * Inline [

      Field1

      Value1

      ];

       

      Reload and save QVW.

      Reopen the QVW and note that Table1 exists with one row in the Table Viewer.

      Alter the script (delete the old code) and replace with:

      Table2:

      LOAD

      Field1 as Field2

      Resident Table1;

       

      Upon subsequent reload, error is:

      Table not found

      Table2:

      LOAD

      Field1 as Field2

      Resident Table1

       

      Is this normal behavior? In my actual application, I don't actually delete code, of course. The difference is that the equivalent Table1 is built in an IF construct. Subsequent reloads need to reference this table that was built in a prior execution.