บทความ

กำลังแสดงโพสต์จาก สิงหาคม, 2019

Ax How to set a where condition between two fields of a same table in AOT query

รูปภาพ
 this.query().datasourceTable(TableNum(CustTrans)).addRange(FieldNum(CustTrans,recid)).value(strFmt('(%1 - %2 > 0)', fieldStr(custtrans, amountcur),fieldStr(custtrans, settleamountcur) ) );     this.query().datasourceTable(TableNum(CustTrans)).addRange(FieldNum(CustTrans,recid)).value(strFmt('((%1 != %2))',fieldStr(CustTrans, AmountCur),fieldStr(CustTrans, SettleAmountCur)));

How multiple selec records in a grid !! Axapta

รูปภาพ
1. Set Properties Button     MultiSelection = Yes 2.Coding void clicked() {     Y_Customer    Customer;     MultiSelectionHelper helper = MultiSelectionHelper::construct();     helper.parmDatasource(Y_Customer_ds);     Customer = helper.getFirst();     while (Customer.RecId != 0)     {         info(Customer.CustAccount);         Customer = helper.getNext();     }     super(); }

How to add/remove Filter on Display Method Axapta

รูปภาพ
public void context() {     int                     selectedMenu;     formrun                 fr;     Args                    ag;     Name                    strtext;     querybuilddataSource    qb1;     queryrun                qr;     query                   q;     PopupMenu menu = new PopupMenu(element.hWnd());     int a = menu.insertItem('Filter By Field');     int b = menu.insertItem('Filter By Selection');     int c = menu.insertItem('Remove Filter');     ;     q   = TPI_SalesTableLineTC_ds.query();     qb1 = ...