I have a query in a lookup method. It is below. It looks to me work slowly. I added index below but it doesn't make to much performance increase.
How can i amke it run quicklier?
Thanks...
Query query = new Query();
QueryBuildDataSource queryBuildDataSource;
QueryBuildRange queryBuildRange;
SysTableLookup sysTableLookup = SysTableLookup::newParameters(tableNum(inventTrans), _formcontrol);
;
sysTableLookup.addLookupField(fieldNum(inventTrans, inventTransid));
sysTableLookup.addLookupField(fieldNum(inventTrans, Transtype));
sysTableLookup.addLookupField(fieldNum(inventTrans, TransRefid));
sysTableLookup.addLookupField(fieldNum(inventTrans, itemid));
sysTableLookup.addLookupField(fieldNum(inventTrans, Qty));
queryBuildDataSource = query.addDataSource(tableNum(inventtrans));
queryBuildDataSource.addRange(fieldNum(inventTrans, itemid)).value(CNK_IthalatSatir.urunKodu);
queryBuildDataSource.addRange(fieldNum(inventTrans, TransType)).value(enum2str(inventTransType::Purch));
queryBuildDataSource.addSortIndex(indexnum(inventtrans, itemidx));
sysTableLookup.parmQuery(query);
sysTableLookup.performFormLookup();
[Non-text portions of this message have been removed]
SPONSORED LINKS
| Computer part | Programming languages | Microsoft axapta |
| Support exchange |
YAHOO! GROUPS LINKS
- Visit your group "development-axapta" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
