Form lookup with reange:
--
1.
public void lookup(FormControl _formControl, str _filterStr)
{
Query query = new Query();
SysTableLookup sysTableLookup;
QueryBuildDataSource queryBuildDataSource;
;
sysTableLookup = SysTableLookup::newParameters(tablenum(AddressCityTable_BR), _formControl);
sysTableLookup.addLookupfield(fieldnum(AddressCityTable_BR, City), true);
sysTableLookup.addLookupfield(fieldnum(AddressCityTable_BR, StateId));
sysTableLookup.addLookupfield(fieldnum(AddressCityTable_BR, CountryId));
queryBuildDataSource = query.addDataSource(tablenum(AddressCityTable_BR));
queryBuildDataSource.addRange(fieldnum(AddressCityTable_BR, StateId)).value(queryValue(zipCode.State));
queryBuildDataSource.addRange(fieldnum(AddressCityTable_BR, CountryId)).value(queryValue(zipCode.CountryRegionId));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
--
1.
public void lookup(FormControl _formControl, str _filterStr)
{
Query query = new Query();
SysTableLookup sysTableLookup;
QueryBuildDataSource queryBuildDataSource;
;
sysTableLookup = SysTableLookup::newParameters(tablenum(AddressCityTable_BR), _formControl);
sysTableLookup.addLookupfield(fieldnum(AddressCityTable_BR, City), true);
sysTableLookup.addLookupfield(fieldnum(AddressCityTable_BR, StateId));
sysTableLookup.addLookupfield(fieldnum(AddressCityTable_BR, CountryId));
queryBuildDataSource = query.addDataSource(tablenum(AddressCityTable_BR));
queryBuildDataSource.addRange(fieldnum(AddressCityTable_BR, StateId)).value(queryValue(zipCode.State));
queryBuildDataSource.addRange(fieldnum(AddressCityTable_BR, CountryId)).value(queryValue(zipCode.CountryRegionId));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
}
No comments:
Post a Comment
Leave your comments and solutins