Источник:
http://alexvoy.blogspot.com/2019/05/...rnalentry.html
==============
Sometimes we want to see records before they are inserted into data base. We can do it on the SQL side by means of
with (NOLOCK) option.
Let's say we are debugging creation of SubledgerJournalEntry records. Place the following code in a new query in SQL Management Studio.
USE [AxDB]
GO
SELECT journal.ACCOUNTINGCURRENCYAMOUNT, journal.POSTINGTYPE, enum.NAME
as PostingTypeName
FROM SUBLEDGERJOURNALACCOUNTENTRY
as journal
with (NOLOCK)
JOIN ENUMVALUETABLE
as enum
ON journal.POSTINGTYPE = enum.ENUMVALUE
JOIN SubledgerJournalEntry
as sub
with (NOLOCK)
ON journal.SUBLEDGERJOURNALENTRY = sub.RecId
where sub.ACCOUNTINGEVENT = 5637159590
AND enum.ENUMID = 1811
SELECT SubledgerJournalEntry,
SUM(TransactionCurrencyAmount)
as sumTrans,
SUM(AccountingCurrencyAmount)
as sumAcc,
SUM(ReportingCurrencyAmount)
as sumRep
FROM
SubledgerJournalAccountEntry
with (NOLOCK)
inner join SubledgerJournalEntry
with (NOLOCK)
on SubledgerJournalAccountEntry.SubledgerJournalEntry = SubledgerJournalEntry.RecId
and SubledgerJournalEntry.ACCOUNTINGEVENT = 5637159590
GROUP BY SubledgerJournalAccountEntry.SubledgerJournalEntry
So, now we can see it before they are committed by ttsCommit().
Источник:
http://alexvoy.blogspot.com/2019/05/...rnalentry.html