Hello,
I need on the form RouteInventProd to add a display method to the "Overview" tab of the lower grid that will take values from the tab "Resource Requirements" and depending on the value display different values.
I write something like this:
display ProdUnitId prodUnitId1()
{
RouteOpr routeOpr1;
WrkCtrRouteOprActivity wrkCtrRouteOprActivity;
WrkCtrActivityRequirementSet wrkCtrActivityRequitementSet;
WrkCtrActivityRequirement wrkCtrActivityRequirement;
WrkCtrResourceGroup wrkCtrResourceGroup;
WrkCtrResourceGroupResource wrkCtrResourceGroupResource;
select * from wrkCtrActivityRequirement
join wrkCtrActivityRequitementSet
where wrkCtrActivityRequitementSet.RecId == wrkCtrActivityRequirement.ActivityRequirementSet
join wrkCtrRouteOprActivity
where wrkCtrRouteOprActivity.Activity == wrkCtrActivityRequitementSet.Activity
join routeOpr1
where routeOpr1.RecId == wrkCtrRouteOprActivity.RouteOpr;
if (wrkCtrActivityRequirement.RelationshipType == WrkCtrActivityRequirementType::ResourceGroup)
{
select * from wrkCtrResourceGroup
where wrkCtrResourceGroup.WrkCtrId == wrkCtrActivityRequirement.requirementEdit();
return wrkCtrResourceGroup.ProdUnitId;
}
else if (wrkCtrActivityRequirement.RelationshipType == WrkCtrActivityRequirementType::Resource)
{
select * from wrkCtrResourceGroupResource
where wrkCtrResourceGroupResource.WrkCtrId == wrkCtrActivityRequirement.requirementEdit();
select * from wrkCtrResourceGroup
where wrkCtrResourceGroup.RecId == wrkCtrResourceGroupResource.ResourceGroup;
return wrkCtrResourceGroup.ProdUnitId;
}
return " ";
}
I add this display method to the table "RouteOpr" and then add this table as data source to the form. Then as JoinSource I point out "ProdRoute" table and type is OuterJoin.
But my query from above always returns the same value and doesn't bound anyhow to the values on the form. Tell me please how can I bound to the form values? It's Tab "Resource Requirements"
The values I need:
In case of additional questions please feel free to ask. Thanks you.
*This post is locked for comments
I have the same question (0)
