Using Strata Frame's connection to the datasource...


Author
Message
StarkMike
StarkMike
Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)
Group: Forum Members
Posts: 436, Visits: 944
How do i use the connection to the database that strataframe has made to execute miscellaneous sql? select statements, stored procedures, etc.
Replies
StarkMike
StarkMike
Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)Advanced StrataFrame User (738 reputation)
Group: Forum Members
Posts: 436, Visits: 944
Ok, this was the code I used:

MicroFour.StrataFrame.Data.DataBasics.DataSources("").ExecuteStoredProcedure("STI30DeleteTagsFromInventoryTempByUserID", MicroFour.StrataFrame.Data.DbCommandExecutionType.ExecuteNonQuery, New SqlParameter("@UserID", gobjUser.UserID))




and it worked... however I forgot to specify a parameter that the stored procedure needed, and when the code ran... nothing happened... i didnt get an error message or anything. Why would it not come back and tell me that I had forgot a parameter?
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
Yes, it should have throw an SqlException indicating that a required parameter was not supplied... The stored procedure itself wouldn't have caused an error because it never would have even been executed. 
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
StarkMike - 19 Years Ago
Trent L. Taylor - 19 Years Ago
StarkMike - 19 Years Ago
StrataFrame Team - 19 Years Ago
Trent L. Taylor - 19 Years Ago
StarkMike - 19 Years Ago
StrataFrame Team - 19 Years Ago
StarkMike - 19 Years Ago
             Imports MicroFour.StrataFrame.Data...
StrataFrame Team - 19 Years Ago
StarkMike - 19 Years Ago
StrataFrame Team - 19 Years Ago
StarkMike - 19 Years Ago
Trent L. Taylor - 19 Years Ago
StarkMike - 19 Years Ago
StrataFrame Team - 19 Years Ago
     Thanks Ben!
StarkMike - 19 Years Ago
             I'm glad that worked for you :)
StrataFrame Team - 19 Years Ago
StarkMike - 19 Years Ago
Trent L. Taylor - 19 Years Ago
StarkMike - 19 Years Ago
StrataFrame Team - 18 Years Ago
Robin J Giltner - 18 Years Ago
StrataFrame Team - 18 Years Ago
                         What about with multiple users using the same application on the same...
Robin J Giltner - 18 Years Ago
                             You can still use the same key with multiple users talking to the same...
StrataFrame Team - 18 Years Ago
                                 Awesome, thanks Ben. That should save some heartache at a later date....
Robin J Giltner - 18 Years Ago
                                     No problem :)
StrataFrame Team - 18 Years Ago
Bradley Marston - 18 Years Ago
Bradley Marston - 18 Years Ago
             Hehe, will do.
StrataFrame Team - 18 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search