You separate parameters with comma. Also you can use SPT parameters.
'exec ' + lcStoredProcedure + ' ' + lcParameter_Value + ',' + lcParameter2_Value
---
'exec ' + lcStoredProcedure + ' ?lcParameter_Value, ?lcParameter2_Value'
>I have some code that works just fine like this:
>
>lcParameter_Value = 'MyParam'
>lcStoredProcedure = 'MySPname'
>lcCommand = ALLTRIM('exec ' + lcStoredProcedure + ' ' + lcParameter_Value )
>lnSQLEXECResult = SQLEXEC(lnConnectionHandle , lcCommand, 'ResultSet')
>
>
>....Now I need to pass more than one parameter to the stored procedure. Anyone know how I can do that?
--sb--