How to find out, if table temporary?

Comments

• Options

  Marije_Brummel Member, Moderators Design Patterns Posts: 4,262

  2005-09-21

  You can add a boolean field to the table. When you create your temp table you set the value to TRUE

  Marije Brummel | Freelance Business Central Specialist

  0
• Options

  burki Member Posts: 4

  2005-09-23

  Mark Brummel wrote:

  You can add a boolean field to the table. When you create your temp table you set the value to TRUE

  
  Thank you, it's a practical answer to this problem. However I'm concluding, that's impossible to find out, if a table is temporary.
  
  burki

  0
• Options

  JK Member Posts: 21

  2005-09-23

  Try to delete all records :twisted:

  0
• Options

  PrebenRasmussen Member Posts: 137

  2005-09-26

  JK is a devil ! but he's darn close...
  
  If you insert a record in REC (maybe using blank keyfields or whatever) then you can check for this record in a global variable of the same type. If it exists then it is non-temporary.
  
  (You might need SELECTLATESVERSION)

  0
• Options

  Eugene Member Posts: 309

  2005-09-26

  one side effect of temp tables is that they do not participate in transactions
  this probably can be used to determine if the table is temporary

  0
• Options

  kriki Member, Moderator Posts: 9,090

  2005-09-27

  You can do this where you call the form:

  tmpRecord.FILTERGROUP(6);
  tmpRecord.SETRANGE("Some Field","Some Value");
  tmpRecord.FILTERGROUP(0);
  FORM.RUNMODAL(FORM::XYZ,tmpRecord)
  

  
  In the OnOpenForm-trigger you put:

  tmpRecord.FILTERGROUP(6);
  blnTempTable := (tmpRecord.GETFILTER("Some Field") <> '');
  tmpRecord.SETRANGE("Some Field"); //clear the filter
  tmpRecord.FILTERGROUP(0);
  

  Regards,Alain Krikilion
  No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
  
  

  0
• Options

  burki Member Posts: 4

  2005-10-04

  Thank you all for the various answers to this problem! You have been very inventive! \:D/

  0