>* 1. passing some constant as a parameter using named parameters >SQLEXEC(sqlHandler, [EXEC YourSP @SomeParameter1=constant1,@SomeParameter2=constant2]) > >* 2. passing some constant as a parameter using positional parameters >SQLEXEC(sqlHandler, [EXEC YourSP constant1,constant2]) >>These constants can be anything, direct values, or if you build the string before SQLEXEC values from some variables/fields:
>SQLEXEC(sqlHandler, [EXEC YourSP @SomeParameter1=1,@SomeParameter2='blah blah']) > >* 2. passing some constant as a parameter using positional parameters >SQLEXEC(sqlHandler, [EXEC YourSP 1,'blah blah']) > >*** building the string bewfore SQLEXEC and using variables/fields >TEXT TO lcSQL NOSHOW TEXTMERGE > EXEC YourSP <<variable_field1>>,'<<variable_field2>>' >ENDTEXT >SQLEXEC(sqlHandler, lcSQL) >>