StrataFrame Forum

UpdateUsingStoredProcedure Properties

http://forum.strataframe.net/Topic10815.aspx

By StarkMike - 8/13/2007

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

By Trent L. Taylor - 8/13/2007

My question is how do I pass the required parameters to the BO when using these properties?

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.

DataBasics.DataSources("").SetDebugOn("C:\MyOutput.html",True)

By StarkMike - 8/14/2007

Thank you.  I realized I did not have the latest help file with that information.