FORM1.RUN :- SETTABLEVIEW & Temporary Table

Comments

• Options

  MBerger Member Posts: 413

  2014-09-26

  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.

  1
• Options

  navuser1 Member Posts: 1,329

  2014-09-26

  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

  0
• Options

  MBerger Member Posts: 413

  2014-09-26

  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.

  0
• Options

  navuser1 Member Posts: 1,329

  2014-09-26

  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

  0