FORM1.RUN :- SETTABLEVIEW & Temporary Table

navuser1

Hi,

How to run a form object variable whose SETTABLEVIEW has Temporary Record set.

formobjcet.SETTABLEVIEW(TemporaryTable);
formobjcet.RUN;

kindly reply.

MBerger

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

and the form you are calling does not have access to the temporary table in the code you are calling from.

Please explain.

MBerger

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

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. :-#