I am starting to work with Strataframe and I am trying to use the UpdateStoredProcedureName = “TableName_Update” and the UpdateUsingStoreProcedure = Yes. However, when I try to use BO.Save(), I get the too many parameters error. What I do know is I am not passing the required parameters to the storeprocedure. My question is how do I pass the required parameters to the BO when using these properties?
Thanks
Your stored procedure does not have all of the proper parms. SF will pass over all of the parms for you, but you have to have your sproc created correctly on the other SQL side. I recommend looking at the help topic shown below over CRUD settings. Also, you can always turn on the debugging for the data source so you can see exactly what SF is sending to the server. It shows the query statements, parms, etc. so you can adjust your code.