Lookup method

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