Unable to locate stored procedure


Author
Message
Doug Zapp
Doug Zapp
StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)
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.
Replies
Doug Zapp
Doug Zapp
StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)StrataFrame User (141 reputation)
Group: Forum Members
Posts: 39, Visits: 225
Trent,



Another naive question. How does the SetDataSources method in Program.cs relate to the data connections for the Business Objects (if there is a relation at all)?



Thanks,

Doug.
Trent Taylor
Trent Taylor
StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)StrataFrame Developer (14K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
Well, this SetDataSources method is where you should be setting up the data sources for your BOs at runtime.  You can technically setup the DataSources anywhere prior to actually calling a query on a BO, but the SetDataSources method is where you define all of your connections that will be used at run-time by the BOs.
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Doug Zapp - 17 Years Ago
Peter Jones - 17 Years Ago
Trent L. Taylor - 17 Years Ago
Doug Zapp - 16 Years Ago
Edhy Rijo - 16 Years Ago
Doug Zapp - 16 Years Ago
Edhy Rijo - 16 Years Ago
Doug Zapp - 16 Years Ago
Doug Zapp - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Doug Zapp - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Doug Zapp - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Doug Zapp - 16 Years Ago
Trent L. Taylor - 16 Years Ago
Doug Zapp - 16 Years Ago
Doug Zapp - 16 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search