When you develop applications by using Dexterity in Microsoft Dynamics GP, sometimes, you must collate data from multiple tables into a single, temporary table. These standard Dexterity temporary tables are created when they are needed. (The standard temporary tables use the physical name of TEMP.) In addition, these tables only exist when their associated table buffer exists.
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.
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.