Optimistic Conncurrency Issue


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
I have a BO setup to use OptimisticAllFields on Update. I use stored procedures generated by the DDT but when I run an update I get the below error:

"MicroFour.StrataFrame.Data.DataLayerSavingException: Procedure or Function 'ha_rfp_update' expects parameter '@PROSPECT_NAME_ORG', which was not supplied. ---> System.Data.SqlClient.SqlException: Procedure or Function 'ha_rfp_update' expects parameter '@PROSPECT_NAME_ORG', which was not supplied.

 -- Yada yada ----

at MicroFour.StrataFrame.Business.BusinessLayer.Save(Boolean Transactional, String TransactionKey)

at MicroFour.StrataFrame.Business.BusinessLayer.Save()

at RFPEdit.SaveRFP() in D:\TMG\HA\RFP\WEB\RFPEdit.aspx.vb:line 120"

What am I doing wrong here?

Thanks

Clay


GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Threaded View
Threaded View
Clayton Hoyt - 19 Years Ago
Trent L. Taylor - 19 Years Ago
Clayton Hoyt - 19 Years Ago
Clayton Hoyt - 19 Years Ago
Trent L. Taylor - 19 Years Ago
                         One other thing to look at...open the stored procedure through the SQL...
Trent L. Taylor - 19 Years Ago
                             Hi Trent Here are my DDT settings
Clayton Hoyt - 19 Years Ago
                                 Trent...I sent the sproc to your email.
Clayton Hoyt - 19 Years Ago
                                     Clayton...can you try something for me. Before I try to dig out all of...
Trent L. Taylor - 19 Years Ago
                                         Hi Trent I created a field name ROWVER as an INT and changed the...
Clayton Hoyt - 19 Years Ago
                                             That's a good sign....what does your update sproc look like now? Does...
Trent L. Taylor - 19 Years Ago
                                                 In the BO, I set the optimistic concurrency to rowversioning and then...
Clayton Hoyt - 19 Years Ago
                                                 Sorry...I didn't read your whole post earlier...yes...the parameter is...
Clayton Hoyt - 19 Years Ago
                                                     I know that you know how to do this....but I went ahead and created a...
Trent L. Taylor - 19 Years Ago
                                                         :D...thanks for the diplomatic response! I've done this quite a few...
Clayton Hoyt - 19 Years Ago
                                                             Ok..I know you are thinking I'm an idiot...but I have gone through...
Clayton Hoyt - 19 Years Ago
                                                                 I have also tried the following and IT WORKS Using the DDT, take...
Clayton Hoyt - 19 Years Ago
                                                                     The only thing I can think of Clayton, is that maybe your sprocs were...
StrataFrame Team - 19 Years Ago
                                                                         Hi Ben Please understand that I am not trying to be argumentative but...
Clayton Hoyt - 19 Years Ago
                                                                             Did you rebuild the partial class for the business object after you...
StrataFrame Team - 19 Years Ago
                                                                                 Hi Ben My responses are below in bold. Thanks for the help. I am...
Clayton Hoyt - 19 Years Ago
                                                                                     Well, Clayton, what you have here is a certifiable "gremlin." You...
StrataFrame Team - 19 Years Ago
                                                                                         Thanks Ben That is what I was afraid you were going to say! I'll just...
Clayton Hoyt - 19 Years Ago
                                             I tried using a sproc with only the Row ID (an Identity field) as the...
Clayton Hoyt - 19 Years Ago

Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search