Run a form or report on temporary tables

Comments

• Options

  Sbhat Member Posts: 301

  2003-04-17

  Hi Christian,
  
  From what i understand in your question, you could create boolean field in the table and then create a report with processing only that writes information to the table with the new boolean field added as true. In the same report you can run a report or form whatever you need and at the end you can setrange on the boolean field = true and delete all the entries from the table, this way you will not touch the existing entries and you will be deleting only the entries which are marked as true.
  
  Thanks
  
  Best regards
  Suresh
  NY.

  0
• Options

  frankmortensen Member Posts: 42

  2003-04-22

  It is possible to run af form on a temporary table.
  Use the command:
  FORM.RUN(?,TemporaryTable);
  Replace the ? with the number of the form you whish to run.
  
  Frank

  0
• Options

  SimonW Member Posts: 77

  2003-05-13

  To access the contents of a temporary table, you could use a virtual table to allow you to traverse the records (e.g. Integer)

  0
• Options

  Doomhammer Member Posts: 211

  2003-09-10

  Temporary table is created in client's memory at run-time of object (report, form). After form or report stops it's function, temporary table is deleted from memory. It is not possible to acces tmp table created in object "A" via another "B" even it is called from object "A". I tried it and I screwed-up :-(

  Martin Bokůvka, AxiomProvis

  0
• Options

  allanohlfsen Member Posts: 7

  2003-09-12

  I you want to take temporary data created or modified in object A, and reuse it in object B, you can before closing object A, transfer the tempory data to a temporary table of the same type in a single instance codeunit C.
  
  From C you can transfer the data into B.
  
  This of course only applies to versions with S.I Codeunits and is by the way not needed when A and B are forms and you call form A from form B like this:
  
  if form.runmodal(formA,tmprec)=action::something then
  ....
  ....
  
  Regards

  0
• Options

  Doomhammer Member Posts: 211

  2003-10-02

  single instance codeunits can be used only in Attain 3.60 and better. in Financials there is no such facility. sorry

  Martin Bokůvka, AxiomProvis

  0
• Options

  Francis_Malengier Member Posts: 28

  2003-10-02

  Martin,
  
  recently i dscovered that when you pass a temp table as a VAR parameter to a function, you have no problem using it in the function

  0
• Options

  StephenG Member Posts: 99

  2003-10-03

  Martin

  Temporary table is created in client's memory at run-time of object (report, form). After form or report stops it's function, temporary table is deleted from memory. It is not possible to acces tmp table created in object "A" via another "B" even it is called from object "A". I tried it and I screwed-up

  
  What you said in your quote can be done. Try this thread http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=2586
  
  The code was used in a Financials database.
  If you are using 3.60+ then S.I. codeunits are better.

  Answer the question and wait for the answer.

  0
• Options

  Doomhammer Member Posts: 211

  2003-10-14

  StephenG: thanks for link. that solution looks good.
  
  But SI Codeunits are better, I agree with you :-)

  Martin Bokůvka, AxiomProvis

  0