Belajar Komputer & Gadget

Download BlueStacks  & install Download Kingroot APK Download Lucky Patcher APK Download Fake GPS APK .  Click “Direct Download APK From Dropapk” link (Eliminate all popups). Continue to “Free Download”. Click “Create download link” then click the generated link. We suggest you pay for this  app from Google Play  versus grabbing freely above then backup the app on mobile and restore in BlueStacks. The above site will pop up many ads and malware sites. If you do not have a malware blocker installed you just very well get a malware virus installed onto your computer. Download Developer Options Tool APK Download Pokemon GO APK Setelah semua sofware terunduh saatnya untuk melakukan root pada BlueStacks, instal aplikasi lalu mainkan PokemonGo! Open BlueStacks dan install Kingroot APK menggunakan APK icon pada sisi kiri. Setelah terinstal jalankan tool pada Kingroot sampai 100%. Berikutnya install Lucky Patcher APK Jangan install Fake GPS men...

static void DateRangeTest(Args _args) { DateRangeTest drt; Query query=new Query(); QueryRun qrun; QueryBuildDataSource qbds; QueryBuildRange qbr; date d=today(); qbds=query.addDataSource(tableNum(DateRangeTest)); qbr=qbds.addRange(fieldNum(DateRangeTest,dataAreaId)); //Method 1 //qbr.value(strfmt(‘(%1<=%2)&& (%3>=%4)’,fieldstr(DateRangeTest,FromDate),Date2StrXpp(d),fieldstr(DateRangeTest,ToDate),Date2StrXpp(d))); //Method 2 qbr.value(strfmt(‘(FromDate<=%1)&& (ToDate>=%2)’,Date2StrXpp(d),Date2StrXpp(d))); qrun=new QueryRun(query); info(qrun.query().dataSourceNo(1).toString()); while(qrun.next()) { drt=qrun.get(tableNum(DateRangeTest)); info(drt.Name); } info(drt.getSQLStatement()); } source

SELECT * FROM SalesTable(SalesTable_1) JOIN * FROM SalesLine(SalesLine_1) ON SalesTable.SalesId = SalesLine.SalesId JOIN * FROM CustTable(CustTable_1) ON SalesTable.CustAccount = CustTable.AccountNum Query query = new Query(); QueryBuildDataSource salesTableDS; QueryBuildDataSource salesLineDS; QueryBuildDataSource custTableDS; salesTableDS = query.addDataSource(tableNum(SalesTable)); salesLineDS = salesTableDS.addDataSource(tableNum(SalesLine)); salesLineDS.relations(true); salesLineDS.fetchMode(QueryFetchMode::One2One); custTableDS = salesTableDS.addDataSource(tableNum(CustTable)); custTableDS.relations(false); custTableDS.addLink(fieldNum(SalesTable, CustAccount), fieldNum(CustTable, AccountNum)); custTableDS.fetchMode(QueryFetchMode::One2One); info(salesTableDS.toString());

Axapta query on multiple tables Hey friends try this code to add multiple tables in query. QueryRun selectReportQuery() {     Query                   query           = new Query();     QueryRun                localQueryRun;     QueryBuildDataSource    qbds1;     QueryBuildDataSource    qbds2;     QueryBuildDataSource    qbds3;     ;     qbds1 = query.addDataSource(tableNum(salesTable));     qbds1.addRange(fieldNum(salesTable, affVendorAdjust)).value('1');     qbds2 = qbds1.addDataSource(tableNum(custInvoiceJour));     qbds2.fetchMode(JoinMode::InnerJoin);     qbds2....

Hi Friends, In this post I'll like to share how to use NOT LIKE operator in X++. LIKE keyword is available in X++ but  NOT LIKE is not directly supported the way it works in SQL. It still can be achieved using X++ select statements as well as in query range values. For illustration, I'll use an example to select all customer group records which do not start with "1" and do not start with "2", using a select statement as well as using a query object in X++. Query Object: If we need to write this in query range , then you need to use the power of expressions in the query range value. Visit  using expressions in query ranges  to get more details. In the expression use '!1*' to define a not like condition and then separate other values  by a comma (,) as a comma will represent an AND condition in the query range expression.  To quickly use the code, here it goes:     CustGroup         ...

Create an Excel File using X++ Creating an excel file is essential mostly in data import or export. Microsoft Dynamics AX has a feature to import and export through excel template. But in some cases, you need to create an excel to integrate with other application. Below is an example of creating an excel file in X++ using an existing table in AX. static void ExportToExcel(Args _args) { #AviFiles SysOperationProgress progress = new SysOperationProgress(); SysExcelApplication sysExcelApplication; SysExcelWorkbooks sysExcelWorkBooks; // Filename to which you will be writing your data FileName fileName = "C:\\Windows\\Temp\\ExportToExcel.xlsx"; SysExcelWorkbook sysExcelWorkBook; SysExcelWorkSheets sysExcelWorkSheets; SysExcelWorkSheet sysExcelWorkSheet; SysExcelWorkSheet sysExcelWorksheetBackOrder; SysExcelWorksheet sysExcelWorkSheetToBeDeleted; SysExcelStyles ...

To round number in AX, we can use 2 method. If we wanna round up, we can use  RoundUp(real value, real unit)  function and we can use  RoundDown(real value, real unit)  function if we wanna round down numbers. For example, we can see the source code of a job below : static void Rounding(Args _args) {     real    temp, roundingUp, roundingDown;     ;     temp = 3000 / 7;     roundingUp = roundUp(temp, 1);     roundingDown = roundDown(temp, 1);     info(strFmt("Origin : %1 RoundingUp : %2 RoundingDown : %3", temp, RoundingUp, roundingDown)); } The result is like a picture below :