Optimistic Conncurrency Issue

StrataFrame Forum

Back

Optimistic Conncurrency Issue

Author	Message
Clayton Hoyt	Clayton Hoyt posted 19 Years Ago Post Details Share Post
Group: Forum Members Posts: 40, Visits: 85	Here is piece of the code that won't work If intRFPID = 0 Then .NewRow() Else .FillRFPByID(intRFPID) .Edit() End If .PROSPECT_NAME = Me.txtProspect.Text .COMMENTS = Me.txtComments.Text If .Save() <> MicroFour.StrataFrame.Data.SaveUndoResult.Success Then Me.lblResult.Text = "The record was NOT saved."
	Reply Like 0
Clayton Hoyt	Clayton Hoyt posted 19 Years Ago Post Details Share Post
Group: Forum Members Posts: 40, Visits: 85	Unfortunatly, they look good...just like all the others I have that do work. The Insert works fine...I've not tried the Delete but I'd imagine it would work also. All of the sprocs were created using the DDT and I've verified that they are spelled right (I'd think if it were misspelled I'd be getting other errors anyway). I recreated them to make sure something hadn't changed. I tried rebuilding...screaming...rebooting...
	Reply Like 0
Trent Taylor	Trent Taylor posted 19 Years Ago Post Details Share Post
Group: StrataFrame Developers Posts: 6.6K, Visits: 7K	What do your CRUD settings look like on the BO? It sounds like your CRUD settings are not setup to match the stored procedure.
	Reply Like 0
Clayton Hoyt	Clayton Hoyt posted 19 Years Ago HOT Topic Details Share Topic
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
	Reply Like 0