SQL Trace Log Oddness

Why would a trace file NOT include an Insert statement but would include a Delete statement? Both are to the same Postgres table. Test has been repeated multiple times with changes coded to a click of a button.

The Insert might be recorded a bit further up in the trace. It ends up being a parameterised thing that can get reused.
Other than that, no idea

Define “a trace” - what are you actually doing? What code do you have on your button? Show us the trace.

Okay, got the Insert sorted. Amazingly helpful to go back and refresh an aging brain on 3 year code, especially when the insert is included in a PG function instead of being in Clarion.

2 Likes