I have pieced together what I believe are the right steps for the initial SQL bind but it is failing silently (fields remain empty). Is there a way to debug the SQL results?
SELECT
[FirstNa],
[LastNa],
[Email]
FROM
dbo.DynamicForms_CustomTable_3978
WHERE
UniqueCompletionID = "$(UniqueCompletionID)"
I can get the UniqueCompletionID to show in a text field from the query string and when I test the SQL on the server it returns a single row.
I used the SQL tools in the SQL event to generate all the tables and actions so all the column headings and shortnames are aligned.