Business Object SAVE() and Stored Procedures


Author
Message
Clayton Hoyt
Clayton Hoyt
StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)StrataFrame Novice (66 reputation)
Group: Forum Members
Posts: 40, Visits: 85
When creating a business object there are properties for the Insert, Update, and Delete sprocs. Am I correct in the following assumptions...

  • Save without a Primary Key sent through will use the Insert Sproc
  • Save with a Primary Key sent through will use the Update Sproc
  • DeleteByPrimaryKey will use the Delete Sproc

I looked through the help and the forum and hope that this isn't easily spelled out somewhere and I am missing it. Since my db will not have any reader/writer permissions, its important that I get this right from the start.

Thanks!

Clay

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
Also, in your AppMain.vb, at the bottom of the SetDataSources() method, you can call this:

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

This will turn debugging on on your data source and create that Debug.html file containing a list of the DbCommands that were executed against the data source.  It will list off all of the parameters, so, you can get a better picture of what the business object is expecting for the signsture of the stored procedure.

I believe it will also automatically show the debug file when the application exits it it exits logically.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search