StrataFrame Forum
Back
Login
Login
Home
»
StrataFrame Application Framework - V1
»
Business Objects and Data Access (How do I?)
»
Backend SQL Commands in BO
Backend SQL Commands in BO
Post Reply
Like
0
Backend SQL Commands in BO
View
Flat Ascending
Flat Descending
Threaded
Options
Subscribe to topic
Print This Topic
RSS Feed
Goto Topics Forum
Author
Message
Ross L. Rooker, Sr.
Ross L. Rooker, Sr.
posted 14 Years Ago
ANSWER
Topic Details
Share Topic
Group: Forum Members
Posts: 153,
Visits: 462
I know that this command in the programs file will show you the actual command sent to the backend:
MicroFour.StrataFrame.Data.DataBasics.DataSources[0].SetDebugOn("C:\\ValetLog.html", true);
What command would I insert in my base bo to get this command when SAVE is clicked. That would get me the INSERTs and UPDATEs. Then what command would I use to get the DELETE. Lastly what method in the BO would these commands be placed.
Reply
Like
0
Reply
Trent Taylor
Trent Taylor
posted 14 Years Ago
ANSWER
Post Details
Share Post
Group: StrataFrame Developers
Posts: 6.6K,
Visits: 7K
Let me see if I understand, you are wanting to capture the actual SQL command that is executed along with the parms, etc. when Save is executed on the BO, correct? If this is the case, then you will want to override the ExecuteNonQuery method in your base BO and it will give you the command that will be executed:
''' <summary>
''' Overrides the ExecuteNonQuery() method of the base class.
''' </summary>
Protected Overrides Function ExecuteNonQuery(ByVal CommandToExecute As System.Data.Common.DbCommand) As Integer
'-- You can use the CommandToExecute to pull out everything you need at this point. For example, CommandToExecute.CommandText will
' give you the command text and then you can look at the .Parameters collection to get all of the parms.
'-- Perform the standard logic
Return MyBase.ExecuteNonQuery(CommandToExecute)
End Function
Reply
Like
0
GO
Merge Selected
Merge into selected topic...
Merge into merge target...
Merge into a specific topic ID...
Open Merge
Threaded View
Threaded View
Backend SQL Commands in BO
Ross L. Rooker, Sr.
-
14 Years Ago
Let me see if I understand, you are wanting to capture the actual SQL...
Trent L. Taylor
-
14 Years Ago
I inserted this into my BaseBO. The problem is that it does not appear...
Ross L. Rooker, Sr.
-
14 Years Ago
Well, actually, now that I think about it, if you want to capture the...
Trent L. Taylor
-
14 Years Ago
In the future if you could somehow allow this to more easily be...
Ross L. Rooker, Sr.
-
14 Years Ago
Post Reply
Like
0
Similar Topics
Post Quoted Reply
Reading This Topic
Login
Login
Remember Me
Reset Password
Resend Validation Email
Login
Explore
Messages
Mentions
Search