Group: Forum Members
Posts: 39,
Visits: 225
|
Hi,
I'm in the process of determining which data update method I'd like to utilize, and have come across a little confusion. I've set up a table, and have a select, insert and update stored procedure (labelled like tablename_Insert as per recommendations). I have a business object which connects to said table. I've put the BO onto a form, and have a save function on the form. I set the BO property InsertUsingStoredProcedure to true. When I perform a save, the system reports an error with the message that it cannot locate the stored procedure named dbo.tablename_Insert.
However, if I qualify the BO on the form by setting the InsertStoredProcedureName to databasename.dbo.tablename_Insert, the save functionality works.
Any ideas?
Thanks,
Doug.
|