I have created a stored procedure "UpdateValues" to update 2 columns in a record which matches a specific ID
The stored procedure executes fine in sql manager.
I am trying to execute the stored procedure within access VBA by providing the ID initially and the 2 other parameters which the record will be updated with.
the parameters within the SP are
@ID
@Value1
@Value2
i.e.
the exec command line expects my parameters, but don't know the syntax to use
sql1 = "exec UpdateValues" PARAMETERS TO PASS HERE ?
Cn1.Execute sql1
The stored procedure executes fine in sql manager.
I am trying to execute the stored procedure within access VBA by providing the ID initially and the 2 other parameters which the record will be updated with.
the parameters within the SP are
@ID
@Value1
@Value2
i.e.
the exec command line expects my parameters, but don't know the syntax to use
sql1 = "exec UpdateValues" PARAMETERS TO PASS HERE ?
Cn1.Execute sql1