Dear Friends,
I need a lookup for a dialog for a report. Which the dialog contains the ITEMNAME field it has to be group by ITEMGROUPID which available in the INVENTTABLE.
on dialog the code listed.
public Object dialog(Object _dialog)
{
DialogRunbase dialog = _dialog;
DialogGroup dialogGroup;
;
dialogGroup = dialog.addGroup("@SYS7402");
dialogGroup.frameType(1);
dialog.addGroup("@SYS7402", dialogGroup);
dialogCountName = dialog.addField(typeid(IName),“Item Name”);
dialogCountName.value(ItemName);
return dialog;
}
void Fld3_1_Lookup()
{
Query _Query = new Query();
QueryBuildDataSource qbds;
QueryBuildRange queryBuildRange;
SysTableLookup sysTableLookup;
;
sysTableLookup.addLookupfield(fieldnum(InventTable, ItemName));
qbds = _Query.addDataSource(tablenum(InventTable));
QueryBuildRange = qbds.addRange(fieldnum(InventTable, ItemName));
QueryBuildRange.value();
if(sysTableLookup)
{
sysTableLookup.parmQuery(_Query);
sysTableLookup.performFormLookup();
}
}
Here What the lookup method should contain.
Thanks in advance.
G.Rajkumar