StrataFrame Forum

Business object error when trying to use stored proc

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

By Bradley Marston - 1/19/2007

When i try to use a stored proc for updating a table. For example your

customers table using strataframes own Customers_Update , I receive the folowling error "Procedure or function Customers_Update has too many arguments specified."

Can somebody tell me why this is or at least how to try and debug it

By StrataFrame Team - 1/19/2007

Most likely, the business object needs to be configured to use an UpdateConcurrencyMode of RowVersion and the RowVersionOrTimestampColumn needs to be set to cust_Version.  The version field specified as an output parameter within the stored procedure and the business object needs to be configured to match.  Also, if that doesn't work, you can debug your data source.  At the bottom of the SetDataSources() method within the AppMain.vb file (or Program.cs), you can add this line to generate an HTML debug file of the data source:

MicroFour.StrataFrame.Data.DataBasics.DataSources("").SetDebugOn("C:\Debug.html", True)

By Bradley Marston - 1/19/2007

Thanks a lot for your help. That did the trick and the debug code you gave me is very useful. I have a follow up question though, I have a table with a varcharfield as a primarty key @Rese . when i look at the debug output i see a new parameter is created by strataframe @Rese_ORGPK. Will this always be the case that i have to add an extra parameter to my stored procs for this or is there a way to turn this off.

Thanks Brad

By StrataFrame Team - 1/19/2007

When you configure a business object so that the PrimaryKeyIsAutoIncremented property is False, that _ORGPK value is used to find the record on the server since you could conceivably change the PK value (since it's not an IDENTITY field on the server).  So, yes, on your table that is using a non-integer, non-identity PK, you'll need to include the extra value in the parameters list.