Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) temporary tables

temporary tables

(0) Share

Report

Posted on by Community Member Microsoft Employee

hi,

i am having trouble using temp tables in dexterity. I am using an existing temp table (RM_Period_Sales_Analysis_Header_TEMP) and i am not sure if it has to be filled by me or if it is already filled.

also, if you know how it is filled with the corrent data in case the first situation applies

cheers

*This post is locked for comments

All responses (2)

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

Re: temporary tables

thank you david
winthropdc on at

Like (0)

Report

Re: temporary tables

When using a temporary table (table with physical name TEMP), each instance of the table buffer will create a new empty temporary table. So you will need to populate it.

If you want to access an existing instance of a table buffer to see the contents of the temporary table used by other code you will need to capture a table reference to the table.

See the Pushing the Limits conference materials for more information on how to capture the reference.

http://blogs.msdn.com/developingfordynamicsgp/archive/2008/07/24/cross-dictionary-dexterity-development.aspx

David Musgrave [MSFT]
Escalation Engineer - Microsoft Dynamics GP
Microsoft Dynamics Support - Asia Pacific

Microsoft Dynamics (formerly Microsoft Business Solutions)
http://www.microsoft.com/Dynamics

mailto:David.Musgrave@online.microsoft.com
http://blogs.msdn.com/DevelopingForDynamicsGP

Any views contained within are my personal views and not necessarily Microsoft policy.
This posting is provided "AS IS" with no warranties, and confers no rights.