Hello All,
Something strange happened recently. I added a BAQDataView to Customer Shipment Entry with 3 criteria’s, but it only works half the time. I am calling the oTrans function as normal but when the page refreshes (ie. when someone chooses a new pack slip) the grid updates only sometimes. I’ve tried many methods to debug this but I’m stumped.
public void CreatePACustShp()
{
CustShipBAQ = new BAQDataView("PA_CustShp_BAQ");
oTrans.Add("PA_CustShp_BAQ", CustShipBAQ);
string pub1Binding = "ShipDtl.OrderNum";
IPublisher pub1 = oTrans.GetPublisher(pub1Binding);
if (pub1 == null)
{
string pubName = Guid.NewGuid().ToString();
oTrans.PublishColumnChange(pub1Binding, pubName);
pub1 = oTrans.GetPublisher(pub1Binding);
}
if (pub1 != null)
CustShipBAQ.SubscribeToPublisher(pub1.PublishName, "ShipDtl_OrderNum");
string pub2Binding = "ShipDtl.OrderLine";
IPublisher pub2 = oTrans.GetPublisher(pub2Binding);
if (pub2 == null)
{
string pubName = Guid.NewGuid().ToString();
oTrans.PublishColumnChange(pub2Binding, pubName);
pub2 = oTrans.GetPublisher(pub2Binding);
}
if (pub2 != null)
CustShipBAQ.SubscribeToPublisher(pub2.PublishName, "ShipDtl_OrderLine");
string pub3Binding = "ShipDtl.OrderRelNum";
IPublisher pub3 = oTrans.GetPublisher(pub3Binding);
if (pub3 == null)
{
string pubName = Guid.NewGuid().ToString();
oTrans.PublishColumnChange(pub3Binding, pubName);
pub3 = oTrans.GetPublisher(pub3Binding);
}
if (pub3 != null)
CustShipBAQ.SubscribeToPublisher(pub3.PublishName, "ShipDtl_OrderRelNum");
string pub4Binding = "ShipHead.PackNum";
IPublisher pub4 = oTrans.GetPublisher(pub4Binding);
if(pub4 == null)
{
string pubName = Guid.NewGuid().ToString();
oTrans.PublishColumnChange(pub4Binding, pubName);
pub4 = oTrans.GetPublisher(pub4Binding);
}
if(pub4 != null)
{
CustShipBAQ.SubscribeToPublisher(pub4.PublishName, "ShipDtl_PackNum");
}
}
At current, my data view updates if I clear the form and reload, or if I spam the refresh button, but it only updates 50% of the time when someone reloads the form through a new Pack ID:
If there are any functions or methods I’m missing please let me know!