A good tip of using Excel to analyse INSERT INTO statement captured in a Trace file

June 30, 2020 177 words One minute

Contents

More than often, you will come across INSERT INTO statements when analysing D365FO trace files.

Below is a good trick to know which values that the system was trying to insert into the tables.

First, copy everything from the statement (click on the Code section > Ctrl + A > Ctrl + C).

Paste the script into Excel.

Remove any empty rows.

Find the VALUES keyword (usually after RECID). Insert a new row right below that row you found and cut the VALUES part to it.

Before

After

Copy from VALUES to the end of the script (Choose the VALUES cell > Shift + Ctrl + Down Arrow).

Paste the copied values to any next columns, starting from the row where the very first column of the table appears.

There, you can look for the columns with their inserted corresponding values.

For example:

RecID