I’m attempting to perform a SQL INSERT and I need to pass in variables previously declared and set. I’ve tried standard vb.net functionality but that doesn’t seem to work. Does anyone have an example of completing this task?
ANSWER: In order to use variable(s) that have been set previously you must click on Parameters within the ‘Edit Sql’ window. In the Name field create a new variable, In as the direction, data type that matches and reference the previous variable(s) name in the Value field.