Share
ReportRecord 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.
You’re offline. This is a read only version of the page.
105
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.
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.
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.
By the way, which version is it about? You selected "Microsoft Dynamics AX 2012" category, but then you also attached "d365 F&O" tag.
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.
#1
André Arnaud de Cal...
293,245
Super User 2025 Season 1
#2
Martin Dráb
231,925
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
All responses (
Answers (
