//Override the lookupreference method of the reference control.
public static Common lookupReferenceDlvCharge(FormReferenceControl _formReferenceControl,VendAccount _vendAccount)
{
afmATPDlvCharge aTPDlvCharge;
Query query = new Query();
QueryBuildDataSource queryBuildDataSourceDlvCharge,queryBuildDataSourceVend;
SysReferenceTableLookup sysTableLookup = SysReferenceTableLookup::newParameters(tableNum(afmATPDlvCharge), _formReferenceControl, true);
sysTableLookup.addLookupField(fieldNum(afmATPDlvCharge, name));
sysTableLookup.addLookupField(fieldNum(afmATPDlvCharge, ChargeType));
sysTableLookup.addLookupField(fieldNum(afmATPDlvCharge, InvoiceAccount));
sysTableLookup.addLookupField(fieldNum(afmATPDlvCharge, Amount));
queryBuildDataSourceDlvCharge = query.addDataSource(tableNum(afmATPDlvCharge));
queryBuildDataSourceVend = queryBuildDataSourceDlvCharge.addDataSource(tableNum(VendTable));
queryBuildDataSourceVend.joinMode(JoinMode::ExistsJoin);
queryBuildDataSourceVend.relations(false);
queryBuildDataSourceVend.addLink(fieldNum(afmATPDlvCharge, invoiceAccount), fieldNum(VendTable, invoiceAccount));
queryBuildDataSourceVend.addRange(fieldNum(VendTable, AccountNum)).value(queryValue(_vendAccount));
sysTableLookup.parmQuery(query);
aTPDlvCharge = sysTableLookup.performFormLookup();
return aTPDlvCharge;
}
public static Common lookupReferenceDlvCharge(FormReferenceControl _formReferenceControl,VendAccount _vendAccount)
{
afmATPDlvCharge aTPDlvCharge;
Query query = new Query();
QueryBuildDataSource queryBuildDataSourceDlvCharge,queryBuildDataSourceVend;
SysReferenceTableLookup sysTableLookup = SysReferenceTableLookup::newParameters(tableNum(afmATPDlvCharge), _formReferenceControl, true);
sysTableLookup.addLookupField(fieldNum(afmATPDlvCharge, name));
sysTableLookup.addLookupField(fieldNum(afmATPDlvCharge, ChargeType));
sysTableLookup.addLookupField(fieldNum(afmATPDlvCharge, InvoiceAccount));
sysTableLookup.addLookupField(fieldNum(afmATPDlvCharge, Amount));
queryBuildDataSourceDlvCharge = query.addDataSource(tableNum(afmATPDlvCharge));
queryBuildDataSourceVend = queryBuildDataSourceDlvCharge.addDataSource(tableNum(VendTable));
queryBuildDataSourceVend.joinMode(JoinMode::ExistsJoin);
queryBuildDataSourceVend.relations(false);
queryBuildDataSourceVend.addLink(fieldNum(afmATPDlvCharge, invoiceAccount), fieldNum(VendTable, invoiceAccount));
queryBuildDataSourceVend.addRange(fieldNum(VendTable, AccountNum)).value(queryValue(_vendAccount));
sysTableLookup.parmQuery(query);
aTPDlvCharge = sysTableLookup.performFormLookup();
return aTPDlvCharge;
}
Comments
Post a Comment