Notifications
Announcements
No record found.
Record of temp table after running above x++ code
What i want is to based on salesid field in inserted temp table, futher i want to insert line in same tmp table from sales line.
Please use the debugger to find out what value you're passing to SalesTable::find(). I believe it's an empty string, because you haven't loaded any value to specialInstructionTmp variable. You used it only to set an update to database, not select fetch from database. If you want to fetch data from database, use a select statement.
By the way, which version is it about? You selected "Microsoft Dynamics AX 2012" category, but then you also attached "d365 F&O" tag.
Thanks goshoom issue is resolved. By the way I used debugger but i was little confuse that after ttscommit statement i checked data in table through sql yet data was not inserted in table but when I continue the debugger the table is filled with record.
Maybe your code is called from another transaction - nothing is committed until the top-most transaction gets completed.
Also, there is a way to see uncommitted data too in SQL Server (e.g. by using NOLOCK hint).
Nevertheless the table name suggests that it's temporary. If it's InMemory temporary table, it doesn't exist in DB at all. If it's TempDB table, it can be found in TempDB database, but you would need to know the actual generated name, because there may be many instances of the same temporary table.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 692 Most Valuable Professional
André Arnaud de Cal... 558 Super User 2025 Season 2
Sohaib Cheema 364 User Group Leader
