ax没有distinct ,只能projId进行group by


Query query =new Query();
SysTableLookup lookup;
QueryBuil dDataSource ds;
TableId table=tableNum(InventTrans);
FieldId field=fieldNum(InventTrans,projId);
;
lookup=SysTableLookup::newParameters(table,this);
ds=query.addDataSource(table);
ds.orderMode(OrderMode::GroupBy);
ds.addSelectionField(field,SelectionField::Database);
ds.addSortField(field);
// 等价于 select projId from inventTrans group by projId
lookup.parmQuery(query);
lookup.addLookupfield(field);
lookup.performFormLookup();

posted on 2014-08-20 14:30  Kobe.Zhang  阅读(185)  评论(0编辑  收藏  举报

导航