public void lookup()
{
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
SysTableLookup sysTableLookup;
;
//Create an instance of SysTableLookup with the form control passed in
sysTableLookup = SysTableLookup::newParameters(tablenum(smmBusRelSubSegmentGroup), this);
//Add the fields to be shown in the lookup form
sysTableLookup.addLookupfield(fieldnum(smmBusRelSubSegmentGroup, SubsegmentId));
sysTableLookup.addLookupfield(fieldnum(smmBusRelSubSegmentGroup, SegmentId));
sysTableLookup.addLookupfield(fieldnum(smmBusRelSubSegmentGroup, SubSegmentDescription));
//create the query datasource
queryBuildDataSource = query.addDataSource(tablenum(smmBusRelSubSegmentGroup));
//Only show LocalEndpoints for the current company
queryBuildRange = queryBuildDataSource.addRange(fieldnum(smmBusRelSubSegmentGroup, SegmentId));
queryBuildRange.value(Search_Segment.text());
//Assign the query to the lookup form
sysTableLookup.parmQuery(query);
// Perform lookup
sysTableLookup.performFormLookup();
super();
}
No comments:
Post a Comment