Object not set to instance of an object. Can't delete Child UD.U

system · September 20, 2013, 11:16am

Yeah I did that and it worked fine but I am in 702 must have been fixed there.

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

Quis custodiet ipsos custodes?

On Fri, Sep 20, 2013 at 11:13 AM, Marc Livingston <livingstonmarc86@...> wrote:

Â

<div> <p></p><div style="font-size:12pt;font-family:times new roman, new york, times, serif;">The customization I added does not have the added code.<br><br>To get the error, navigate to the tab 'Unit Information' under the main customer tab. Add 2 new records and then try selecting one of the records in the grid and deleting it. <br>

From: Jose Gomez <jose@…>
To: Vantage <vantage@yahoogroups.com>

Sent: Friday, September 20, 2013 10:00 AM

Subject: Re: [Vantage] RE: Object not set to instance of an object. Can't delete Child UD.UltraGrid

Â
<div> <div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;">I loaded your customization in my environment and had no problems. Do you have visual studio 2010? If so you can connect it to your customization and step through the code to identify the culplit line once we have that infromation we might be able to write something around it.</div>

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Sep 20, 2013 at 9:47 AM, Marc Livingston <livingstonmarc86@...> wrote:

Â

<div> <div style="font-size:12pt;font-family:times new roman, new york, times, serif;">Alright I added it to the 9.0 files. We are on version 9.05.701. Error comes when selecting any record in the grid on the added sheet and trying to delete.<br>

From: Jose Gomez <jose@…>
To: Vantage <vantage@yahoogroups.com>

Sent: Friday, September 20, 2013 8:02 AM
Subject: Re: [Vantage] RE: Object not set to instance of an object. Can't
delete Child UD.UltraGrid

Â
<div> <div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;">Upload or put your original customization here and let me take a look at it (What version?)</div></div><div>

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Sep 20, 2013 at 8:52 AM, <livingstonmarc86@...> wrote:

Â

<div> <div>This was Epicor's response when they could not get it to work either:</div><div>

I added the code work around to the Customization you sent me and when I did a Test Code, I received several Compile errors, complaining about duplicate code.

Â

It appears the work around Development provide was for that Customer's specific Customization and conflicts with the Customization you sent me.

Â

I informed my Team Lead and she reminded me there are no programmers in Tech Support and suggested contacting our Custom Solutions Group (CSG).

--- In vantage@yahoogroups.com, <livingstonmarc86@...> wrote:

I was trying to work with support with the above issue, but they only had a sample for the Plant form which I was not able to transfer to the Customer form.

This is the answer book they sent to me:

PROBLEM DESCRIPTION:Â In Plant Maintenance, a UD table was added to the form.Â You can create new UD records and save those records with no issue.Â However, if you have 2 or more UD records loaded in the form and you delete a UD record, the following error is received:

Â

Object reference not set to an instance of an object.

Â

PROGRAM ID:Â Customization

Â

EXPECTED BEHAVIOR:Â No error should be received.

Â

Â

Development linked the issue I reported to an existing Open (not yet resolved) SCR 82779 that is being used to track all Child UD tables issues.Â Development also provided me with a Work Around (included after my Signature Line and uses the attached Sample Customization for Plant Maintenance - you will need to modify the work around code for your needs).

***Note:Â See attached customization example step 1:

<Tools><Wizards> Reference Adapater/BLAssebmlies Wizard Select Plant Adapter and click "Finish"

Â

Â

Step 2:

Declare a class level varialbe

Â

private [static] DataTable _dtUD05;

Â

Step 3:

Clean up DataTable object in DestroyCustomCode()

Â

_dtUD05.Clear();

_dtUD05 = null;

Â

Â

Step 4:

Initialize _udUD05 in InitializeUD05Adapter() An add the DataTable to the Adapter DataSet

Â

_dtUD05 = _edvUD05.dataView.Table.Clone(); ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

Â

Â

Step 5:

Add dummy UD38 Table to Adapters DataSet in DeleteUD05Record() method if (!((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD05.TableName))

{

Â Â Â Â Â ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

}

Â

Â

Step 6:

In the Form Event Wizard Tab add a "BeforeAdapterMethod" event handler and add the following code:

Â

if (((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD38.TableName))

{

Â Â Â Â Â ((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Remove(_dtUD38);

}

Â

I have ran into issues trying to edit this for the customer form, can anyone help with this?
Â Below is my script for my customization, sorry for the long message:

// **************************************************

// Custom code for CustomerEntryForm

// Created: 8/7/2013 2:50:41 PM

// **************************************************

using System;

using System.ComponentModel;

using System.Data;

using System.Diagnostics;

using System.Windows.Forms;

using Epicor.Mfg.BO;

using Epicor.Mfg.UI;

using Epicor.Mfg.UI.Adapters;

using Epicor.Mfg.UI.Customization;

using Epicor.Mfg.UI.ExtendedProps;

using Epicor.Mfg.UI.FormFunctions;

using Epicor.Mfg.UI.FrameWork;

using Epicor.Mfg.UI.Searches;

Â

public class Script

{

Â Â Â Â Â // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **

Â Â Â Â Â // Begin Wizard Added Module Level Variables **

Â

Â Â Â Â Â private UD01Adapter _ud01Adapter;

Â Â Â Â Â private EpiDataView _edvCustomer;

Â Â Â Â Â private EpiDataView _edvUD01;

Â Â Â Â Â private string _Key1UD01;

Â Â Â Â Â private string _Key2UD01;

Â Â Â Â Â private string _Key3UD01;

Â Â Â Â Â private string _Key4UD01;

Â Â Â Â Â private string _Key5UD01;

Â Â Â Â Â private DataView Customer_DataView;

Â Â Â Â Â // End Wizard Added Module Level Variables **

Â

Â Â Â Â Â // Add Custom Module Level Variables Here **

Â

Â Â Â Â Â public void InitializeCustomCode()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **

Â Â Â Â Â Â Â Â Â Â Â // Begin Wizard Added Variable Initialization

Â

Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this.baseToolbarsManager.ToolClick += new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.CustomerEntryForm.BeforeToolClick += new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_Row.EpiRowChanged += new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView = this.Customer_Row.dataView;

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView.ListChanged += new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

Â Â Â Â Â Â Â Â Â Â Â // End Wizard Added Variable Initialization

Â

Â Â Â Â Â Â Â Â Â Â Â // Begin Wizard Added Custom Method Calls

Â

Â Â Â Â Â Â Â Â Â Â Â InitializeUD01Adapter();

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowsDeleted += new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowInsert += new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

Â Â Â Â Â Â Â Â Â Â Â // 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

Â

Â Â Â Â Â Â Â Â Â Â Â if ((this._ud01Adapter != null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.Dispose();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter = null;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._edvCustomer = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this.baseToolbarsManager.ToolClick -= new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.CustomerEntryForm.BeforeToolClick -= new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_Row.EpiRowChanged -= new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView.ListChanged -= new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView = null;

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.KeyDown -= new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowsDeleted -= new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowInsert -= new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

Â Â Â Â Â Â Â Â Â Â Â // End Wizard Added Object Disposal

Â

Â Â Â Â Â Â Â Â Â Â Â // Begin Custom Code Disposal

Â

Â Â Â Â Â Â Â Â Â Â Â // End Custom Code Disposal

Â Â Â Â Â }

Â

Â Â Â Â Â private void InitializeUD01Adapter()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Create an instance of the Adapter.

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter = new UD01Adapter(this.oTrans);

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.BOConnect();

Â

Â Â Â Â Â Â Â Â Â Â Â // Add Adapter Table to List of Views

Â Â Â Â Â Â Â Â Â Â Â // This allows you to bind controls to the custom UD Table

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01 = new EpiDataView();

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.dataView = new DataView(this._ud01Adapter.UD01Data.UD01);

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.AddEnabled = true;

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.AddText = "New Unit";

Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.EpiDataViews.ContainsKey("UD01View") == false))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this.oTrans.Add("UD01View", this._edvUD01);

Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â // Initialize EpiDataView field.

Â Â Â Â Â Â Â Â Â Â Â this._edvCustomer = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"]));

Â

Â Â Â Â Â Â Â Â Â Â Â // Set the parent view / keys for UD child view

Â Â Â Â Â Â Â Â Â Â Â string[] parentKeyFields = new string[1];

Â Â Â Â Â Â Â Â Â Â Â string[] childKeyFields = new string[1];

Â Â Â Â Â Â Â Â Â Â Â parentKeyFields[0] = "CustNum";

Â Â Â Â Â Â Â Â Â Â Â childKeyFields[0] = "Key1";

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.SetParentView(this._edvCustomer, parentKeyFields, childKeyFields);

Â

Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.PrimaryAdapter != null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // this.oTrans.PrimaryAdapter.GetCurrentDataSet(Epicor.Mfg.UI.Searches.DataSetMode.RowsDataSet).Tables.Add(this._edvUD01.dataView.Table.Clone())

Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â }

Â

Â Â Â Â Â private void GetUD01Data(string key1, string key2, string key3, string key4, string key5)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â if ((this._Key1UD01 != key1) || (this._Key2UD01 != key2) || (this._Key3UD01 != key3) || (this._Key4UD01 != key4) || (this._Key5UD01 != key5))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Build where clause for search.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â string whereClause = "Key1 = \'" + key1 + "\' And Key2 = \'" + key2 + "\' And Key3 = \'" + key3 + "\' And Key4 = \'" + key4 + "\'";

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â whereClauses.Add("Unit", whereClause);

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Call the adapter search.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.InvokeSearch(searchOptions);

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this._ud01Adapter.UD01Data.UD01.Rows.Count > 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Row = 0;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Row = -1;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Set key fields to their new values.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = key1;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = key2;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = key3;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = key4;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = key5;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void GetNewUD01Record()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â DataRow parentViewRow = this._edvCustomer.CurrentDataRow;

Â Â Â Â Â Â Â Â Â Â Â // Check for existence of Parent Row.

Â Â Â Â Â Â Â Â Â Â Â if ((parentViewRow == null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â return;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â if (this._ud01Adapter.GetaNewUD01())

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â string custnum = parentViewRow["CustNum"].ToString();

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Get unique row count id for Key5

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â int rowCount = this._ud01Adapter.UD01Data.UD01.Rows.Count;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â int lineNum = rowCount;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â bool goodIndex = false;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â while ((goodIndex == false))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Check to see if index exists

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow[] matchingRows = this._ud01Adapter.UD01Data.UD01.Select("Key5 = \'" + lineNum.ToString() + "\'");

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((matchingRows.Length > 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â lineNum = (lineNum + 1);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â goodIndex = true;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Set initial UD Key values

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow editRow = this._ud01Adapter.UD01Data.UD01.Rows[(rowCount - 1)];

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow.BeginEdit();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key1"] = custnum;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key2"] = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key3"] = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key4"] = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key5"] = lineNum.ToString();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow.EndEdit();

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, (rowCount - 1), this._edvUD01.Column));

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void SaveUD01Record()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Save adapter data

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.Update();

Â Â Â Â Â }

Â

Â Â Â Â Â private void DeleteUD01Record()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Check to see if deleted view is ancestor view

Â Â Â Â Â Â Â Â Â Â Â bool isAncestorView = false;

Â Â Â Â Â Â Â Â Â Â Â Epicor.Mfg.UI.FrameWork.EpiDataView parView = this._edvUD01.ParentView;

Â Â Â Â Â Â Â Â Â Â Â while ((parView != null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.LastView == parView))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â isAncestorView = true;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â parView = parView.ParentView;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â // If Ancestor View then delete all child rows

Â Â Â Â Â Â Â Â Â Â Â if (isAncestorView)

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow[] drsDeleted = this._ud01Adapter.UD01Data.UD01.Select("Key1 = \'" + this._Key1UD01 + "\' AND Key2 = \'" + this._Key2UD01 + "\' AND Key3 = \'" + this._Key3UD01 + "\' AND Key4 = \'" + this._Key4UD01 + "\'");

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â for (int i = 0; (i < drsDeleted.Length); i = (i + 1))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.Delete(drsDeleted[i]);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.LastView == this._edvUD01))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this._edvUD01.Row >= 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow drDeleted = ((DataRow)(this._ud01Adapter.UD01Data.UD01.Rows[this._edvUD01.Row]));

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((drDeleted != null))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if (this._ud01Adapter.Delete(drDeleted))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((_edvUD01.Row > 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â _edvUD01.Row = (_edvUD01.Row - 1);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void UndoUD01Changes()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.UD01Data.RejectChanges();

Â

Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â Â Â Â Â }

Â

Â Â Â Â Â private void ClearUD01Data()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = string.Empty;

Â

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.UD01Data.Clear();

Â

Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â Â Â Â Â }

Â

Â Â Â Â Â private void baseToolbarsManager_ToolClickForUD01(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // EpiMessageBox.Show(args.Tool.Key);

Â Â Â Â Â Â Â Â Â Â Â switch (args.Tool.Key)

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "EpiAddNewNew Unit":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â GetNewUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "ClearTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ClearUD01Data();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "DeleteTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DeleteUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "UndoTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UndoUD01Changes();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void CustomerEntryForm_BeforeToolClickForUD01(object sender, Epicor.Mfg.UI.FrameWork.BeforeToolClickEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // EpiMessageBox.Show(args.Tool.Key);

Â Â Â Â Â Â Â Â Â Â Â switch (args.Tool.Key)

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "SaveTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SaveUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void Customer_AfterRowChangeForUD01(EpiRowChangedArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // ** add AfterRowChange event handler

Â Â Â Â Â Â Â Â Â Â Â string custnum = args.CurrentView.dataView[args.CurrentRow]["CustNum"].ToString();

Â Â Â Â Â Â Â Â Â Â Â GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

Â Â Â Â Â }

Â

Â Â Â Â Â private void Customer_DataView_ListChangedForUD01(object sender, ListChangedEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // ** add ListChanged event handler

Â Â Â Â Â Â Â Â Â Â Â string custnum = Customer_DataView[0]["CustNum"].ToString();

Â Â Â Â Â Â Â Â Â Â Â GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

Â Â Â Â Â }

Â

Â Â Â Â Â private void epiUltraGridC1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Event handling code generated by wizard.

Â Â Â Â Â Â Â Â Â Â Â if ((args.KeyCode == Keys.Escape))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â try

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UndoUD01Changes();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } catch (System.Exception )

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void epiUltraGridC1_BeforeRowsDeleted(object sender, Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Event handling code generated by wizard.

Â Â Â Â Â Â Â Â Â Â Â args.Cancel = true;

Â Â Â Â Â Â Â Â Â Â Â try

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DeleteUD01Record();

Â Â Â Â Â Â Â Â Â Â Â } catch (System.Exception )

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void epiUltraGridC1_BeforeRowInsert(object sender, Infragistics.Win.UltraWinGrid.BeforeRowInsertEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Event handling code generated by wizard.

Â Â Â Â Â Â Â Â Â Â Â args.Cancel = true;

Â Â Â Â Â Â Â Â Â Â Â this.oTrans.SetCurrentEvent(TransactionEvent.AddNewOnNewFromGrid);

Â Â Â Â Â Â Â Â Â Â Â try

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SaveUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â GetNewUD01Record();

Â Â Â Â Â Â Â Â Â Â Â } catch (System.Exception )

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void CustomerEntryForm_Load(object sender, EventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Add Event Handler Code

Â Â Â Â Â EpiUltraGrid myGrid = (EpiUltraGrid)csm.GetNativeControlReference("6eae7622-3412-4609-8f63-751abdca5f7a");

Â Â Â Â Â Â Â Â myGrid.DisplayLayout.Bands[0].Columns["ShortChar07"].ValueList = epiComboC8;

Â

Â Â Â Â Â }

}

</div> <div style="color:#fff;"></div>

</div>

</div> <div style="color:#fff;"></div>

</div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · September 20, 2013, 8:51am

I was trying to work with support with the above issue, but they only had a sample for the Plant form which I was not able to transfer to the Customer form.

This is the answer book they sent to me:

PROBLEM DESCRIPTION: In Plant Maintenance, a UD table was added to the form. You can create new UD records and save those records with no issue. However, if you have 2 or more UD records loaded in the form and you delete a UD record, the following error is received:

Object reference not set to an instance of an object.

PROGRAM ID: Customization

EXPECTED BEHAVIOR: No error should be received.

Development linked the issue I reported to an existing Open (not yet resolved) SCR 82779 that is being used to track all Child UD tables issues. Development also provided me with a Work Around (included after my Signature Line and uses the attached Sample Customization for Plant Maintenance - you will need to modify the work around code for your needs).

***Note: See attached customization example step 1:

<Tools><Wizards> Reference Adapater/BLAssebmlies Wizard Select Plant Adapter and click "Finish"

Step 2:

Declare a class level varialbe

private [static] DataTable _dtUD05;

Step 3:

Clean up DataTable object in DestroyCustomCode()

_dtUD05.Clear();

_dtUD05 = null;

Step 4:

Initialize _udUD05 in InitializeUD05Adapter() An add the DataTable to the Adapter DataSet

_dtUD05 = _edvUD05.dataView.Table.Clone(); ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

Step 5:

Add dummy UD38 Table to Adapters DataSet in DeleteUD05Record() method if (!((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD05.TableName))

{

((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

}

Step 6:

In the Form Event Wizard Tab add a "BeforeAdapterMethod" event handler and add the following code:

if (((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD38.TableName))

{

((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Remove(_dtUD38);

}

I have ran into issues trying to edit this for the customer form, can anyone help with this?
Below is my script for my customization, sorry for the long message:

// **************************************************

// Custom code for CustomerEntryForm

// Created: 8/7/2013 2:50:41 PM

// **************************************************

using System;

using System.ComponentModel;

using System.Data;

using System.Diagnostics;

using System.Windows.Forms;

using Epicor.Mfg.BO;

using Epicor.Mfg.UI;

using Epicor.Mfg.UI.Adapters;

using Epicor.Mfg.UI.Customization;

using Epicor.Mfg.UI.ExtendedProps;

using Epicor.Mfg.UI.FormFunctions;

using Epicor.Mfg.UI.FrameWork;

using Epicor.Mfg.UI.Searches;

public class Script

{

// ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **

// Begin Wizard Added Module Level Variables **

private UD01Adapter _ud01Adapter;

private EpiDataView _edvCustomer;

private EpiDataView _edvUD01;

private string _Key1UD01;

private string _Key2UD01;

private string _Key3UD01;

private string _Key4UD01;

private string _Key5UD01;

private DataView Customer_DataView;

// End Wizard Added Module Level Variables **

// Add Custom Module Level Variables Here **

public void InitializeCustomCode()

{

// ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **

// Begin Wizard Added Variable Initialization

this._Key1UD01 = string.Empty;

this._Key2UD01 = string.Empty;

this._Key3UD01 = string.Empty;

this._Key4UD01 = string.Empty;

this._Key5UD01 = string.Empty;

this.baseToolbarsManager.ToolClick += new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

this.CustomerEntryForm.BeforeToolClick += new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

this.Customer_Row.EpiRowChanged += new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

this.Customer_DataView = this.Customer_Row.dataView;

this.Customer_DataView.ListChanged += new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

// End Wizard Added Variable Initialization

// Begin Wizard Added Custom Method Calls

InitializeUD01Adapter();

this.epiUltraGridC1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

this.epiUltraGridC1.BeforeRowsDeleted += new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

this.epiUltraGridC1.BeforeRowInsert += new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

// 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

if ((this._ud01Adapter != null))

{

this._ud01Adapter.Dispose();

this._ud01Adapter = null;

}

this._edvUD01 = null;

this._edvCustomer = null;

this._Key1UD01 = null;

this._Key2UD01 = null;

this._Key3UD01 = null;

this._Key4UD01 = null;

this._Key5UD01 = null;

this.baseToolbarsManager.ToolClick -= new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

this.CustomerEntryForm.BeforeToolClick -= new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

this.Customer_Row.EpiRowChanged -= new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

this.Customer_DataView.ListChanged -= new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

this.Customer_DataView = null;

this.epiUltraGridC1.KeyDown -= new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

this.epiUltraGridC1.BeforeRowsDeleted -= new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

this.epiUltraGridC1.BeforeRowInsert -= new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

// End Wizard Added Object Disposal

// Begin Custom Code Disposal

// End Custom Code Disposal

}

private void InitializeUD01Adapter()

{

// Create an instance of the Adapter.

this._ud01Adapter = new UD01Adapter(this.oTrans);

this._ud01Adapter.BOConnect();

// Add Adapter Table to List of Views

// This allows you to bind controls to the custom UD Table

this._edvUD01 = new EpiDataView();

this._edvUD01.dataView = new DataView(this._ud01Adapter.UD01Data.UD01);

this._edvUD01.AddEnabled = true;

this._edvUD01.AddText = "New Unit";

if ((this.oTrans.EpiDataViews.ContainsKey("UD01View") == false))

{

this.oTrans.Add("UD01View", this._edvUD01);

}

// Initialize EpiDataView field.

this._edvCustomer = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"]));

// Set the parent view / keys for UD child view

string[] parentKeyFields = new string[1];

string[] childKeyFields = new string[1];

parentKeyFields[0] = "CustNum";

childKeyFields[0] = "Key1";

this._edvUD01.SetParentView(this._edvCustomer, parentKeyFields, childKeyFields);

if ((this.oTrans.PrimaryAdapter != null))

{

// this.oTrans.PrimaryAdapter.GetCurrentDataSet(Epicor.Mfg.UI.Searches.DataSetMode.RowsDataSet).Tables.Add(this._edvUD01.dataView.Table.Clone())

}

private void GetUD01Data(string key1, string key2, string key3, string key4, string key5)

{

if ((this._Key1UD01 != key1) || (this._Key2UD01 != key2) || (this._Key3UD01 != key3) || (this._Key4UD01 != key4) || (this._Key5UD01 != key5))

{

// Build where clause for search.

string whereClause = "Key1 = \'" + key1 + "\' And Key2 = \'" + key2 + "\' And Key3 = \'" + key3 + "\' And Key4 = \'" + key4 + "\'";

System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);

whereClauses.Add("Unit", whereClause);

// Call the adapter search.

SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);

this._ud01Adapter.InvokeSearch(searchOptions);

if ((this._ud01Adapter.UD01Data.UD01.Rows.Count > 0))

{

this._edvUD01.Row = 0;

} else

{

this._edvUD01.Row = -1;

}

// Notify that data was updated.

this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

// Set key fields to their new values.

this._Key1UD01 = key1;

this._Key2UD01 = key2;

this._Key3UD01 = key3;

this._Key4UD01 = key4;

this._Key5UD01 = key5;

}

private void GetNewUD01Record()

{

DataRow parentViewRow = this._edvCustomer.CurrentDataRow;

// Check for existence of Parent Row.

if ((parentViewRow == null))

{

return;

}

if (this._ud01Adapter.GetaNewUD01())

{

string custnum = parentViewRow["CustNum"].ToString();

// Get unique row count id for Key5

int rowCount = this._ud01Adapter.UD01Data.UD01.Rows.Count;

int lineNum = rowCount;

bool goodIndex = false;

while ((goodIndex == false))

{

// Check to see if index exists

DataRow[] matchingRows = this._ud01Adapter.UD01Data.UD01.Select("Key5 = \'" + lineNum.ToString() + "\'");

if ((matchingRows.Length > 0))

{

lineNum = (lineNum + 1);

} else

{

goodIndex = true;

}

// Set initial UD Key values

DataRow editRow = this._ud01Adapter.UD01Data.UD01.Rows[(rowCount - 1)];

editRow.BeginEdit();

editRow["Key1"] = custnum;

editRow["Key2"] = string.Empty;

editRow["Key3"] = string.Empty;

editRow["Key4"] = string.Empty;

editRow["Key5"] = lineNum.ToString();

editRow.EndEdit();

// Notify that data was updated.

this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, (rowCount - 1), this._edvUD01.Column));

}

private void SaveUD01Record()

{

// Save adapter data

this._ud01Adapter.Update();

}

private void DeleteUD01Record()

{

// Check to see if deleted view is ancestor view

bool isAncestorView = false;

Epicor.Mfg.UI.FrameWork.EpiDataView parView = this._edvUD01.ParentView;

while ((parView != null))

{

if ((this.oTrans.LastView == parView))

{

isAncestorView = true;

break;

} else

{

parView = parView.ParentView;

}

// If Ancestor View then delete all child rows

if (isAncestorView)

{

DataRow[] drsDeleted = this._ud01Adapter.UD01Data.UD01.Select("Key1 = \'" + this._Key1UD01 + "\' AND Key2 = \'" + this._Key2UD01 + "\' AND Key3 = \'" + this._Key3UD01 + "\' AND Key4 = \'" + this._Key4UD01 + "\'");

for (int i = 0; (i < drsDeleted.Length); i = (i + 1))

{

this._ud01Adapter.Delete(drsDeleted[i]);

}

} else

{

if ((this.oTrans.LastView == this._edvUD01))

{

if ((this._edvUD01.Row >= 0))

{

DataRow drDeleted = ((DataRow)(this._ud01Adapter.UD01Data.UD01.Rows[this._edvUD01.Row]));

if ((drDeleted != null))

{

if (this._ud01Adapter.Delete(drDeleted))

{

if ((_edvUD01.Row > 0))

{

_edvUD01.Row = (_edvUD01.Row - 1);

}

// Notify that data was updated.

this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

}

private void UndoUD01Changes()

{

this._ud01Adapter.UD01Data.RejectChanges();

// Notify that data was updated.

this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

}

private void ClearUD01Data()

{

this._Key1UD01 = string.Empty;

this._Key2UD01 = string.Empty;

this._Key3UD01 = string.Empty;

this._Key4UD01 = string.Empty;

this._Key5UD01 = string.Empty;

this._ud01Adapter.UD01Data.Clear();

// Notify that data was updated.

this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

}

private void baseToolbarsManager_ToolClickForUD01(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs args)

{

// EpiMessageBox.Show(args.Tool.Key);

switch (args.Tool.Key)

{

case "EpiAddNewNew Unit":

GetNewUD01Record();

break;

case "ClearTool":

ClearUD01Data();

break;

case "DeleteTool":

DeleteUD01Record();

break;

case "UndoTool":

UndoUD01Changes();

break;

}

private void CustomerEntryForm_BeforeToolClickForUD01(object sender, Epicor.Mfg.UI.FrameWork.BeforeToolClickEventArgs args)

{

// EpiMessageBox.Show(args.Tool.Key);

switch (args.Tool.Key)

{

case "SaveTool":

SaveUD01Record();

break;

}

private void Customer_AfterRowChangeForUD01(EpiRowChangedArgs args)

{

// ** add AfterRowChange event handler

string custnum = args.CurrentView.dataView[args.CurrentRow]["CustNum"].ToString();

GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

}

private void Customer_DataView_ListChangedForUD01(object sender, ListChangedEventArgs args)

{

// ** add ListChanged event handler

string custnum = Customer_DataView[0]["CustNum"].ToString();

GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

}

private void epiUltraGridC1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs args)

{

// Event handling code generated by wizard.

if ((args.KeyCode == Keys.Escape))

{

try

{

UndoUD01Changes();

} catch (System.Exception )

{

}

private void epiUltraGridC1_BeforeRowsDeleted(object sender, Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventArgs args)

{

// Event handling code generated by wizard.

args.Cancel = true;

try

{

DeleteUD01Record();

} catch (System.Exception )

{

}

private void epiUltraGridC1_BeforeRowInsert(object sender, Infragistics.Win.UltraWinGrid.BeforeRowInsertEventArgs args)

{

// Event handling code generated by wizard.

args.Cancel = true;

this.oTrans.SetCurrentEvent(TransactionEvent.AddNewOnNewFromGrid);

try

{

SaveUD01Record();

GetNewUD01Record();

} catch (System.Exception )

{

}

private void CustomerEntryForm_Load(object sender, EventArgs args)

{

// Add Event Handler Code

EpiUltraGrid myGrid = (EpiUltraGrid)csm.GetNativeControlReference("6eae7622-3412-4609-8f63-751abdca5f7a");

myGrid.DisplayLayout.Bands[0].Columns["ShortChar07"].ValueList = epiComboC8;

}

system · September 20, 2013, 8:52am

This was Epicor's response when they could not get it to work either:

I added the code work around to the Customization you sent me and when I did a Test Code, I received several Compile errors, complaining about duplicate code.

It appears the work around Development provide was for that Customer's specific Customization and conflicts with the Customization you sent me.

I informed my Team Lead and she reminded me there are no programmers in Tech Support and suggested contacting our Custom Solutions Group (CSG).

--- In vantage@yahoogroups.com, <livingstonmarc86@...> wrote:

I was trying to work with support with the above issue, but they only had a sample for the Plant form which I was not able to transfer to the Customer form.

This is the answer book they sent to me:

PROBLEM DESCRIPTION: In Plant Maintenance, a UD table was added to the form. You can create new UD records and save those records with no issue. However, if you have 2 or more UD records loaded in the form and you delete a UD record, the following error is received:

Object reference not set to an instance of an object.

PROGRAM ID: Customization

EXPECTED BEHAVIOR: No error should be received.

Development linked the issue I reported to an existing Open (not yet resolved) SCR 82779 that is being used to track all Child UD tables issues. Development also provided me with a Work Around (included after my Signature Line and uses the attached Sample Customization for Plant Maintenance - you will need to modify the work around code for your needs).

***Note: See attached customization example step 1:

<Tools><Wizards> Reference Adapater/BLAssebmlies Wizard Select Plant Adapter and click "Finish"

Step 2:

Declare a class level varialbe

private [static] DataTable _dtUD05;

Step 3:

Clean up DataTable object in DestroyCustomCode()

_dtUD05.Clear();

_dtUD05 = null;

Step 4:

Initialize _udUD05 in InitializeUD05Adapter() An add the DataTable to the Adapter DataSet

_dtUD05 = _edvUD05.dataView.Table.Clone(); ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

Step 5:

Add dummy UD38 Table to Adapters DataSet in DeleteUD05Record() method if (!((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD05.TableName))

{

      ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

}

Step 6:

In the Form Event Wizard Tab add a "BeforeAdapterMethod" event handler and add the following code:

if (((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD38.TableName))

{

      ((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Remove(_dtUD38);

}

I have ran into issues trying to edit this for the customer form, can anyone help with this?
Below is my script for my customization, sorry for the long message:

// **************************************************

// Custom code for CustomerEntryForm

// Created: 8/7/2013 2:50:41 PM

// **************************************************

using System;

using System.ComponentModel;

using System.Data;

using System.Diagnostics;

using System.Windows.Forms;

using Epicor.Mfg.BO;

using Epicor.Mfg.UI;

using Epicor.Mfg.UI.Adapters;

using Epicor.Mfg.UI.Customization;

using Epicor.Mfg.UI.ExtendedProps;

using Epicor.Mfg.UI.FormFunctions;

using Epicor.Mfg.UI.FrameWork;

using Epicor.Mfg.UI.Searches;

public class Script

{

      // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **

      // Begin Wizard Added Module Level Variables **

      private UD01Adapter _ud01Adapter;

      private EpiDataView _edvCustomer;

      private EpiDataView _edvUD01;

      private string _Key1UD01;

      private string _Key2UD01;

      private string _Key3UD01;

      private string _Key4UD01;

      private string _Key5UD01;

      private DataView Customer_DataView;

      // End Wizard Added Module Level Variables **

      // Add Custom Module Level Variables Here **

      public void InitializeCustomCode()

      {

            // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **

            // Begin Wizard Added Variable Initialization

            this._Key1UD01 = string.Empty;

            this._Key2UD01 = string.Empty;

            this._Key3UD01 = string.Empty;

            this._Key4UD01 = string.Empty;

            this._Key5UD01 = string.Empty;

            this.baseToolbarsManager.ToolClick += new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

            this.CustomerEntryForm.BeforeToolClick += new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

            this.Customer_Row.EpiRowChanged += new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

            this.Customer_DataView = this.Customer_Row.dataView;

            this.Customer_DataView.ListChanged += new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

            // End Wizard Added Variable Initialization

            // Begin Wizard Added Custom Method Calls

            InitializeUD01Adapter();

            this.epiUltraGridC1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

            this.epiUltraGridC1.BeforeRowsDeleted += new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

            this.epiUltraGridC1.BeforeRowInsert += new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

            // 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

            if ((this._ud01Adapter != null))

            {

                  this._ud01Adapter.Dispose();

                  this._ud01Adapter = null;

            }

            this._edvUD01 = null;

            this._edvCustomer = null;

            this._Key1UD01 = null;

            this._Key2UD01 = null;

            this._Key3UD01 = null;

            this._Key4UD01 = null;

            this._Key5UD01 = null;

            this.baseToolbarsManager.ToolClick -= new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

            this.CustomerEntryForm.BeforeToolClick -= new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

            this.Customer_Row.EpiRowChanged -= new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

            this.Customer_DataView.ListChanged -= new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

            this.Customer_DataView = null;

            this.epiUltraGridC1.KeyDown -= new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

            this.epiUltraGridC1.BeforeRowsDeleted -= new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

            this.epiUltraGridC1.BeforeRowInsert -= new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

            // End Wizard Added Object Disposal

            // Begin Custom Code Disposal

            // End Custom Code Disposal

      }

      private void InitializeUD01Adapter()

      {

            // Create an instance of the Adapter.

            this._ud01Adapter = new UD01Adapter(this.oTrans);

            this._ud01Adapter.BOConnect();

            // Add Adapter Table to List of Views

            // This allows you to bind controls to the custom UD Table

            this._edvUD01 = new EpiDataView();

            this._edvUD01.dataView = new DataView(this._ud01Adapter.UD01Data.UD01);

            this._edvUD01.AddEnabled = true;

            this._edvUD01.AddText = "New Unit";

            if ((this.oTrans.EpiDataViews.ContainsKey("UD01View") == false))

            {

                  this.oTrans.Add("UD01View", this._edvUD01);

            }

            // Initialize EpiDataView field.

            this._edvCustomer = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"]));

            // Set the parent view / keys for UD child view

            string[] parentKeyFields = new string[1];

            string[] childKeyFields = new string[1];

            parentKeyFields[0] = "CustNum";

            childKeyFields[0] = "Key1";

            this._edvUD01.SetParentView(this._edvCustomer, parentKeyFields, childKeyFields);

            if ((this.oTrans.PrimaryAdapter != null))

            {

                  // this.oTrans.PrimaryAdapter.GetCurrentDataSet(Epicor.Mfg.UI.Searches.DataSetMode.RowsDataSet).Tables.Add(this._edvUD01.dataView.Table.Clone())

            }

      }

      private void GetUD01Data(string key1, string key2, string key3, string key4, string key5)

      {

            if ((this._Key1UD01 != key1) || (this._Key2UD01 != key2) || (this._Key3UD01 != key3) || (this._Key4UD01 != key4) || (this._Key5UD01 != key5))

            {

                  // Build where clause for search.

                  string whereClause = "Key1 = \'" + key1 + "\' And Key2 = \'" + key2 + "\' And Key3 = \'" + key3 + "\' And Key4 = \'" + key4 + "\'";

                  System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);

                  whereClauses.Add("Unit", whereClause);

                  // Call the adapter search.

                  SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);

                  this._ud01Adapter.InvokeSearch(searchOptions);

                  if ((this._ud01Adapter.UD01Data.UD01.Rows.Count > 0))

                  {

                        this._edvUD01.Row = 0;

                  } else

                  {

                        this._edvUD01.Row = -1;

                  }

                  // Notify that data was updated.

                  this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

                  // Set key fields to their new values.

                  this._Key1UD01 = key1;

                  this._Key2UD01 = key2;

                  this._Key3UD01 = key3;

                  this._Key4UD01 = key4;

                  this._Key5UD01 = key5;

            }

      }

      private void GetNewUD01Record()

      {

            DataRow parentViewRow = this._edvCustomer.CurrentDataRow;

            // Check for existence of Parent Row.

            if ((parentViewRow == null))

            {

                  return;

            }

            if (this._ud01Adapter.GetaNewUD01())

            {

                  string custnum = parentViewRow["CustNum"].ToString();

                  // Get unique row count id for Key5

                  int rowCount = this._ud01Adapter.UD01Data.UD01.Rows.Count;

                  int lineNum = rowCount;

                  bool goodIndex = false;

                  while ((goodIndex == false))

                  {

                        // Check to see if index exists

                        DataRow[] matchingRows = this._ud01Adapter.UD01Data.UD01.Select("Key5 = \'" + lineNum.ToString() + "\'");

                        if ((matchingRows.Length > 0))

                        {

                              lineNum = (lineNum + 1);

                        } else

                        {

                              goodIndex = true;

                        }

                  }

                  // Set initial UD Key values

                  DataRow editRow = this._ud01Adapter.UD01Data.UD01.Rows[(rowCount - 1)];

                  editRow.BeginEdit();

                  editRow["Key1"] = custnum;

                  editRow["Key2"] = string.Empty;

                  editRow["Key3"] = string.Empty;

                  editRow["Key4"] = string.Empty;

                  editRow["Key5"] = lineNum.ToString();

                  editRow.EndEdit();

                  // Notify that data was updated.

                  this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, (rowCount - 1), this._edvUD01.Column));

            }

      }

      private void SaveUD01Record()

      {

            // Save adapter data

            this._ud01Adapter.Update();

      }

      private void DeleteUD01Record()

      {

            // Check to see if deleted view is ancestor view

            bool isAncestorView = false;

            Epicor.Mfg.UI.FrameWork.EpiDataView parView = this._edvUD01.ParentView;

            while ((parView != null))

            {

                  if ((this.oTrans.LastView == parView))

                  {

                        isAncestorView = true;

                        break;

                  } else

                  {

                        parView = parView.ParentView;

                  }

            }

            // If Ancestor View then delete all child rows

            if (isAncestorView)

            {

                  DataRow[] drsDeleted = this._ud01Adapter.UD01Data.UD01.Select("Key1 = \'" + this._Key1UD01 + "\' AND Key2 = \'" + this._Key2UD01 + "\' AND Key3 = \'" + this._Key3UD01 + "\' AND Key4 = \'" + this._Key4UD01 + "\'");

                  for (int i = 0; (i < drsDeleted.Length); i = (i + 1))

                  {

                        this._ud01Adapter.Delete(drsDeleted[i]);

                  }

            } else

            {

                  if ((this.oTrans.LastView == this._edvUD01))

                  {

                        if ((this._edvUD01.Row >= 0))

                        {

                              DataRow drDeleted = ((DataRow)(this._ud01Adapter.UD01Data.UD01.Rows[this._edvUD01.Row]));

                              if ((drDeleted != null))

                              {

                                    if (this._ud01Adapter.Delete(drDeleted))

                                    {

                                          if ((_edvUD01.Row > 0))

                                          {

                                                _edvUD01.Row = (_edvUD01.Row - 1);

                                          }

                                          // Notify that data was updated.

                                          this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

                                    }

                              }

                        }

                  }

            }

      }

      private void UndoUD01Changes()

      {

            this._ud01Adapter.UD01Data.RejectChanges();

            // Notify that data was updated.

            this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

      }

      private void ClearUD01Data()

      {

            this._Key1UD01 = string.Empty;

            this._Key2UD01 = string.Empty;

            this._Key3UD01 = string.Empty;

            this._Key4UD01 = string.Empty;

            this._Key5UD01 = string.Empty;

            this._ud01Adapter.UD01Data.Clear();

            // Notify that data was updated.

            this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

      }

      private void baseToolbarsManager_ToolClickForUD01(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs args)

      {

            // EpiMessageBox.Show(args.Tool.Key);

            switch (args.Tool.Key)

            {

                  case "EpiAddNewNew Unit":

                        GetNewUD01Record();

                        break;



                  case "ClearTool":

                        ClearUD01Data();

                        break;



                  case "DeleteTool":

                        DeleteUD01Record();

                        break;



                  case "UndoTool":

                        UndoUD01Changes();

                        break;

            }

      }

      private void CustomerEntryForm_BeforeToolClickForUD01(object sender, Epicor.Mfg.UI.FrameWork.BeforeToolClickEventArgs args)

      {

            // EpiMessageBox.Show(args.Tool.Key);

            switch (args.Tool.Key)

            {

                  case "SaveTool":

                        SaveUD01Record();

                        break;

            }

      }

      private void Customer_AfterRowChangeForUD01(EpiRowChangedArgs args)

      {

            // ** add AfterRowChange event handler

            string custnum = args.CurrentView.dataView[args.CurrentRow]["CustNum"].ToString();

            GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

      }

      private void Customer_DataView_ListChangedForUD01(object sender, ListChangedEventArgs args)

      {

            // ** add ListChanged event handler

            string custnum = Customer_DataView[0]["CustNum"].ToString();

            GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

      }

      private void epiUltraGridC1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs args)

      {

            // Event handling code generated by wizard.

            if ((args.KeyCode == Keys.Escape))

            {

                  try

                  {

                        UndoUD01Changes();

                  } catch (System.Exception )

                  {

                  }

            }

      }

      private void epiUltraGridC1_BeforeRowsDeleted(object sender, Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventArgs args)

      {

            // Event handling code generated by wizard.

            args.Cancel = true;

            try

            {

                  DeleteUD01Record();

            } catch (System.Exception )

            {

            }

      }

      private void epiUltraGridC1_BeforeRowInsert(object sender, Infragistics.Win.UltraWinGrid.BeforeRowInsertEventArgs args)

      {

            // Event handling code generated by wizard.

            args.Cancel = true;

            this.oTrans.SetCurrentEvent(TransactionEvent.AddNewOnNewFromGrid);

            try

            {

                  SaveUD01Record();

                  GetNewUD01Record();

            } catch (System.Exception )

            {

            }

      }

      private void CustomerEntryForm_Load(object sender, EventArgs args)

      {

            // Add Event Handler Code

      EpiUltraGrid myGrid = (EpiUltraGrid)csm.GetNativeControlReference("6eae7622-3412-4609-8f63-751abdca5f7a");

          myGrid.DisplayLayout.Bands[0].Columns["ShortChar07"].ValueList = epiComboC8;

      }

}

system · September 20, 2013, 9:02am

Upload or put your original customization here and let me take a look at it (What version?)

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Sep 20, 2013 at 8:52 AM, <livingstonmarc86@...> wrote:

Â

<div> <p></p><p>This was Epicor's response when they could not get it to work either:</p><p></p><p>

I added the code work around to the Customization you sent me and when I did a Test Code, I received several Compile errors, complaining about duplicate code.

Â

It appears the work around Development provide was for that Customer's specific Customization and conflicts with the Customization you sent me.

Â

I informed my Team Lead and she reminded me there are no programmers in Tech Support and suggested contacting our Custom Solutions Group (CSG).

--- In vantage@yahoogroups.com, <livingstonmarc86@...> wrote:

I was trying to work with support with the above issue, but they only had a sample for the Plant form which I was not able to transfer to the Customer form.

This is the answer book they sent to me:

PROBLEM DESCRIPTION:Â In Plant Maintenance, a UD table was added to the form.Â You can create new UD records and save those records with no issue.Â However, if you have 2 or more UD records loaded in the form and you delete a UD record, the following error is received:

Â

Object reference not set to an instance of an object.

Â

PROGRAM ID:Â Customization

Â

EXPECTED BEHAVIOR:Â No error should be received.

Â

Â

Development linked the issue I reported to an existing Open (not yet resolved) SCR 82779 that is being used to track all Child UD tables issues.Â Development also provided me with a Work Around (included after my Signature Line and uses the attached Sample Customization for Plant Maintenance - you will need to modify the work around code for your needs).

***Note:Â See attached customization example step 1:

<Tools><Wizards> Reference Adapater/BLAssebmlies Wizard Select Plant Adapter and click "Finish"

Â

Â

Step 2:

Declare a class level varialbe

Â

private [static] DataTable _dtUD05;

Â

Step 3:

Clean up DataTable object in DestroyCustomCode()

Â

_dtUD05.Clear();

_dtUD05 = null;

Â

Â

Step 4:

Initialize _udUD05 in InitializeUD05Adapter() An add the DataTable to the Adapter DataSet

Â

_dtUD05 = _edvUD05.dataView.Table.Clone(); ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

Â

Â

Step 5:

Add dummy UD38 Table to Adapters DataSet in DeleteUD05Record() method if (!((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD05.TableName))

{

Â Â Â Â Â ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

}

Â

Â

Step 6:

In the Form Event Wizard Tab add a "BeforeAdapterMethod" event handler and add the following code:

Â

if (((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD38.TableName))

{

Â Â Â Â Â ((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Remove(_dtUD38);

}

Â

I have ran into issues trying to edit this for the customer form, can anyone help with this?
Â Below is my script for my customization, sorry for the long message:

// **************************************************

// Custom code for CustomerEntryForm

// Created: 8/7/2013 2:50:41 PM

// **************************************************

using System;

using System.ComponentModel;

using System.Data;

using System.Diagnostics;

using System.Windows.Forms;

using Epicor.Mfg.BO;

using Epicor.Mfg.UI;

using Epicor.Mfg.UI.Adapters;

using Epicor.Mfg.UI.Customization;

using Epicor.Mfg.UI.ExtendedProps;

using Epicor.Mfg.UI.FormFunctions;

using Epicor.Mfg.UI.FrameWork;

using Epicor.Mfg.UI.Searches;

Â

public class Script

{

Â Â Â Â Â // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **

Â Â Â Â Â // Begin Wizard Added Module Level Variables **

Â

Â Â Â Â Â private UD01Adapter _ud01Adapter;

Â Â Â Â Â private EpiDataView _edvCustomer;

Â Â Â Â Â private EpiDataView _edvUD01;

Â Â Â Â Â private string _Key1UD01;

Â Â Â Â Â private string _Key2UD01;

Â Â Â Â Â private string _Key3UD01;

Â Â Â Â Â private string _Key4UD01;

Â Â Â Â Â private string _Key5UD01;

Â Â Â Â Â private DataView Customer_DataView;

Â Â Â Â Â // End Wizard Added Module Level Variables **

Â

Â Â Â Â Â // Add Custom Module Level Variables Here **

Â

Â Â Â Â Â public void InitializeCustomCode()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **

Â Â Â Â Â Â Â Â Â Â Â // Begin Wizard Added Variable Initialization

Â

Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this.baseToolbarsManager.ToolClick += new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.CustomerEntryForm.BeforeToolClick += new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_Row.EpiRowChanged += new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView = this.Customer_Row.dataView;

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView.ListChanged += new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

Â Â Â Â Â Â Â Â Â Â Â // End Wizard Added Variable Initialization

Â

Â Â Â Â Â Â Â Â Â Â Â // Begin Wizard Added Custom Method Calls

Â

Â Â Â Â Â Â Â Â Â Â Â InitializeUD01Adapter();

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowsDeleted += new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowInsert += new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

Â Â Â Â Â Â Â Â Â Â Â // 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

Â

Â Â Â Â Â Â Â Â Â Â Â if ((this._ud01Adapter != null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.Dispose();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter = null;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._edvCustomer = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this.baseToolbarsManager.ToolClick -= new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.CustomerEntryForm.BeforeToolClick -= new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_Row.EpiRowChanged -= new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView.ListChanged -= new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView = null;

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.KeyDown -= new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowsDeleted -= new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowInsert -= new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

Â Â Â Â Â Â Â Â Â Â Â // End Wizard Added Object Disposal

Â

Â Â Â Â Â Â Â Â Â Â Â // Begin Custom Code Disposal

Â

Â Â Â Â Â Â Â Â Â Â Â // End Custom Code Disposal

Â Â Â Â Â }

Â

Â Â Â Â Â private void InitializeUD01Adapter()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Create an instance of the Adapter.

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter = new UD01Adapter(this.oTrans);

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.BOConnect();

Â

Â Â Â Â Â Â Â Â Â Â Â // Add Adapter Table to List of Views

Â Â Â Â Â Â Â Â Â Â Â // This allows you to bind controls to the custom UD Table

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01 = new EpiDataView();

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.dataView = new DataView(this._ud01Adapter.UD01Data.UD01);

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.AddEnabled = true;

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.AddText = "New Unit";

Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.EpiDataViews.ContainsKey("UD01View") == false))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this.oTrans.Add("UD01View", this._edvUD01);

Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â // Initialize EpiDataView field.

Â Â Â Â Â Â Â Â Â Â Â this._edvCustomer = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"]));

Â

Â Â Â Â Â Â Â Â Â Â Â // Set the parent view / keys for UD child view

Â Â Â Â Â Â Â Â Â Â Â string[] parentKeyFields = new string[1];

Â Â Â Â Â Â Â Â Â Â Â string[] childKeyFields = new string[1];

Â Â Â Â Â Â Â Â Â Â Â parentKeyFields[0] = "CustNum";

Â Â Â Â Â Â Â Â Â Â Â childKeyFields[0] = "Key1";

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.SetParentView(this._edvCustomer, parentKeyFields, childKeyFields);

Â

Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.PrimaryAdapter != null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // this.oTrans.PrimaryAdapter.GetCurrentDataSet(Epicor.Mfg.UI.Searches.DataSetMode.RowsDataSet).Tables.Add(this._edvUD01.dataView.Table.Clone())

Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â }

Â

Â Â Â Â Â private void GetUD01Data(string key1, string key2, string key3, string key4, string key5)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â if ((this._Key1UD01 != key1) || (this._Key2UD01 != key2) || (this._Key3UD01 != key3) || (this._Key4UD01 != key4) || (this._Key5UD01 != key5))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Build where clause for search.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â string whereClause = "Key1 = \'" + key1 + "\' And Key2 = \'" + key2 + "\' And Key3 = \'" + key3 + "\' And Key4 = \'" + key4 + "\'";

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â whereClauses.Add("Unit", whereClause);

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Call the adapter search.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.InvokeSearch(searchOptions);

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this._ud01Adapter.UD01Data.UD01.Rows.Count > 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Row = 0;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Row = -1;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Set key fields to their new values.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = key1;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = key2;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = key3;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = key4;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = key5;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void GetNewUD01Record()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â DataRow parentViewRow = this._edvCustomer.CurrentDataRow;

Â Â Â Â Â Â Â Â Â Â Â // Check for existence of Parent Row.

Â Â Â Â Â Â Â Â Â Â Â if ((parentViewRow == null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â return;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â if (this._ud01Adapter.GetaNewUD01())

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â string custnum = parentViewRow["CustNum"].ToString();

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Get unique row count id for Key5

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â int rowCount = this._ud01Adapter.UD01Data.UD01.Rows.Count;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â int lineNum = rowCount;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â bool goodIndex = false;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â while ((goodIndex == false))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Check to see if index exists

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow[] matchingRows = this._ud01Adapter.UD01Data.UD01.Select("Key5 = \'" + lineNum.ToString() + "\'");

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((matchingRows.Length > 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â lineNum = (lineNum + 1);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â goodIndex = true;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Set initial UD Key values

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow editRow = this._ud01Adapter.UD01Data.UD01.Rows[(rowCount - 1)];

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow.BeginEdit();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key1"] = custnum;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key2"] = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key3"] = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key4"] = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key5"] = lineNum.ToString();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow.EndEdit();

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, (rowCount - 1), this._edvUD01.Column));

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void SaveUD01Record()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Save adapter data

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.Update();

Â Â Â Â Â }

Â

Â Â Â Â Â private void DeleteUD01Record()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Check to see if deleted view is ancestor view

Â Â Â Â Â Â Â Â Â Â Â bool isAncestorView = false;

Â Â Â Â Â Â Â Â Â Â Â Epicor.Mfg.UI.FrameWork.EpiDataView parView = this._edvUD01.ParentView;

Â Â Â Â Â Â Â Â Â Â Â while ((parView != null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.LastView == parView))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â isAncestorView = true;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â parView = parView.ParentView;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â // If Ancestor View then delete all child rows

Â Â Â Â Â Â Â Â Â Â Â if (isAncestorView)

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow[] drsDeleted = this._ud01Adapter.UD01Data.UD01.Select("Key1 = \'" + this._Key1UD01 + "\' AND Key2 = \'" + this._Key2UD01 + "\' AND Key3 = \'" + this._Key3UD01 + "\' AND Key4 = \'" + this._Key4UD01 + "\'");

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â for (int i = 0; (i < drsDeleted.Length); i = (i + 1))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.Delete(drsDeleted[i]);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.LastView == this._edvUD01))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this._edvUD01.Row >= 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow drDeleted = ((DataRow)(this._ud01Adapter.UD01Data.UD01.Rows[this._edvUD01.Row]));

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((drDeleted != null))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if (this._ud01Adapter.Delete(drDeleted))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((_edvUD01.Row > 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â _edvUD01.Row = (_edvUD01.Row - 1);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void UndoUD01Changes()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.UD01Data.RejectChanges();

Â

Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â Â Â Â Â }

Â

Â Â Â Â Â private void ClearUD01Data()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = string.Empty;

Â

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.UD01Data.Clear();

Â

Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â Â Â Â Â }

Â

Â Â Â Â Â private void baseToolbarsManager_ToolClickForUD01(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // EpiMessageBox.Show(args.Tool.Key);

Â Â Â Â Â Â Â Â Â Â Â switch (args.Tool.Key)

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "EpiAddNewNew Unit":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â GetNewUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "ClearTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ClearUD01Data();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "DeleteTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DeleteUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "UndoTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UndoUD01Changes();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void CustomerEntryForm_BeforeToolClickForUD01(object sender, Epicor.Mfg.UI.FrameWork.BeforeToolClickEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // EpiMessageBox.Show(args.Tool.Key);

Â Â Â Â Â Â Â Â Â Â Â switch (args.Tool.Key)

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "SaveTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SaveUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void Customer_AfterRowChangeForUD01(EpiRowChangedArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // ** add AfterRowChange event handler

Â Â Â Â Â Â Â Â Â Â Â string custnum = args.CurrentView.dataView[args.CurrentRow]["CustNum"].ToString();

Â Â Â Â Â Â Â Â Â Â Â GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

Â Â Â Â Â }

Â

Â Â Â Â Â private void Customer_DataView_ListChangedForUD01(object sender, ListChangedEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // ** add ListChanged event handler

Â Â Â Â Â Â Â Â Â Â Â string custnum = Customer_DataView[0]["CustNum"].ToString();

Â Â Â Â Â Â Â Â Â Â Â GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

Â Â Â Â Â }

Â

Â Â Â Â Â private void epiUltraGridC1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Event handling code generated by wizard.

Â Â Â Â Â Â Â Â Â Â Â if ((args.KeyCode == Keys.Escape))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â try

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UndoUD01Changes();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } catch (System.Exception )

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void epiUltraGridC1_BeforeRowsDeleted(object sender, Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Event handling code generated by wizard.

Â Â Â Â Â Â Â Â Â Â Â args.Cancel = true;

Â Â Â Â Â Â Â Â Â Â Â try

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DeleteUD01Record();

Â Â Â Â Â Â Â Â Â Â Â } catch (System.Exception )

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void epiUltraGridC1_BeforeRowInsert(object sender, Infragistics.Win.UltraWinGrid.BeforeRowInsertEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Event handling code generated by wizard.

Â Â Â Â Â Â Â Â Â Â Â args.Cancel = true;

Â Â Â Â Â Â Â Â Â Â Â this.oTrans.SetCurrentEvent(TransactionEvent.AddNewOnNewFromGrid);

Â Â Â Â Â Â Â Â Â Â Â try

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SaveUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â GetNewUD01Record();

Â Â Â Â Â Â Â Â Â Â Â } catch (System.Exception )

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void CustomerEntryForm_Load(object sender, EventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Add Event Handler Code

Â Â Â Â Â EpiUltraGrid myGrid = (EpiUltraGrid)csm.GetNativeControlReference("6eae7622-3412-4609-8f63-751abdca5f7a");

Â Â Â Â Â Â Â Â myGrid.DisplayLayout.Bands[0].Columns["ShortChar07"].ValueList = epiComboC8;

Â

Â Â Â Â Â }

}

<p></p></div> <div style="color:#fff;min-height:0;"></div>

system · September 20, 2013, 9:47am

Alright I added it to the 9.0 files. We are on version 9.05.701. Error comes when selecting any record in the grid on the added sheet and trying to delete.

From: Jose Gomez <jose@...>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, September 20, 2013 8:02 AM
Subject: Re: [Vantage] RE: Object not set to instance of an object. Can't delete Child UD.UltraGrid

<div id="ygrps-yiv-1884614166yiv1280699781ygrp-text">
  
  
  <div dir="ltr"><div class="ygrps-yiv-1884614166yiv1280699781gmail_default" style="font-family:verdana, sans-serif;font-size:small;">Upload or put your original customization here and let me take a look at it (What version?)</div></div><div class="ygrps-yiv-1884614166yiv1280699781gmail_extra">

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Fri, Sep 20, 2013 at 8:52 AM, <livingstonmarc86@...> wrote:

<div> <div>This was Epicor's response when they could not get it to work either:</div><div>

I added the code work around to the Customization you sent me and when I did a Test Code, I received several Compile errors, complaining about duplicate code.

It appears the work around Development provide was for that Customer's specific Customization and conflicts with the Customization you sent me.

I informed my Team Lead and she reminded me there are no programmers in Tech Support and suggested contacting our Custom Solutions Group (CSG).

--- In vantage@yahoogroups.com, <livingstonmarc86@...> wrote:

I was trying to work with support with the above issue, but they only had a sample for the Plant form which I was not able to transfer to the Customer form.

This is the answer book they sent to me:

PROBLEM DESCRIPTION: In Plant Maintenance, a UD table was added to the form. You can create new UD records and save those records with no issue. However, if you have 2 or more UD records loaded in the form and you delete a UD record, the following error is received:

Object reference not set to an instance of an object.

PROGRAM ID: Customization

EXPECTED BEHAVIOR: No error should be received.

Development linked the issue I reported to an existing Open (not yet resolved) SCR 82779 that is being used to track all Child UD tables issues. Development also provided me with a Work Around (included after my Signature Line and uses the attached Sample Customization for Plant Maintenance - you will need to modify the work around code for your needs).

***Note: See attached customization example step 1:

<Tools><Wizards> Reference Adapater/BLAssebmlies Wizard Select Plant Adapter and click "Finish"

Step 2:

Declare a class level varialbe

private [static] DataTable _dtUD05;

Step 3:

Clean up DataTable object in DestroyCustomCode()

_dtUD05.Clear();

_dtUD05 = null;

Step 4:

Initialize _udUD05 in InitializeUD05Adapter() An add the DataTable to the Adapter DataSet

_dtUD05 = _edvUD05.dataView.Table.Clone(); ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

Step 5:

Add dummy UD38 Table to Adapters DataSet in DeleteUD05Record() method if (!((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD05.TableName))

{

      ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

}

Step 6:

In the Form Event Wizard Tab add a "BeforeAdapterMethod" event handler and add the following code:

if (((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD38.TableName))

{

      ((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Remove(_dtUD38);

}

I have ran into issues trying to edit this for the customer form, can anyone help with this?
Below is my script for my customization, sorry for the long message:

// **************************************************

// Custom code for CustomerEntryForm

// Created: 8/7/2013 2:50:41 PM

// **************************************************

using System;

using System.ComponentModel;

using System.Data;

using System.Diagnostics;

using System.Windows.Forms;

using Epicor.Mfg.BO;

using Epicor.Mfg.UI;

using Epicor.Mfg.UI.Adapters;

using Epicor.Mfg.UI.Customization;

using Epicor.Mfg.UI.ExtendedProps;

using Epicor.Mfg.UI.FormFunctions;

using Epicor.Mfg.UI.FrameWork;

using Epicor.Mfg.UI.Searches;

public class Script

{

      // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **

      // Begin Wizard Added Module Level Variables **

      private UD01Adapter _ud01Adapter;

      private EpiDataView _edvCustomer;

      private EpiDataView _edvUD01;

      private string _Key1UD01;

      private string _Key2UD01;

      private string _Key3UD01;

      private string _Key4UD01;

      private string _Key5UD01;

      private DataView Customer_DataView;

      // End Wizard Added Module Level Variables **

      // Add Custom Module Level Variables Here **

      public void InitializeCustomCode()

      {

            // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **

            // Begin Wizard Added Variable Initialization

            this._Key1UD01 = string.Empty;

            this._Key2UD01 = string.Empty;

            this._Key3UD01 = string.Empty;

            this._Key4UD01 = string.Empty;

            this._Key5UD01 = string.Empty;

            this.baseToolbarsManager.ToolClick += new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

            this.CustomerEntryForm.BeforeToolClick += new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

            this.Customer_Row.EpiRowChanged += new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

            this.Customer_DataView = this.Customer_Row.dataView;

            this.Customer_DataView.ListChanged += new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

            // End Wizard Added Variable Initialization

            // Begin Wizard Added Custom Method Calls

            InitializeUD01Adapter();

            this.epiUltraGridC1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

            this.epiUltraGridC1.BeforeRowsDeleted += new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

            this.epiUltraGridC1.BeforeRowInsert += new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

            // 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

            if ((this._ud01Adapter != null))

            {

                  this._ud01Adapter.Dispose();

                  this._ud01Adapter = null;

            }

            this._edvUD01 = null;

            this._edvCustomer = null;

            this._Key1UD01 = null;

            this._Key2UD01 = null;

            this._Key3UD01 = null;

            this._Key4UD01 = null;

            this._Key5UD01 = null;

            this.baseToolbarsManager.ToolClick -= new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

            this.CustomerEntryForm.BeforeToolClick -= new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

            this.Customer_Row.EpiRowChanged -= new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

            this.Customer_DataView.ListChanged -= new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

            this.Customer_DataView = null;

            this.epiUltraGridC1.KeyDown -= new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

            this.epiUltraGridC1.BeforeRowsDeleted -= new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

            this.epiUltraGridC1.BeforeRowInsert -= new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

            // End Wizard Added Object Disposal

            // Begin Custom Code Disposal

            // End Custom Code Disposal

      }

      private void InitializeUD01Adapter()

      {

            // Create an instance of the Adapter.

            this._ud01Adapter = new UD01Adapter(this.oTrans);

            this._ud01Adapter.BOConnect();

            // Add Adapter Table to List of Views

            // This allows you to bind controls to the custom UD Table

            this._edvUD01 = new EpiDataView();

            this._edvUD01.dataView = new DataView(this._ud01Adapter.UD01Data.UD01);

            this._edvUD01.AddEnabled = true;

            this._edvUD01.AddText = "New Unit";

            if ((this.oTrans.EpiDataViews.ContainsKey("UD01View") == false))

            {

                  this.oTrans.Add("UD01View", this._edvUD01);

            }

            // Initialize EpiDataView field.

            this._edvCustomer = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"]));

            // Set the parent view / keys for UD child view

            string[] parentKeyFields = new string[1];

            string[] childKeyFields = new string[1];

            parentKeyFields[0] = "CustNum";

            childKeyFields[0] = "Key1";

            this._edvUD01.SetParentView(this._edvCustomer, parentKeyFields, childKeyFields);

            if ((this.oTrans.PrimaryAdapter != null))

            {

                  // this.oTrans.PrimaryAdapter.GetCurrentDataSet(Epicor.Mfg.UI.Searches.DataSetMode.RowsDataSet).Tables.Add(this._edvUD01.dataView.Table.Clone())

            }

      }

      private void GetUD01Data(string key1, string key2, string key3, string key4, string key5)

      {

            if ((this._Key1UD01 != key1) || (this._Key2UD01 != key2) || (this._Key3UD01 != key3) || (this._Key4UD01 != key4) || (this._Key5UD01 != key5))

            {

                  // Build where clause for search.

                  string whereClause = "Key1 = \'" + key1 + "\' And Key2 = \'" + key2 + "\' And Key3 = \'" + key3 + "\' And Key4 = \'" + key4 + "\'";

                  System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);

                  whereClauses.Add("Unit", whereClause);

                  // Call the adapter search.

                  SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);

                  this._ud01Adapter.InvokeSearch(searchOptions);

                  if ((this._ud01Adapter.UD01Data.UD01.Rows.Count > 0))

                  {

                        this._edvUD01.Row = 0;

                  } else

                  {

                        this._edvUD01.Row = -1;

                  }

                  // Notify that data was updated.

                  this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

                  // Set key fields to their new values.

                  this._Key1UD01 = key1;

                  this._Key2UD01 = key2;

                  this._Key3UD01 = key3;

                  this._Key4UD01 = key4;

                  this._Key5UD01 = key5;

            }

      }

      private void GetNewUD01Record()

      {

            DataRow parentViewRow = this._edvCustomer.CurrentDataRow;

            // Check for existence of Parent Row.

            if ((parentViewRow == null))

            {

                  return;

            }

            if (this._ud01Adapter.GetaNewUD01())

            {

                  string custnum = parentViewRow["CustNum"].ToString();

                  // Get unique row count id for Key5

                  int rowCount = this._ud01Adapter.UD01Data.UD01.Rows.Count;

                  int lineNum = rowCount;

                  bool goodIndex = false;

                  while ((goodIndex == false))

                  {

                        // Check to see if index exists

                        DataRow[] matchingRows = this._ud01Adapter.UD01Data.UD01.Select("Key5 = \'" + lineNum.ToString() + "\'");

                        if ((matchingRows.Length > 0))

                        {

                              lineNum = (lineNum + 1);

                        } else

                        {

                              goodIndex = true;

                        }

                  }

                  // Set initial UD Key values

                  DataRow editRow = this._ud01Adapter.UD01Data.UD01.Rows[(rowCount - 1)];

                  editRow.BeginEdit();

                  editRow["Key1"] = custnum;

                  editRow["Key2"] = string.Empty;

                  editRow["Key3"] = string.Empty;

                  editRow["Key4"] = string.Empty;

                  editRow["Key5"] = lineNum.ToString();

                  editRow.EndEdit();

                  // Notify that data was updated.

                  this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, (rowCount - 1), this._edvUD01.Column));

            }

      }

      private void SaveUD01Record()

      {

            // Save adapter data

            this._ud01Adapter.Update();

      }

      private void DeleteUD01Record()

      {

            // Check to see if deleted view is ancestor view

            bool isAncestorView = false;

            Epicor.Mfg.UI.FrameWork.EpiDataView parView = this._edvUD01.ParentView;

            while ((parView != null))

            {

                  if ((this.oTrans.LastView == parView))

                  {

                        isAncestorView = true;

                        break;

                  } else

                  {

                        parView = parView.ParentView;

                  }

            }

            // If Ancestor View then delete all child rows

            if (isAncestorView)

            {

                  DataRow[] drsDeleted = this._ud01Adapter.UD01Data.UD01.Select("Key1 = \'" + this._Key1UD01 + "\' AND Key2 = \'" + this._Key2UD01 + "\' AND Key3 = \'" + this._Key3UD01 + "\' AND Key4 = \'" + this._Key4UD01 + "\'");

                  for (int i = 0; (i < drsDeleted.Length); i = (i + 1))

                  {

                        this._ud01Adapter.Delete(drsDeleted[i]);

                  }

            } else

            {

                  if ((this.oTrans.LastView == this._edvUD01))

                  {

                        if ((this._edvUD01.Row >= 0))

                        {

                              DataRow drDeleted = ((DataRow)(this._ud01Adapter.UD01Data.UD01.Rows[this._edvUD01.Row]));

                              if ((drDeleted != null))

                              {

                                    if (this._ud01Adapter.Delete(drDeleted))

                                    {

                                          if ((_edvUD01.Row > 0))

                                          {

                                                _edvUD01.Row = (_edvUD01.Row - 1);

                                          }

                                          // Notify that data was updated.

                                          this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

                                    }

                              }

                        }

                  }

            }

      }

      private void UndoUD01Changes()

      {

            this._ud01Adapter.UD01Data.RejectChanges();

            // Notify that data was updated.

            this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

      }

      private void ClearUD01Data()

      {

            this._Key1UD01 = string.Empty;

            this._Key2UD01 = string.Empty;

            this._Key3UD01 = string.Empty;

            this._Key4UD01 = string.Empty;

            this._Key5UD01 = string.Empty;

            this._ud01Adapter.UD01Data.Clear();

            // Notify that data was updated.

            this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

      }

      private void baseToolbarsManager_ToolClickForUD01(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs args)

      {

            // EpiMessageBox.Show(args.Tool.Key);

            switch (args.Tool.Key)

            {

                  case "EpiAddNewNew Unit":

                        GetNewUD01Record();

                        break;



                  case "ClearTool":

                        ClearUD01Data();

                        break;



                  case "DeleteTool":

                        DeleteUD01Record();

                        break;



                  case "UndoTool":

                        UndoUD01Changes();

                        break;

            }

      }

      private void CustomerEntryForm_BeforeToolClickForUD01(object sender, Epicor.Mfg.UI.FrameWork.BeforeToolClickEventArgs args)

      {

            // EpiMessageBox.Show(args.Tool.Key);

            switch (args.Tool.Key)

            {

                  case "SaveTool":

                        SaveUD01Record();

                        break;

            }

      }

      private void Customer_AfterRowChangeForUD01(EpiRowChangedArgs args)

      {

            // ** add AfterRowChange event handler

            string custnum = args.CurrentView.dataView[args.CurrentRow]["CustNum"].ToString();

            GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

      }

      private void Customer_DataView_ListChangedForUD01(object sender, ListChangedEventArgs args)

      {

            // ** add ListChanged event handler

            string custnum = Customer_DataView[0]["CustNum"].ToString();

            GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

      }

      private void epiUltraGridC1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs args)

      {

            // Event handling code generated by wizard.

            if ((args.KeyCode == Keys.Escape))

            {

                  try

                  {

                        UndoUD01Changes();

                  } catch (System.Exception )

                  {

                  }

            }

      }

      private void epiUltraGridC1_BeforeRowsDeleted(object sender, Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventArgs args)

      {

            // Event handling code generated by wizard.

            args.Cancel = true;

            try

            {

                  DeleteUD01Record();

            } catch (System.Exception )

            {

            }

      }

      private void epiUltraGridC1_BeforeRowInsert(object sender, Infragistics.Win.UltraWinGrid.BeforeRowInsertEventArgs args)

      {

            // Event handling code generated by wizard.

            args.Cancel = true;

            this.oTrans.SetCurrentEvent(TransactionEvent.AddNewOnNewFromGrid);

            try

            {

                  SaveUD01Record();

                  GetNewUD01Record();

            } catch (System.Exception )

            {

            }

      }

      private void CustomerEntryForm_Load(object sender, EventArgs args)

      {

            // Add Event Handler Code

      EpiUltraGrid myGrid = (EpiUltraGrid)csm.GetNativeControlReference("6eae7622-3412-4609-8f63-751abdca5f7a");

          myGrid.DisplayLayout.Bands[0].Columns["ShortChar07"].ValueList = epiComboC8;

      }

}

</div> <div style="color:#fff;"></div>

</div>

system · September 20, 2013, 11:00am

I loaded your customization in my environment and had no problems. Do you have visual studio 2010? If so you can connect it to your customization and step through the code to identify the culplit line once we have that infromation we might be able to write something around it.

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Sep 20, 2013 at 9:47 AM, Marc Livingston <livingstonmarc86@...> wrote:

Â

<div> <p></p><div style="font-size:12pt;font-family:times new roman, new york, times, serif;">Alright I added it to the 9.0 files. We are on version 9.05.701. Error comes when selecting any record in the grid on the added sheet and trying to delete.<br>

From: Jose Gomez <jose@…>
To: Vantage <vantage@yahoogroups.com>

Sent: Friday, September 20, 2013 8:02 AM
Subject: Re: [Vantage] RE: Object not set to instance of an object. Can't
delete Child UD.UltraGrid

Â
<div> <div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;">Upload or put your original customization here and let me take a look at it (What version?)</div></div><div>

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Â Â Â Â Â Â

Quis custodiet ipsos custodes?

On Fri, Sep 20, 2013 at 8:52 AM, <livingstonmarc86@...> wrote:

Â

<div> <div>This was Epicor's response when they could not get it to work either:</div><div>

I added the code work around to the Customization you sent me and when I did a Test Code, I received several Compile errors, complaining about duplicate code.

Â

It appears the work around Development provide was for that Customer's specific Customization and conflicts with the Customization you sent me.

Â

I informed my Team Lead and she reminded me there are no programmers in Tech Support and suggested contacting our Custom Solutions Group (CSG).

--- In vantage@yahoogroups.com, <livingstonmarc86@...> wrote:

I was trying to work with support with the above issue, but they only had a sample for the Plant form which I was not able to transfer to the Customer form.

This is the answer book they sent to me:

PROBLEM DESCRIPTION:Â In Plant Maintenance, a UD table was added to the form.Â You can create new UD records and save those records with no issue.Â However, if you have 2 or more UD records loaded in the form and you delete a UD record, the following error is received:

Â

Object reference not set to an instance of an object.

Â

PROGRAM ID:Â Customization

Â

EXPECTED BEHAVIOR:Â No error should be received.

Â

Â

Development linked the issue I reported to an existing Open (not yet resolved) SCR 82779 that is being used to track all Child UD tables issues.Â Development also provided me with a Work Around (included after my Signature Line and uses the attached Sample Customization for Plant Maintenance - you will need to modify the work around code for your needs).

***Note:Â See attached customization example step 1:

<Tools><Wizards> Reference Adapater/BLAssebmlies Wizard Select Plant Adapter and click "Finish"

Â

Â

Step 2:

Declare a class level varialbe

Â

private [static] DataTable _dtUD05;

Â

Step 3:

Clean up DataTable object in DestroyCustomCode()

Â

_dtUD05.Clear();

_dtUD05 = null;

Â

Â

Step 4:

Initialize _udUD05 in InitializeUD05Adapter() An add the DataTable to the Adapter DataSet

Â

_dtUD05 = _edvUD05.dataView.Table.Clone(); ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

Â

Â

Step 5:

Add dummy UD38 Table to Adapters DataSet in DeleteUD05Record() method if (!((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD05.TableName))

{

Â Â Â Â Â ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

}

Â

Â

Step 6:

In the Form Event Wizard Tab add a "BeforeAdapterMethod" event handler and add the following code:

Â

if (((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD38.TableName))

{

Â Â Â Â Â ((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Remove(_dtUD38);

}

Â

I have ran into issues trying to edit this for the customer form, can anyone help with this?
Â Below is my script for my customization, sorry for the long message:

// **************************************************

// Custom code for CustomerEntryForm

// Created: 8/7/2013 2:50:41 PM

// **************************************************

using System;

using System.ComponentModel;

using System.Data;

using System.Diagnostics;

using System.Windows.Forms;

using Epicor.Mfg.BO;

using Epicor.Mfg.UI;

using Epicor.Mfg.UI.Adapters;

using Epicor.Mfg.UI.Customization;

using Epicor.Mfg.UI.ExtendedProps;

using Epicor.Mfg.UI.FormFunctions;

using Epicor.Mfg.UI.FrameWork;

using Epicor.Mfg.UI.Searches;

Â

public class Script

{

Â Â Â Â Â // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **

Â Â Â Â Â // Begin Wizard Added Module Level Variables **

Â

Â Â Â Â Â private UD01Adapter _ud01Adapter;

Â Â Â Â Â private EpiDataView _edvCustomer;

Â Â Â Â Â private EpiDataView _edvUD01;

Â Â Â Â Â private string _Key1UD01;

Â Â Â Â Â private string _Key2UD01;

Â Â Â Â Â private string _Key3UD01;

Â Â Â Â Â private string _Key4UD01;

Â Â Â Â Â private string _Key5UD01;

Â Â Â Â Â private DataView Customer_DataView;

Â Â Â Â Â // End Wizard Added Module Level Variables **

Â

Â Â Â Â Â // Add Custom Module Level Variables Here **

Â

Â Â Â Â Â public void InitializeCustomCode()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **

Â Â Â Â Â Â Â Â Â Â Â // Begin Wizard Added Variable Initialization

Â

Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this.baseToolbarsManager.ToolClick += new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.CustomerEntryForm.BeforeToolClick += new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_Row.EpiRowChanged += new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView = this.Customer_Row.dataView;

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView.ListChanged += new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

Â Â Â Â Â Â Â Â Â Â Â // End Wizard Added Variable Initialization

Â

Â Â Â Â Â Â Â Â Â Â Â // Begin Wizard Added Custom Method Calls

Â

Â Â Â Â Â Â Â Â Â Â Â InitializeUD01Adapter();

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowsDeleted += new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowInsert += new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

Â Â Â Â Â Â Â Â Â Â Â // 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

Â

Â Â Â Â Â Â Â Â Â Â Â if ((this._ud01Adapter != null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.Dispose();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter = null;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._edvCustomer = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = null;

Â Â Â Â Â Â Â Â Â Â Â this.baseToolbarsManager.ToolClick -= new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.CustomerEntryForm.BeforeToolClick -= new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_Row.EpiRowChanged -= new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView.ListChanged -= new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

Â Â Â Â Â Â Â Â Â Â Â this.Customer_DataView = null;

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.KeyDown -= new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowsDeleted -= new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

Â Â Â Â Â Â Â Â Â Â Â this.epiUltraGridC1.BeforeRowInsert -= new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

Â Â Â Â Â Â Â Â Â Â Â // End Wizard Added Object Disposal

Â

Â Â Â Â Â Â Â Â Â Â Â // Begin Custom Code Disposal

Â

Â Â Â Â Â Â Â Â Â Â Â // End Custom Code Disposal

Â Â Â Â Â }

Â

Â Â Â Â Â private void InitializeUD01Adapter()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Create an instance of the Adapter.

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter = new UD01Adapter(this.oTrans);

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.BOConnect();

Â

Â Â Â Â Â Â Â Â Â Â Â // Add Adapter Table to List of Views

Â Â Â Â Â Â Â Â Â Â Â // This allows you to bind controls to the custom UD Table

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01 = new EpiDataView();

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.dataView = new DataView(this._ud01Adapter.UD01Data.UD01);

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.AddEnabled = true;

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.AddText = "New Unit";

Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.EpiDataViews.ContainsKey("UD01View") == false))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this.oTrans.Add("UD01View", this._edvUD01);

Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â // Initialize EpiDataView field.

Â Â Â Â Â Â Â Â Â Â Â this._edvCustomer = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"]));

Â

Â Â Â Â Â Â Â Â Â Â Â // Set the parent view / keys for UD child view

Â Â Â Â Â Â Â Â Â Â Â string[] parentKeyFields = new string[1];

Â Â Â Â Â Â Â Â Â Â Â string[] childKeyFields = new string[1];

Â Â Â Â Â Â Â Â Â Â Â parentKeyFields[0] = "CustNum";

Â Â Â Â Â Â Â Â Â Â Â childKeyFields[0] = "Key1";

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.SetParentView(this._edvCustomer, parentKeyFields, childKeyFields);

Â

Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.PrimaryAdapter != null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // this.oTrans.PrimaryAdapter.GetCurrentDataSet(Epicor.Mfg.UI.Searches.DataSetMode.RowsDataSet).Tables.Add(this._edvUD01.dataView.Table.Clone())

Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â }

Â

Â Â Â Â Â private void GetUD01Data(string key1, string key2, string key3, string key4, string key5)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â if ((this._Key1UD01 != key1) || (this._Key2UD01 != key2) || (this._Key3UD01 != key3) || (this._Key4UD01 != key4) || (this._Key5UD01 != key5))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Build where clause for search.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â string whereClause = "Key1 = \'" + key1 + "\' And Key2 = \'" + key2 + "\' And Key3 = \'" + key3 + "\' And Key4 = \'" + key4 + "\'";

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â whereClauses.Add("Unit", whereClause);

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Call the adapter search.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.InvokeSearch(searchOptions);

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this._ud01Adapter.UD01Data.UD01.Rows.Count > 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Row = 0;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Row = -1;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Set key fields to their new values.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = key1;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = key2;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = key3;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = key4;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = key5;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void GetNewUD01Record()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â DataRow parentViewRow = this._edvCustomer.CurrentDataRow;

Â Â Â Â Â Â Â Â Â Â Â // Check for existence of Parent Row.

Â Â Â Â Â Â Â Â Â Â Â if ((parentViewRow == null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â return;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â if (this._ud01Adapter.GetaNewUD01())

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â string custnum = parentViewRow["CustNum"].ToString();

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Get unique row count id for Key5

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â int rowCount = this._ud01Adapter.UD01Data.UD01.Rows.Count;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â int lineNum = rowCount;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â bool goodIndex = false;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â while ((goodIndex == false))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Check to see if index exists

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow[] matchingRows = this._ud01Adapter.UD01Data.UD01.Select("Key5 = \'" + lineNum.ToString() + "\'");

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((matchingRows.Length > 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â lineNum = (lineNum + 1);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â goodIndex = true;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Set initial UD Key values

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow editRow = this._ud01Adapter.UD01Data.UD01.Rows[(rowCount - 1)];

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow.BeginEdit();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key1"] = custnum;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key2"] = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key3"] = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key4"] = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow["Key5"] = lineNum.ToString();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â editRow.EndEdit();

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, (rowCount - 1), this._edvUD01.Column));

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void SaveUD01Record()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Save adapter data

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.Update();

Â Â Â Â Â }

Â

Â Â Â Â Â private void DeleteUD01Record()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Check to see if deleted view is ancestor view

Â Â Â Â Â Â Â Â Â Â Â bool isAncestorView = false;

Â Â Â Â Â Â Â Â Â Â Â Epicor.Mfg.UI.FrameWork.EpiDataView parView = this._edvUD01.ParentView;

Â Â Â Â Â Â Â Â Â Â Â while ((parView != null))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.LastView == parView))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â isAncestorView = true;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â parView = parView.ParentView;

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â // If Ancestor View then delete all child rows

Â Â Â Â Â Â Â Â Â Â Â if (isAncestorView)

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow[] drsDeleted = this._ud01Adapter.UD01Data.UD01.Select("Key1 = \'" + this._Key1UD01 + "\' AND Key2 = \'" + this._Key2UD01 + "\' AND Key3 = \'" + this._Key3UD01 + "\' AND Key4 = \'" + this._Key4UD01 + "\'");

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â for (int i = 0; (i < drsDeleted.Length); i = (i + 1))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.Delete(drsDeleted[i]);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â } else

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this.oTrans.LastView == this._edvUD01))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((this._edvUD01.Row >= 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DataRow drDeleted = ((DataRow)(this._ud01Adapter.UD01Data.UD01.Rows[this._edvUD01.Row]));

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((drDeleted != null))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if (this._ud01Adapter.Delete(drDeleted))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â if ((_edvUD01.Row > 0))

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â _edvUD01.Row = (_edvUD01.Row - 1);

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void UndoUD01Changes()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.UD01Data.RejectChanges();

Â

Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â Â Â Â Â }

Â

Â Â Â Â Â private void ClearUD01Data()

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â this._Key1UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key2UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key3UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key4UD01 = string.Empty;

Â Â Â Â Â Â Â Â Â Â Â this._Key5UD01 = string.Empty;

Â

Â Â Â Â Â Â Â Â Â Â Â this._ud01Adapter.UD01Data.Clear();

Â

Â Â Â Â Â Â Â Â Â Â Â // Notify that data was updated.

Â Â Â Â Â Â Â Â Â Â Â this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

Â Â Â Â Â }

Â

Â Â Â Â Â private void baseToolbarsManager_ToolClickForUD01(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // EpiMessageBox.Show(args.Tool.Key);

Â Â Â Â Â Â Â Â Â Â Â switch (args.Tool.Key)

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "EpiAddNewNew Unit":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â GetNewUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "ClearTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â ClearUD01Data();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "DeleteTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DeleteUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "UndoTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UndoUD01Changes();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void CustomerEntryForm_BeforeToolClickForUD01(object sender, Epicor.Mfg.UI.FrameWork.BeforeToolClickEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // EpiMessageBox.Show(args.Tool.Key);

Â Â Â Â Â Â Â Â Â Â Â switch (args.Tool.Key)

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â case "SaveTool":

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SaveUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â break;

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void Customer_AfterRowChangeForUD01(EpiRowChangedArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // ** add AfterRowChange event handler

Â Â Â Â Â Â Â Â Â Â Â string custnum = args.CurrentView.dataView[args.CurrentRow]["CustNum"].ToString();

Â Â Â Â Â Â Â Â Â Â Â GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

Â Â Â Â Â }

Â

Â Â Â Â Â private void Customer_DataView_ListChangedForUD01(object sender, ListChangedEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // ** add ListChanged event handler

Â Â Â Â Â Â Â Â Â Â Â string custnum = Customer_DataView[0]["CustNum"].ToString();

Â Â Â Â Â Â Â Â Â Â Â GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

Â Â Â Â Â }

Â

Â Â Â Â Â private void epiUltraGridC1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Event handling code generated by wizard.

Â Â Â Â Â Â Â Â Â Â Â if ((args.KeyCode == Keys.Escape))

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â try

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â UndoUD01Changes();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â } catch (System.Exception )

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void epiUltraGridC1_BeforeRowsDeleted(object sender, Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Event handling code generated by wizard.

Â Â Â Â Â Â Â Â Â Â Â args.Cancel = true;

Â Â Â Â Â Â Â Â Â Â Â try

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â DeleteUD01Record();

Â Â Â Â Â Â Â Â Â Â Â } catch (System.Exception )

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void epiUltraGridC1_BeforeRowInsert(object sender, Infragistics.Win.UltraWinGrid.BeforeRowInsertEventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Event handling code generated by wizard.

Â Â Â Â Â Â Â Â Â Â Â args.Cancel = true;

Â Â Â Â Â Â Â Â Â Â Â this.oTrans.SetCurrentEvent(TransactionEvent.AddNewOnNewFromGrid);

Â Â Â Â Â Â Â Â Â Â Â try

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â SaveUD01Record();

Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â GetNewUD01Record();

Â Â Â Â Â Â Â Â Â Â Â } catch (System.Exception )

Â Â Â Â Â Â Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â }

Â Â Â Â Â }

Â

Â Â Â Â Â private void CustomerEntryForm_Load(object sender, EventArgs args)

Â Â Â Â Â {

Â Â Â Â Â Â Â Â Â Â Â // Add Event Handler Code

Â Â Â Â Â EpiUltraGrid myGrid = (EpiUltraGrid)csm.GetNativeControlReference("6eae7622-3412-4609-8f63-751abdca5f7a");

Â Â Â Â Â Â Â Â myGrid.DisplayLayout.Bands[0].Columns["ShortChar07"].ValueList = epiComboC8;

Â

Â Â Â Â Â }

}

</div> <div style="color:#fff;"></div>

</div>

</div>
 


<div style="color:#fff;min-height:0;"></div>

system · September 20, 2013, 11:13am

The customization I added does not have the added code.

To get the error, navigate to the tab 'Unit Information' under the main customer tab. Add 2 new records and then try selecting one of the records in the grid and deleting it.

From: Jose Gomez <jose@...>
To: Vantage <vantage@yahoogroups.com>
Sent: Friday, September 20, 2013 10:00 AM
Subject: Re: [Vantage] RE: Object not set to instance of an object. Can't delete Child UD.UltraGrid

<div id="ygrps-yiv-1193765465yiv1640802465ygrp-text">
  
  
  <div dir="ltr"><div class="ygrps-yiv-1193765465yiv1640802465gmail_default" style="font-family:verdana, sans-serif;font-size:small;">I loaded your customization in my environment and had no problems. Do you have visual studio 2010? If so you can connect it to your customization and step through the code to identify the culplit line once we have that infromation we might be able to write something around it.</div>

Jose C Gomez

Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com

Quis custodiet ipsos custodes?

On Fri, Sep 20, 2013 at 9:47 AM, Marc Livingston <livingstonmarc86@...> wrote:

<div> <div style="font-size:12pt;font-family:times new roman, new york, times, serif;">Alright I added it to the 9.0 files. We are on version 9.05.701. Error comes when selecting any record in the grid on the added sheet and trying to delete.<br>

From: Jose Gomez <jose@…>
To: Vantage <vantage@yahoogroups.com>

Sent: Friday, September 20, 2013 8:02 AM
Subject: Re: [Vantage] RE: Object not set to instance of an object. Can't
delete Child UD.UltraGrid

<div> <div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;">Upload or put your original customization here and let me take a look at it (What version?)</div></div><div>

Jose C Gomez
Software Engineer

T: 904.469.1524 mobile

E: jose@...
http://www.josecgomez.com



Quis custodiet ipsos custodes?

On Fri, Sep 20, 2013 at 8:52 AM, <livingstonmarc86@...> wrote:

<div> <div>This was Epicor's response when they could not get it to work either:</div><div>

I added the code work around to the Customization you sent me and when I did a Test Code, I received several Compile errors, complaining about duplicate code.

It appears the work around Development provide was for that Customer's specific Customization and conflicts with the Customization you sent me.

I informed my Team Lead and she reminded me there are no programmers in Tech Support and suggested contacting our Custom Solutions Group (CSG).

--- In vantage@yahoogroups.com, <livingstonmarc86@...> wrote:

I was trying to work with support with the above issue, but they only had a sample for the Plant form which I was not able to transfer to the Customer form.

This is the answer book they sent to me:

PROBLEM DESCRIPTION: In Plant Maintenance, a UD table was added to the form. You can create new UD records and save those records with no issue. However, if you have 2 or more UD records loaded in the form and you delete a UD record, the following error is received:

Object reference not set to an instance of an object.

PROGRAM ID: Customization

EXPECTED BEHAVIOR: No error should be received.

Development linked the issue I reported to an existing Open (not yet resolved) SCR 82779 that is being used to track all Child UD tables issues. Development also provided me with a Work Around (included after my Signature Line and uses the attached Sample Customization for Plant Maintenance - you will need to modify the work around code for your needs).

***Note: See attached customization example step 1:

<Tools><Wizards> Reference Adapater/BLAssebmlies Wizard Select Plant Adapter and click "Finish"

Step 2:

Declare a class level varialbe

private [static] DataTable _dtUD05;

Step 3:

Clean up DataTable object in DestroyCustomCode()

_dtUD05.Clear();

_dtUD05 = null;

Step 4:

Initialize _udUD05 in InitializeUD05Adapter() An add the DataTable to the Adapter DataSet

_dtUD05 = _edvUD05.dataView.Table.Clone(); ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

Step 5:

Add dummy UD38 Table to Adapters DataSet in DeleteUD05Record() method if (!((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD05.TableName))

{

      ((ProjectAdapter)oTrans_plantAdapter).PlantData.Tables.Add(_dtUD05);

}

Step 6:

In the Form Event Wizard Tab add a "BeforeAdapterMethod" event handler and add the following code:

if (((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Contains(_dtUD38.TableName))

{

      ((PlantAdapter)oTrans_plantAdapter).PlantData.Tables.Remove(_dtUD38);

}

I have ran into issues trying to edit this for the customer form, can anyone help with this?
Below is my script for my customization, sorry for the long message:

// **************************************************

// Custom code for CustomerEntryForm

// Created: 8/7/2013 2:50:41 PM

// **************************************************

using System;

using System.ComponentModel;

using System.Data;

using System.Diagnostics;

using System.Windows.Forms;

using Epicor.Mfg.BO;

using Epicor.Mfg.UI;

using Epicor.Mfg.UI.Adapters;

using Epicor.Mfg.UI.Customization;

using Epicor.Mfg.UI.ExtendedProps;

using Epicor.Mfg.UI.FormFunctions;

using Epicor.Mfg.UI.FrameWork;

using Epicor.Mfg.UI.Searches;

public class Script

{

      // ** Wizard Insert Location - Do Not Remove 'Begin/End Wizard Added Module Level Variables' Comments! **

      // Begin Wizard Added Module Level Variables **

      private UD01Adapter _ud01Adapter;

      private EpiDataView _edvCustomer;

      private EpiDataView _edvUD01;

      private string _Key1UD01;

      private string _Key2UD01;

      private string _Key3UD01;

      private string _Key4UD01;

      private string _Key5UD01;

      private DataView Customer_DataView;

      // End Wizard Added Module Level Variables **

      // Add Custom Module Level Variables Here **

      public void InitializeCustomCode()

      {

            // ** Wizard Insert Location - Do not delete 'Begin/End Wizard Added Variable Initialization' lines **

            // Begin Wizard Added Variable Initialization

            this._Key1UD01 = string.Empty;

            this._Key2UD01 = string.Empty;

            this._Key3UD01 = string.Empty;

            this._Key4UD01 = string.Empty;

            this._Key5UD01 = string.Empty;

            this.baseToolbarsManager.ToolClick += new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

            this.CustomerEntryForm.BeforeToolClick += new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

            this.Customer_Row.EpiRowChanged += new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

            this.Customer_DataView = this.Customer_Row.dataView;

            this.Customer_DataView.ListChanged += new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

            // End Wizard Added Variable Initialization

            // Begin Wizard Added Custom Method Calls

            InitializeUD01Adapter();

            this.epiUltraGridC1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

            this.epiUltraGridC1.BeforeRowsDeleted += new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

            this.epiUltraGridC1.BeforeRowInsert += new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

            // 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

            if ((this._ud01Adapter != null))

            {

                  this._ud01Adapter.Dispose();

                  this._ud01Adapter = null;

            }

            this._edvUD01 = null;

            this._edvCustomer = null;

            this._Key1UD01 = null;

            this._Key2UD01 = null;

            this._Key3UD01 = null;

            this._Key4UD01 = null;

            this._Key5UD01 = null;

            this.baseToolbarsManager.ToolClick -= new Infragistics.Win.UltraWinToolbars.ToolClickEventHandler(this.baseToolbarsManager_ToolClickForUD01);

            this.CustomerEntryForm.BeforeToolClick -= new Epicor.Mfg.UI.FrameWork.BeforeToolClickEventHandler(this.CustomerEntryForm_BeforeToolClickForUD01);

            this.Customer_Row.EpiRowChanged -= new EpiRowChanged(this.Customer_AfterRowChangeForUD01);

            this.Customer_DataView.ListChanged -= new ListChangedEventHandler(this.Customer_DataView_ListChangedForUD01);

            this.Customer_DataView = null;

            this.epiUltraGridC1.KeyDown -= new System.Windows.Forms.KeyEventHandler(this.epiUltraGridC1_KeyDown);

            this.epiUltraGridC1.BeforeRowsDeleted -= new Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventHandler(this.epiUltraGridC1_BeforeRowsDeleted);

            this.epiUltraGridC1.BeforeRowInsert -= new Infragistics.Win.UltraWinGrid.BeforeRowInsertEventHandler(this.epiUltraGridC1_BeforeRowInsert);

            // End Wizard Added Object Disposal

            // Begin Custom Code Disposal

            // End Custom Code Disposal

      }

      private void InitializeUD01Adapter()

      {

            // Create an instance of the Adapter.

            this._ud01Adapter = new UD01Adapter(this.oTrans);

            this._ud01Adapter.BOConnect();

            // Add Adapter Table to List of Views

            // This allows you to bind controls to the custom UD Table

            this._edvUD01 = new EpiDataView();

            this._edvUD01.dataView = new DataView(this._ud01Adapter.UD01Data.UD01);

            this._edvUD01.AddEnabled = true;

            this._edvUD01.AddText = "New Unit";

            if ((this.oTrans.EpiDataViews.ContainsKey("UD01View") == false))

            {

                  this.oTrans.Add("UD01View", this._edvUD01);

            }

            // Initialize EpiDataView field.

            this._edvCustomer = ((EpiDataView)(this.oTrans.EpiDataViews["Customer"]));

            // Set the parent view / keys for UD child view

            string[] parentKeyFields = new string[1];

            string[] childKeyFields = new string[1];

            parentKeyFields[0] = "CustNum";

            childKeyFields[0] = "Key1";

            this._edvUD01.SetParentView(this._edvCustomer, parentKeyFields, childKeyFields);

            if ((this.oTrans.PrimaryAdapter != null))

            {

                  // this.oTrans.PrimaryAdapter.GetCurrentDataSet(Epicor.Mfg.UI.Searches.DataSetMode.RowsDataSet).Tables.Add(this._edvUD01.dataView.Table.Clone())

            }

      }

      private void GetUD01Data(string key1, string key2, string key3, string key4, string key5)

      {

            if ((this._Key1UD01 != key1) || (this._Key2UD01 != key2) || (this._Key3UD01 != key3) || (this._Key4UD01 != key4) || (this._Key5UD01 != key5))

            {

                  // Build where clause for search.

                  string whereClause = "Key1 = \'" + key1 + "\' And Key2 = \'" + key2 + "\' And Key3 = \'" + key3 + "\' And Key4 = \'" + key4 + "\'";

                  System.Collections.Hashtable whereClauses = new System.Collections.Hashtable(1);

                  whereClauses.Add("Unit", whereClause);

                  // Call the adapter search.

                  SearchOptions searchOptions = SearchOptions.CreateRuntimeSearch(whereClauses, DataSetMode.RowsDataSet);

                  this._ud01Adapter.InvokeSearch(searchOptions);

                  if ((this._ud01Adapter.UD01Data.UD01.Rows.Count > 0))

                  {

                        this._edvUD01.Row = 0;

                  } else

                  {

                        this._edvUD01.Row = -1;

                  }

                  // Notify that data was updated.

                  this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

                  // Set key fields to their new values.

                  this._Key1UD01 = key1;

                  this._Key2UD01 = key2;

                  this._Key3UD01 = key3;

                  this._Key4UD01 = key4;

                  this._Key5UD01 = key5;

            }

      }

      private void GetNewUD01Record()

      {

            DataRow parentViewRow = this._edvCustomer.CurrentDataRow;

            // Check for existence of Parent Row.

            if ((parentViewRow == null))

            {

                  return;

            }

            if (this._ud01Adapter.GetaNewUD01())

            {

                  string custnum = parentViewRow["CustNum"].ToString();

                  // Get unique row count id for Key5

                  int rowCount = this._ud01Adapter.UD01Data.UD01.Rows.Count;

                  int lineNum = rowCount;

                  bool goodIndex = false;

                  while ((goodIndex == false))

                  {

                        // Check to see if index exists

                        DataRow[] matchingRows = this._ud01Adapter.UD01Data.UD01.Select("Key5 = \'" + lineNum.ToString() + "\'");

                        if ((matchingRows.Length > 0))

                        {

                              lineNum = (lineNum + 1);

                        } else

                        {

                              goodIndex = true;

                        }

                  }

                  // Set initial UD Key values

                  DataRow editRow = this._ud01Adapter.UD01Data.UD01.Rows[(rowCount - 1)];

                  editRow.BeginEdit();

                  editRow["Key1"] = custnum;

                  editRow["Key2"] = string.Empty;

                  editRow["Key3"] = string.Empty;

                  editRow["Key4"] = string.Empty;

                  editRow["Key5"] = lineNum.ToString();

                  editRow.EndEdit();

                  // Notify that data was updated.

                  this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, (rowCount - 1), this._edvUD01.Column));

            }

      }

      private void SaveUD01Record()

      {

            // Save adapter data

            this._ud01Adapter.Update();

      }

      private void DeleteUD01Record()

      {

            // Check to see if deleted view is ancestor view

            bool isAncestorView = false;

            Epicor.Mfg.UI.FrameWork.EpiDataView parView = this._edvUD01.ParentView;

            while ((parView != null))

            {

                  if ((this.oTrans.LastView == parView))

                  {

                        isAncestorView = true;

                        break;

                  } else

                  {

                        parView = parView.ParentView;

                  }

            }

            // If Ancestor View then delete all child rows

            if (isAncestorView)

            {

                  DataRow[] drsDeleted = this._ud01Adapter.UD01Data.UD01.Select("Key1 = \'" + this._Key1UD01 + "\' AND Key2 = \'" + this._Key2UD01 + "\' AND Key3 = \'" + this._Key3UD01 + "\' AND Key4 = \'" + this._Key4UD01 + "\'");

                  for (int i = 0; (i < drsDeleted.Length); i = (i + 1))

                  {

                        this._ud01Adapter.Delete(drsDeleted[i]);

                  }

            } else

            {

                  if ((this.oTrans.LastView == this._edvUD01))

                  {

                        if ((this._edvUD01.Row >= 0))

                        {

                              DataRow drDeleted = ((DataRow)(this._ud01Adapter.UD01Data.UD01.Rows[this._edvUD01.Row]));

                              if ((drDeleted != null))

                              {

                                    if (this._ud01Adapter.Delete(drDeleted))

                                    {

                                          if ((_edvUD01.Row > 0))

                                          {

                                                _edvUD01.Row = (_edvUD01.Row - 1);

                                          }

                                          // Notify that data was updated.

                                          this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

                                    }

                              }

                        }

                  }

            }

      }

      private void UndoUD01Changes()

      {

            this._ud01Adapter.UD01Data.RejectChanges();

            // Notify that data was updated.

            this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

      }

      private void ClearUD01Data()

      {

            this._Key1UD01 = string.Empty;

            this._Key2UD01 = string.Empty;

            this._Key3UD01 = string.Empty;

            this._Key4UD01 = string.Empty;

            this._Key5UD01 = string.Empty;

            this._ud01Adapter.UD01Data.Clear();

            // Notify that data was updated.

            this._edvUD01.Notify(new EpiNotifyArgs(this.oTrans, this._edvUD01.Row, this._edvUD01.Column));

      }

      private void baseToolbarsManager_ToolClickForUD01(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs args)

      {

            // EpiMessageBox.Show(args.Tool.Key);

            switch (args.Tool.Key)

            {

                  case "EpiAddNewNew Unit":

                        GetNewUD01Record();

                        break;



                  case "ClearTool":

                        ClearUD01Data();

                        break;



                  case "DeleteTool":

                        DeleteUD01Record();

                        break;



                  case "UndoTool":

                        UndoUD01Changes();

                        break;

            }

      }

      private void CustomerEntryForm_BeforeToolClickForUD01(object sender, Epicor.Mfg.UI.FrameWork.BeforeToolClickEventArgs args)

      {

            // EpiMessageBox.Show(args.Tool.Key);

            switch (args.Tool.Key)

            {

                  case "SaveTool":

                        SaveUD01Record();

                        break;

            }

      }

      private void Customer_AfterRowChangeForUD01(EpiRowChangedArgs args)

      {

            // ** add AfterRowChange event handler

            string custnum = args.CurrentView.dataView[args.CurrentRow]["CustNum"].ToString();

            GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

      }

      private void Customer_DataView_ListChangedForUD01(object sender, ListChangedEventArgs args)

      {

            // ** add ListChanged event handler

            string custnum = Customer_DataView[0]["CustNum"].ToString();

            GetUD01Data(custnum, string.Empty, string.Empty, string.Empty, string.Empty);

      }

      private void epiUltraGridC1_KeyDown(object sender, System.Windows.Forms.KeyEventArgs args)

      {

            // Event handling code generated by wizard.

            if ((args.KeyCode == Keys.Escape))

            {

                  try

                  {

                        UndoUD01Changes();

                  } catch (System.Exception )

                  {

                  }

            }

      }

      private void epiUltraGridC1_BeforeRowsDeleted(object sender, Infragistics.Win.UltraWinGrid.BeforeRowsDeletedEventArgs args)

      {

            // Event handling code generated by wizard.

            args.Cancel = true;

            try

            {

                  DeleteUD01Record();

            } catch (System.Exception )

            {

            }

      }

      private void epiUltraGridC1_BeforeRowInsert(object sender, Infragistics.Win.UltraWinGrid.BeforeRowInsertEventArgs args)

      {

            // Event handling code generated by wizard.

            args.Cancel = true;

            this.oTrans.SetCurrentEvent(TransactionEvent.AddNewOnNewFromGrid);

            try

            {

                  SaveUD01Record();

                  GetNewUD01Record();

            } catch (System.Exception )

            {

            }

      }

      private void CustomerEntryForm_Load(object sender, EventArgs args)

      {

            // Add Event Handler Code

      EpiUltraGrid myGrid = (EpiUltraGrid)csm.GetNativeControlReference("6eae7622-3412-4609-8f63-751abdca5f7a");

          myGrid.DisplayLayout.Bands[0].Columns["ShortChar07"].ValueList = epiComboC8;

      }

}

</div> <div style="color:#fff;"></div>

</div>

</div>
 


<div style="color:#fff;"></div>

</div>

Topic		Replies	Views
UD Table Delete From Parent Form Error Epicor ERP 10 customization	2	763	June 21, 2023
Adding UD Child tables with Wizard Yahoo Archive	0	925	January 28, 2013
UD05 Entry C# Customization - Object reference not set to an instance of an object - Help Needed Kinetic ERP customization	5	1828	December 1, 2021
Add UD child table (nothing populating) Epicor ERP 10 customization	22	3624	June 5, 2020
Refresh Doesn't Work on UD Tables Yahoo Archive	6	1212	October 13, 2015

Object not set to instance of an object. Can't delete Child UD.U

Related Topics