Apr 13, 2016

Query로 Lookup 보여주기

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