How to find out, if table temporary?

burki

Hi,

it's possible to find out, if a table is temporary?
I start a form by

FORM.RUNMODAL(FORM::XYZ,tmpRecord)

But it's even possible to starting normal.
In the form i need to know whether rec is temporary or not.

burki

Marije_Brummel

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

burki

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

JK

Try to delete all records :twisted:

PrebenRasmussen

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)

Eugene

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

kriki

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);

burki

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