SQL Server Execute - Dealing With No Results
Dear Snaplogic Community
I am calling an SQL Server Execute to return the field value of “CLI_SUR_NM” i.e. surname in the table based on a “$FinalIngenPolicyNo” primary key fed by a mapper. If the ...
Forum Discussion
Do you have the “Pass Through” option checked in the Execute snaps properties? Can you share the full configuration for the Execute snap.
Also, I wanted to mention that I don’t think you need to make the SQL Statement an expression. I think you should be able to write the last bit as follows:
CFPOL.POL_ID = $FinalIngenPolicyNo;
The snap should substitute references like that automatically.
