UpdateUsingStoredProcedure Properties


Author
Message
StarkMike
StarkMike
Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)
Group: Forum Members
Posts: 436, Visits: 944

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

Trent Taylor
Trent Taylor
StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)StrataFrame Developer (10K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
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)


StarkMike
StarkMike
Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)Advanced StrataFrame User (554 reputation)
Group: Forum Members
Posts: 436, Visits: 944
Thank you.  I realized I did not have the latest help file with that information.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search