Create a lookup

static void lookupFinancialDimensionSet(FormStringControl    _ctrl)
{
SysTableLookup          sysTableLookup;

Query   q;
QueryBuildDataSource    qbds;
QueryRun  qr;
QueryBuildRange qbr;
;
q = new Query();
qbds = q.addDataSource(tableNum(DimensionHierarchy));
qbr = qbds.addRange(fieldNum(DimensionHierarchy,StructureType));
qbr.value(queryValue(DimensionHierarchyType::Focus));

sysTableLookup = SysTableLookup::newParameters(tableNum(DimensionHierarchy), _ctrl);
sysTableLookup = SysTableLookup::newParameters(tableNum(DimensionHierarchy), _ctrl);
sysTableLookup.addLookupfield(fieldNum(DimensionHierarchy, Name));
sysTableLookup.addLookupfield(fieldNum(DimensionHierarchy, Description));

sysTableLookup.parmQuery(q);
sysTableLookup.performFormLookup();

}

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s