I have a UD Table setup as a child to Supplier Maintenance. I am trying to use it to enter new data records using the VendorID as Key1 and the wizard generated auto-incrementing counter as Key5. I have two date fields and a combo box bound via a customization to three of the UD table fields (ShortChar01, Date01, and Date02). The problem that I am having is that whenever I search a select a supplier record, the custom fields auto populate with the first record from the UD table. How can I stop this from getting the data and displaying it?
I have tried commenting out the GetUD39Data method pictured below, and it keeps the fields from pulling data in. The problem is that when I try to create a new record, I get an error message when I hit save that says the it’s a duplicate entry of an existing record.
Your keys must be unique. I see you are using VendorID as Key1 in your Get that’s fine, are you certain you are not attempting to create another record? if so you need another Unique Key, it is very common to use Key5 as a Counter Incrementer, to remain Unique in your GetaNewUD39Record method.
There should already be a boiler-plate code, make sure you don’t have it disabled.
Example:
// Get unique row count id for Key5
int rowCount = this._ud05Adapter.UD05Data.UD05.Rows.Count;
int lineNum = rowCount;
bool goodIndex = false;
while ((goodIndex == false))
{
// Check to see if index exists
DataRow[] matchingRows = this._ud05Adapter.UD05Data.UD05.Select("Key5 = \'" + lineNum.ToString() + "\'");
if ((matchingRows.Length > 0))
{
lineNum = (lineNum + 1);
} else
{
goodIndex = true;
}
}
editRow["Key5"] = lineNum.ToString();
Yeah, that’s fine and makes sense, but right now I’m more worried about getting these fields to be used for pushing data to the UD Table, not displaying displaying it. I feel like I’m close but I just can’t get passed the Duplicate Entry error. Any thoughts on that?
Yes, we are looking to have the ability to add multiple records per supplier, but we do not want to edit the record after it is created and saved.
Basically we are trying to use the three custom fields as data entry fields that clear out after we’ve entered the data and saved it to UD table. We would then use a BAQ report or dashboard to retrieve the data as needed.
Our other option would be to add a button to Supplier Maintenance that launches the UD table menu item and we do the entry in there, but for that to work, we would need to add code that creates a variable that automatically increments, that we could tie to one of the key fields, thereby creating a unique key value for each record.
I am currently playing around with adding some code via a form load event that could possible handle that. I just have to figure out which methods to call and the syntax for that.
I think I get it. Those controls added to the customization shouldn’t be bound to UD39 table, but rather have their values added to a new record in UD39, upon some event - like saving or a button press. That right?
I have found a solution that works. I determined that the following code was populating the fields with data from the UD table after a Supplier was selected:
By commenting out this function I was able to select a supplier without the fields being populated with data from the UD table. The next thing I did was to add the following code to the GetNewUD39Record() function:
This appeared to allow the function to get the data it needed in order to create a new record without pre-populating the custom fields because the GetUD39Data() function doesn’t run prior to creating a new record. the final working code looked like this:
private void GetNewUD39Record()
{
string vendnum = VendorDetail_DataView[0]["VendorNum"].ToString();
string vendid = VendorDetail_DataView[0]["VendorID"].ToString();
GetUD39Data(vendnum, vendid, string.Empty, string.Empty, string.Empty);
DataRow parentViewRow = this._edvVendorDetail.CurrentDataRow;
// Check for existence of Parent Row.
if ((parentViewRow == null))
{
return;
}
if (this._ud39Adapter.GetaNewUD39())
{
string vendornum = parentViewRow["VendorNum"].ToString();
string vendorid = parentViewRow["VendorID"].ToString();
// Get unique row count id for Key5
int rowCount = this._ud39Adapter.UD39Data.UD39.Rows.Count;
int lineNum = rowCount;
bool goodIndex = false;
while ((goodIndex == false))
{
// Check to see if index exists
DataRow[] matchingRows = this._ud39Adapter.UD39Data.UD39.Select("Key5 = \'" + lineNum.ToString() + "\'");
if ((matchingRows.Length > 0))
{
lineNum = (lineNum + 1);
} else
{
goodIndex = true;
}
}
// Set initial UD Key values
DataRow editRow = this._ud39Adapter.UD39Data.UD39.Rows[(rowCount - 1)];
editRow.BeginEdit();
editRow["Key1"] = vendornum;
editRow["Key2"] = vendorid;
editRow["Key3"] = string.Empty;
editRow["Key4"] = string.Empty;
editRow["Key5"] = lineNum.ToString();
editRow.EndEdit();
//MessageBox.Show(lineNum.ToString());
// Notify that data was updated.
this._edvUD39.Notify(new EpiNotifyArgs(this.oTrans, (rowCount - 1), this._edvUD39.Column));
}
}
Great you got it, I remember I had to make sure the row’s existed in my ListChanged Events, because it was firing too soon sometimes without the key-values such as VendorNum existing yet. Probably not your issue, you got it after-all…
But for reference of thread: You might check the Clear Button comment:
private void QuoteDtl_AfterRowChangeForUD05(EpiRowChangedArgs args)
{
if (args.CurrentRow > -1)
{
// ** add AfterRowChange event handler
string quotenum = args.CurrentView.dataView[args.CurrentRow]["QuoteNum"].ToString();
string quoteline = args.CurrentView.dataView[args.CurrentRow]["QuoteLine"].ToString();
GetUD05Data(string.Empty, string.Empty, quotenum, quoteline, string.Empty);
}
}
private void QuoteDtl_DataView_ListChangedForUD05(object sender, ListChangedEventArgs args)
{
// Protects us from the Clear button or when the dataView does not exist
if ((QuoteDtl_Row.dataView.Count - 1) < QuoteDtl_Row.Row)
{
return;
}
if (QuoteDtl_Row.Row > -1 && QuoteDtl_Row.dataView.Count == 1)
{
// ** add ListChanged event handler
string quotenum = QuoteDtl_Row.dataView[QuoteDtl_Row.Row]["QuoteNum"].ToString();
string quoteline = QuoteDtl_Row.dataView[QuoteDtl_Row.Row]["QuoteLine"].ToString();
GetUD05Data(string.Empty, string.Empty, quotenum, quoteline, string.Empty);
}
}
