Run Updateable BAQ from customisation [C#]

Epicor ERP 10
9

If you use the ExecuteByID method on DynamicQuery then the BAQ won’t be updatable in your code.

Here’s a version of what we use:

		if (baqName != string.Empty)
		{
			if (!gotBAQ)
			{
				if (adptr.GetByID(baqName)) { gotBAQ = true; }
			}
			if (updateable)
			{
				if (!(ds != null)) { ds = adptr.DynamicQueryData; }
				if (ds.DynamicQuery.Rows.Count == 0)
				{
					Ice.BO.DynamicQueryDataSet dsQDesign = adptr.QueryDesignData;
					DataRow targetRow;
					foreach (DataTable table in ds.Tables)
					{
						foreach (DataRow sourceRow in dsQDesign.Tables[table.ToString()].Rows)
						{
							targetRow = table.NewRow();
							targetRow.ItemArray = sourceRow.ItemArray;
							table.Rows.Add(targetRow);
						}
					}
				}
				if (!(dsBAQ != null)) { dsBAQ = adptr.GetQueryExecutionParameters(ds); }
			}
			else
			{
				if (!(dsBAQ != null)) { dsBAQ = adptr.GetQueryExecutionParametersByID(baqName); }
			}
			if (baqParams != null)
			{
				int i = 0;
				foreach (KeyValuePair<string, string> p in baqParams)
				{
					bool empty = false;
					string key = p.Key;
					string val = p.Value;
					if (key.Substring(0,1) == "-")
					{
						if (val == string.Empty) { empty = true; }
						key = key.Substring(1, key.Length - 1);
					}
					dsBAQ.ExecutionParameter[i].ParameterID = key;
					dsBAQ.ExecutionParameter[i].IsEmpty = empty;
					dsBAQ.ExecutionParameter[i].ParameterValue = val;
					i++;
				}
				dsBAQ.AcceptChanges();
			}
			if (updateable)
			{
				adptr.Execute(ds, dsBAQ);
			}
			else
			{
				adptr.ExecuteByID(baqName, dsBAQ);
			}
			if (adptr.QueryResults != null && adptr.QueryResults.Tables.Count > 0)
			{
				results = adptr.QueryResults.Tables["Results"];
			}
			else
			{
				results = new DataTable();
			}
			if (!(edv != null)) { edv = (EpiDataView)oTrans.EpiDataViews[baqName]; }
			if (!(edv != null))
			{
				edv = new EpiDataView();
				oTrans.Add(baqName, edv);
			}
			edv.dataView = results.DefaultView;
			if (grid != null) { grid.DataSource = results; }
		}

You can leave out the last line and bind the grid to the EpiDataView directly if you want. Either way, as long as you make sure the parts of the above where “updateable” = true are the ones being used, the BAQ data will be updatable.

1 Like