Form Data Source Field
public void lookup(FormControl _formControl, str _filterStr)
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(custTable), _formControl);
sysTableLookup.addLookupField(fieldNum(CustTable, AccountNum));
sysTableLookup.addLookupField(fieldNum(CustTable, CustGroup));
queryBuildDataSource = query.addDataSource(tableNum(CustTable));
queryBuildDataSource.addRange(fieldNum(CustTable, CustGroup)).value('40');
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
Form String Control
public void lookup()
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(custTable), this);
sysTableLookup.addLookupField(fieldNum(CustTable, AccountNum));
sysTableLookup.addLookupField(fieldNum(CustTable, CustGroup));
queryBuildDataSource = query.addDataSource(tableNum(CustTable));
queryBuildDataSource.addRange(fieldNum(CustTable, CustGroup)).value('40');
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
Form Reference Group Control
public common lookupReference()
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(custTable), this);
sysTableLookup.addLookupField(fieldNum(CustTable, AccountNum));
sysTableLookup.addLookupField(fieldNum(CustTable, CustGroup));
queryBuildDataSource = query.addDataSource(tableNum(CustTable));
queryBuildDataSource.addRange(fieldNum(CustTable, CustGroup)).value('40');
sysTableLookup.parmQuery(query);
return sysTableLookup.performFormLookup();
}
Leave a comment