Business object error when trying to use stored proc


Author
Message
Bradley Marston
Bradley Marston
StrataFrame Novice (70 reputation)StrataFrame Novice (70 reputation)StrataFrame Novice (70 reputation)StrataFrame Novice (70 reputation)StrataFrame Novice (70 reputation)StrataFrame Novice (70 reputation)StrataFrame Novice (70 reputation)StrataFrame Novice (70 reputation)StrataFrame Novice (70 reputation)
Group: Forum Members
Posts: 24, Visits: 119
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

Reply
StrataFrame Team
S
StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)StrataFrame Developer (6.5K reputation)
Group: StrataFrame Developers
Posts: 3K, Visits: 2.5K
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.
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