oTrans.Update() resets value

daroga · February 19, 2018, 7:37am

Hi,

On Purchase Order Entry, we have custom fields to change the Amend Date with reasoning. Behind this button is some code to perform the actual update. The relevant part of this code is:

row["Date01"] = (DateTime)newAmendDate;
var success = oTrans.Update();
oTrans.NotifyAll(true);

As you can see its very simple and nothing complex, however in some circumstances which are outlined below, the Update() method will reset the value of the row and it will not be saved to the database. I have tried using BeginEdit() and EndEdit() as well but to no avail.

Circumstances:

This works:

Load PO
Select Line
Modify PO Amend Date
Make another change
Save Form
Select New Line
Modify PO Amend Date

This method will make all changes as expected to the Database.

This does not work:

Load PO
Select Line
Modify PO Amend Date
Select Another Line
Modify PO Amend Date – This one fails.

I cant ask users to Save the form between lines without changing anything else as there is no binding on the field as it is all done in the code, it doesnt recognise a change and therefore Update() will not be triggered.

I am really stumped by this and have lost many hours on it. If anybody knows what may cause this I will be forever grateful.

Thanks.

P.S. Epicor version 10.1.500

surendrapal · February 19, 2018, 1:08pm

Hi Daniel,

are you not using Epicor binding? if not paste your code here to see what wrong your doing.

daroga · February 19, 2018, 1:16pm

Hi,

No i am not using epicor binding. I was not the original developer behind this so cannot explain the reason why. The full code for what happens on button click is as follows:

var edvPORel = (EpiDataView)oTrans.EpiDataViews["PORel"];
var row = edvPORel.CurrentDataRow;
if (newAmendDate != null && reason != "")
{
    try
    {
    var callContext = (EpiDataView)oTrans.EpiDataViews["CallContextClientData"];
    var userName = callContext.dataView[callContext.Row]["CurrentUserId"];
						
    var poNum = row["PONum"];
    var poLine = row["POLine"];
    var poRel = row["PORelNum"];
    var oldAmendDate = row["Date01"];
    row["Date01"] = (DateTime)newAmendDate;
    var success = oTrans.Update();
    oTrans.NotifyAll(true);
			
    using (SqlConnection connection = new SqlConnection(CONNECTION_STRING))
    {
        string qry = @"INSERT INTO nexus_po_date_log (PONum, POLine, PORelNum, OldDate, NewDate, Reason, Username) 
	    VALUES (@poNum, @poLine, @poRel, @oldDate, @newDate, @reason, @username)";
	    SqlCommand cmd = new SqlCommand(qry, connection);
	    cmd.Parameters.AddWithValue("@poNum", poNum);
	    cmd.Parameters.AddWithValue("@poLine", poLine);
	    cmd.Parameters.AddWithValue("@poRel", poRel);
	    cmd.Parameters.AddWithValue("@oldDate", oldAmendDate);
	    cmd.Parameters.AddWithValue("@newDate", newAmendDate);
	    cmd.Parameters.AddWithValue("@reason", reason);
	    cmd.Parameters.AddWithValue("@username", userName);
				
	    cmd.Connection.Open();
	    cmd.ExecuteNonQuery();
	}					
}
catch (Exception ex)
{
    throw ex;
}
} 
else 
{
    MessageBox.Show("Please select a date and provide a reason for change.");
}

The majority of this is purely logging which happens after the fact but I hope this shows everything you need.

josecgomez · February 19, 2018, 1:39pm

Try using beginedit and endedit to alert the form of the change

-Jose

daroga · February 19, 2018, 1:55pm

I did try as below but Im not sure if im using it correct. Also tried using SetModified() and AcceptChanges()

row.BeginEdit();
row["Date01"] = (DateTime)newAmendDate;
row.EndEdit();
row.AcceptChanges();
row.SetModified();
var success = oTrans.Update();
oTrans.NotifyAll(true);

josecgomez · February 19, 2018, 2:06pm

Oh yikes!
You are writing to a sql db … And directly from the UI
Hmm try setting the rowmod if the row

daroga · February 19, 2018, 2:09pm

If i add in row.RowMod = “U”; i get the error:

'System.Data.DataRow' does not contain a definition for 'RowMod' and no extension method 'RowMod' accepting a first argument of type 'System.Data.DataRow' could be found (are you missing a using directive or an assembly reference?)

josecgomez · February 19, 2018, 2:16pm

RowMod is just another field you need to quote it

daroga · February 19, 2018, 2:20pm

OK using:
row["RowMod"] = "U";

it compiles fine now however, the issue still persists

surendrapal · February 19, 2018, 2:28pm

follow these steps

add update your code Initialize

private EpiDataView _edvPORel;

public void InitializeCustomCode()
{
// ** Wizard Insert Location - Do not delete ‘Begin/End Wizard Added Variable Initialization’ lines **
// Begin Wizard Added Variable Initialization

 // End Wizard Added Variable Initialization
 this._edvPORel = ((EpiDataView)(this.oTrans.EpiDataViews["PORel"]));
 // Begin Wizard Added Custom Method Calls

 // End Wizard Added Custom Method Calls

}

public void DestroyCustomCode()

{
// ** Wizard Insert Location - Do not delete ‘Begin/End Wizard Added Object Disposal’ lines **
// Begin Wizard Added Object Disposal

 // End Wizard Added Object Disposal
 this._edvPORel = null;
 // Begin Custom Code Disposal

 // End Custom Code Disposal

}

3 var edvPORel = (EpiDataView)oTrans.EpiDataViews[“PORel”];
var row = edvPORel.CurrentDataRow;
if (newAmendDate != null && reason != “”)
{
try
{
var callContext = (EpiDataView)oTrans.EpiDataViews[“CallContextClientData”];
var userName = callContext.dataView[callContext.Row][“CurrentUserId”];

var poNum = row["PONum"];
var poLine = row["POLine"];
var poRel = row["PORelNum"];
var oldAmendDate = row["Date01"];
DataRow editRow = this._edvPORel.CurrentDataRow;;
editRow.BeginEdit();
editRow["Date01"] = (DateTime)dt_AmendDate.Value;
editRow.EndEdit();
this.oTrans.Update();
this._edvPORel.Notify(new EpiNotifyArgs(this.oTrans, this._edvPORel.Row, this._edvPORel.Column));
		
using (SqlConnection connection = new SqlConnection(CONNECTION_STRING))
{
    string qry = @"INSERT INTO nexus_po_date_log (PONum, POLine, PORelNum, OldDate, NewDate, Reason, Username) 
    VALUES (@poNum, @poLine, @poRel, @oldDate, @newDate, @reason, @username)";
    SqlCommand cmd = new SqlCommand(qry, connection);
    cmd.Parameters.AddWithValue("@poNum", poNum);
    cmd.Parameters.AddWithValue("@poLine", poLine);
    cmd.Parameters.AddWithValue("@poRel", poRel);
    cmd.Parameters.AddWithValue("@oldDate", oldAmendDate);
    cmd.Parameters.AddWithValue("@newDate", newAmendDate);
    cmd.Parameters.AddWithValue("@reason", reason);
    cmd.Parameters.AddWithValue("@username", userName);
			
    cmd.Connection.Open();
    cmd.ExecuteNonQuery();
}

}
catch (Exception ex)
{
throw ex;
}
}
else
{
MessageBox.Show(“Please select a date and provide a reason for change.”);
}

PS let me know if you have any question

daroga · February 19, 2018, 3:17pm

Unfortunately updating my code as you described didnt work. I had to make slight changes as its a static class. Could the static class be the issue? Im not sure if it needs to be static or not and if not im not sure why it was created as static

surendrapal · February 19, 2018, 3:26pm

Hi Daniel,

I am not sure why and how this code created. if you have any documentation share to get more idea or ping me on Skype surendrpal to review your code.

Thanks
Surendra Pal

surendrapal · February 26, 2018, 4:03am

@daroga please Mark this as solution and post final solution as we discussed on skype for others help in future

pchestnut · November 23, 2020, 8:28pm

I’m looking over this post to see if it can help me with a project. I see exactly how it is working. I have a Dashboard with a Tracker View and a button on it. I want to save and update the record even without changing a field. The save at the top needs a field change first. I’ve tried using oTrans.Update() but haven’t gotten it correct. I read another post that said it didn’t work on Tracker Views for them.

I put in a message so the button works and I commented out the Update. I’ve used several variations that I found but I don’t see how they are working.

private static void epiButton1_Click(object sender, System.EventArgs args)
{
// ** Place Event Handling Code Here **

MessageBox.Show(“Test Button”);
//oTrans.Update();
//oTrans.Refresh();
}

Chris_Conn · November 23, 2020, 8:42pm

I’m not sure how helpful this brief response will be but I recently had to save a record on a tracker (attachments). To do it, I had to grab the Adapter from the Form’s Transaction object using reflection. From there, it’s like using an adapter the standard way.

pchestnut · November 23, 2020, 8:45pm

Any documentation you are following?

Chris_Conn · November 23, 2020, 8:57pm

Oh no, this is definitely outside the scope of approved actions lol. You arent supposed to be able update a Tracker.

Chris_Conn · November 23, 2020, 8:59pm

I actually may have misinterpreted. I thought we were talking about a tracker (like SalesOrderTracker, etc). Sounds like you are talking about a dashboard tracker.

pchestnut · November 23, 2020, 9:00pm

Yes it is a Dashboard Tracker.

pchestnut · November 25, 2020, 2:19pm

I’m still looking for the object and code to save a record in the tracker from a button. Anyone have any suggestions to try?

Topic		Replies	Views
oTrans.Update() with no Row? Kinetic ERP bpm , customization	4	402	February 6, 2024
Updating Custom Date Field on Purchase Order Release Epicor ERP 10 e10 , customization	10	4202	February 12, 2019
Perform oTrans.Update() Epicor ERP 10 e10	4	1226	June 3, 2021
Error when trying to update PartLot through code Epicor ERP 10 e10 , customization	7	794	September 7, 2022
UBAQ Record not being picked up by Update Method Epicor ERP 10 customization , dashboard , ubaq	27	1050	April 3, 2023

oTrans.Update() resets value

Related Topics