StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » UpdateUsingStoredProcedure Properties

UpdateUsingStoredProcedure Properties

StarkMike — Tue, 14 Aug 2007 09:29:27 GMT

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

RE: UpdateUsingStoredProcedure Properties

StarkMike — Tue, 14 Aug 2007 09:29:27 GMT

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

RE: UpdateUsingStoredProcedure Properties

Trent L. Taylor — Mon, 13 Aug 2007 15:04:19 GMT

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

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.

[codesnippet]DataBasics.DataSources("").SetDebugOn("C:\MyOutput.html",True)[/codesnippet]