Skip to main content

Posts

Showing posts with the label while

How to update funding Source for Project Contract in Ax 2012

If you want to  update funding Source for Project Contract in Ax 2012 by code then you can get idea from below code.  These all standard table. ProjFundingSource projFundingSource; ProjInvoiceTable projInvoiceTable; LogisticsLocation logisticsLocation,logisticsLocationNew; ; ttsBegin; while select projInvoiceTable order by ProjInvoiceProjId desc { if(projInvoiceTable.ProjInvoiceProjId != "S_002834") { if(projInvoiceTable.fundingSourceName() != "") { while select forUpdate projFundingSource where projFundingSource.ContractId == projInvoiceTable.ProjInvoiceProjId { projFundingSource.FundingSourceId = projInvoiceTable.fundingSourceName(); projFundingSource.InvoiceLocation = 0; projFundingSource.update(); } } } else break; } ttsCommit;

Sample code Example of Array in MSD Axapta

This is  Sample code  Example of Array in Axapta . str name; Array Arr = new Array (Types::String); int i= 1, j; Int test; TestTable TestTable; ; // Create an Str array // Write some elements in it while select TestTable { Arr.value(i, TestTable.TestTables);//(i, i*2); i++; } j = i; for (i = 1; i<j; i++) { test= Arr.value(i); while select TestTable where TestTable.TestTables == test { info(strfmt("%1", Arr.value(i))); } }

How to Call query in MSD Axapta by code

To Call query in Axapta by code you can try below code. You need to create query in aot query node then pass query using querystr method in queryrun object. QueryRun queryRun; int cnt; ; queryRun = new QueryRun(queryStr(Query1)); if (queryRun.prompt()) { while (queryRun.next()) { cnt++; }

Code to Get all table id of axapta AOT

Try this code in job static void findTables(Args _args) { Dictionary dictionary; TableId tableId; tableName tableName; ; dictionary = new Dictionary(); tableId = dictionary.tableNext(0); tableName = dictionary.tableName(tableId); while (tableId) { info(strfmt("%1 - %2",int2str(tableId), tableName)); tableId = dictionary.tableNext(tableId); tableName = dictionary.tableName(tableId); } }