Creating a Key in a Temporary Table

trainh

I have created a temporary table in a processing only report that I need sorted a particular way.

I have read through the fact that a temporary table can only have one key, but for some reason I cannot find how you can actually create the key since it is not a regular table.

Thank you.

David_Singleton

trainh wrote:

I have created a temporary table in a processing only report that I need sorted a particular way.

I have read through the fact that a temporary table can only have one key, but for some reason I cannot find how you can actually create the key since it is not a regular table.

Thank you.

Hmm you must be reading some VERY OLD documentation. TempTables now support multiple keys, and have for a long time, I think it was version 2.00 that it was introduced.

trainh

It is possible that I have old documentation, but I am still trying to understand the steps to set up a key for a temporary table.

garak

a temporary table is based in an defined table (like table 18 ). So you can use all the key in the temp. table which are existing in the based table.

Regards

trainh

Thank you!