BAQ Dataview

Epicor ERP 10
, , ,
1

I have a BAQ dataview on the Resource Group Scheduling Board and it works fine, However it would be better if the dataview was updateable.

I have changed the original dashboard to an updateable dashboard and tested. It works fine.
I have changed the properties for the columns in the dataview, removing the tick from read only.
Saved the customization and reloaded. The column has gone back to read only.

Is there a property or something that needs updating in the dataview code to flip this for a standard dataview to an updateable one ?

2

Check this post out

3

Had to rewrite most of my code, but basically changed the query to use a parameter instead which i then linked to the Resource Group on the form. Using the code elements from above, (GetData, RefreshData, and Save) was able to get the dataview working the way i needed.

Thanks

4

Did you have to change to a dynamic query?

5

Sorry for the late reply, Yes is did.

In terms of the grid i changed from this

public void CreateDMPDB000014BAQDV()
{
dmpDB000014BAQDV = new BAQDataView(“DMPDV000001”);
oTrans.Add(“DMPDB000014BAQDV” ,dmpDB000014BAQDV);
//string ResourceGroupID = txtResourceGroupId.Text;
string pub1Binding = “SchedControl.ResourceGrpID”;
IPublisher pub1 = oTrans.GetPublisher(pub1Binding);
if (pub1 == null)
{
string pubName = Guid.NewGuid().ToString();
oTrans.PublishColumnChange(pub1Binding, pubName);
pub1 = oTrans.GetPublisher(pub1Binding);
}

	if (pub1 !=null)
			dmpDB000014BAQDV.SubscribeToPublisher(pub1.PublishName, "ResourceGroup_ResourceGrpID");
	

}

To This

private void ProcessBtn_Click(object sender, System.EventArgs args)
{
// ** Place Event Handling Code Here **
DynamicQueryAdapter dqa = new DynamicQueryAdapter(oTrans);
dqa.BOConnect();
QueryExecutionDataSet qeds = dqa.GetQueryExecutionParametersByID(“DMPDV000002”);
qeds.ExecutionParameter.Clear();
qeds.ExecutionParameter.AddExecutionParameterRow(“ResourceGroup”, txtParam.Text , “nvarchar”,false, Guid.NewGuid(), “A”);
dqa.ExecuteByID(“DMPDV000002”,qeds);
ugMyGrid.DataSource = dqa.QueryResults.Tables[“Results”];
}