Sometimes, you need a "permanent" temporary table that exists even if the table buffer no longer exists. An example of when you need a "permanent" temporary table is when you have to pass the table's contents to a background procedure. Another example is when the table has to be accessed by Microsoft SQL Server by using a pass through SQL or a stored procedure.
If the table is a system series table, the Company ID variable and the User ID variable must be the first two segments of all keys.
If the table is a company series table, the User ID variable must be the first segment of all keys. You no longer need the Company ID variable because the table is unique to the company database.
When you populate the table, make sure that you set the User ID field by using the 'User ID' of globals variable. Then, make sure that the User ID field is set for your ranges.
The following code demonstrates the previous guidelines.
range clear table TempTable;
clear table TempTable;
'User ID' of table TempTable = 'User ID' of globals;
range start table TempTable;
fill table TempTable;
'User ID' of table TempTable= 'User ID' of globals;
range end table TempTable;
fill window ScrollingWindow;
Id. de artículo: 921638 - Última revisión: 6 ene. 2015 - Revisión: 1