Posted by Barbara Brazil on September 23, 2015 at 11:58:07:
In Reply to: TRACE posted by Grant Foraker on September 21, 2015 at 13:31:54:
It's going to be difficult to explain why the CASE statement doesn't show in the TRACE output. The object code for the SELECT CASEs looks very different from the source that creates it. There's no actual CASE statement in the object code. The entire SELECT is a big IF clause for all the possible matches. If the first match fails, the code branches to a place in the object code that is a few bytes after the address assigned to the second CASE so there's no source line matching that address. Hard to understand without seeing the object code, but that's why.
Your second question is easier to answer. The TRACE ON isn't listed because tracing is off when the statement is processed. The TRACE OFF is listed because tracing is on when it is processed.
Post a Followup
Each file can be a maximum of 1MB in length Uploaded files will be purged from the server on a regular basis.