IT : Cara untuk melakukan format flashdisk FAT32 ke NTFS

1. Klik kanan pada My Computer, dan klik Manage
2. Klik pada Device Manager dan kemudian pilih Disk Drive seperti pada gambar di bawah :

3. Klik kanan pada USB Drive yang dipilih dan klik Properties. Klik pada tab Policies, Anda akan mendapatkan 2 pilihan yaitu "Optimize for quick removal" dan "Optimize for performance". Pilih pilihan kedia yaitu "Optimize for performance" (jika pengguna windows xp, vista dan 7) jika anda pengguna windows 8 dan windows 10 pilihlah yang Better Performance.

4. Klik Ok dan menuju ke My Computer. Klik kanan pada drive di My Computer dan polih Format. Pada File System pilih format NTFS dan klik start untuk memulai.

5. Selesai

AX : Contoh Lain Query SUM di AX 2012

public void executeQuery()
{
    Query                   query,queryline;
    QueryRun                            qr, qrAPInvoice;
    QueryBuildDataSource    queryBuildDataSource,querylinesource;
    //QueryBuildFieldList qbfl = queryBuildDataSource.fields();
    QueryBuildRange         queryBuildRange,queryrangeline;

    //   QueryBuildFieldList  qbfl       = queryBuildDataSource.fields();
    Common                  common;
    str                     recIds;
    PurchDP_Header       argsRecord;
    LedgerJournalTrans ldjt;

        //this.query().dataSourceNo(1).clearRanges();
        // Get all the markupTrans recIds for the
        // sales header and lines.
        argsRecord = element.args().record();
        recIds = argsRecord.Nomor_PurchDP;

        query = new Query();
        queryBuildDataSource = query.addDataSource(tableNum(LedgerJournalTrans));
        queryBuildRange  = queryBuildDataSource.addRange(fieldNum(LedgerJournalTrans,Nomor_DP));
        // If no RecIds for markupTrans are associated with the sales order, passing in an empty
        // string was causing there to be no filter on recId and returning all records.
        if(recIds)
        {
            queryBuildRange.value(queryValue(recIds));
         // PurchDP_Header_ds.object(fieldNum(PurchDP_Header, VendorAccount)).allowEdit(false);

        }
        else
        {
            queryBuildRange.value(SysQuery::valueEmptyString());

        }
    //QBFL SUM
      queryBuildDataSource.addSelectionField(fieldNum(LedgerJournalTrans,AmountCurDebit),SelectionField::Sum);
     queryBuildDataSource.addSelectionField(fieldNum(LedgerJournalTrans,AmountCurCredit),SelectionField::Sum);

    queryBuildDataSource.addSortField(fieldnum(LedgerJournalTrans,journalnum));
    queryBuildDataSource.addSortField(fieldnum(LedgerJournalTrans,voucher));
    queryBuildDataSource.addSortField(fieldnum(LedgerJournalTrans,nomor_dp));
    queryBuildDataSource.addSortField(fieldnum(LedgerJournalTrans,nomor_pa));
    queryBuildDataSource.addSortField(fieldnum(LedgerJournalTrans,amountdp));
queryBuildDataSource.orderMode(OrderMode::GroupBy);

          qr = new QueryRun(query);
while (qr.next())
    {
     ldjt = qr.get(tableNum(LedgerJournalTrans));
      LedgerJournalTransTemp.clear();
      LedgerJournalTransTemp.Nomor_DP = ldjt.Nomor_DP;
      LedgerJournalTransTemp.Nomor_PA = ldjt.Nomor_PA;
        LedgerJournalTransTemp.Voucher = ldjt.Voucher;
        LedgerJournalTransTemp.JournalNum = ldjt.JournalNum;
      LedgerJournalTransTemp.AmountCurDebit = ldjt.AmountCurDebit;
        LedgerJournalTransTemp.AmountCurCredit = ldjt.AmountCurCredit;
        LedgerJournalTransTemp.AmountDP = ldjt.AmountDP;

        LedgerJournalTransTemp.insert();

    }



    super();
}

AX : Sum di AX 2012

You can use the following code:
QueryBuildFieldList  qbfl       = qbds.fields();
qbds = q.addDataSource(tablenum(SalesLine));
//QBFL
qbfl.addField(fieldNum(SalesLine,SalesQty),SelectionField::Sum);

qbds.addSortField(fieldnum(SalesLine,ItemId));
qbds.orderMode(OrderMode::GroupBy);

qr = new QueryRun(q);
while(qr.next())
{
salesLine = qr.get(tablenum(SalesLine));
info(strfmt('Item Id =%1, Qty = %2',salesLine.ItemId,salesLine.SalesQty));
}

Query : Query Pengurangan data Min kesatu dengan Min Kedua

contoh : 

SELECT a.NM_SHIFT, MIN( a.OFFERED ) AS c, ( (

SELECT b.OFFERED
FROM `patern_shift` b
WHERE b.NM_SHIFT = a.NM_SHIFT
ORDER BY b.OFFERED ASC
LIMIT 1 , 1
) - MIN( a.OFFERED )
) AS diff
FROM `patern_shift` a
GROUP BY a.NM_SHIFT

flag merag menunjukan data Min kedua

flag biru menunjukan data Min kesatu

Teamviewer : Reset password teamviewer tanpa instal ulang

[16:16, 6/15/2016] +62 813-3299-4153: [14:49, 6/7/2016] budi maho lagi: pakai tmac
[14:51, 6/7/2016] budi maho lagi: https://technitium.com/
[14:51, 6/7/2016] budi maho lagi: uninstall teamviewer
[14:52, 6/7/2016] budi maho lagi: http://dyandraraditya.blogspot.co.id/2015/05/mengatasi-team-viewer-expired.html
[16:16, 6/15/2016] +62 813-3299-4153: kemarin saya coba bisa
[16:16, 6/15/2016] +62 813-3299-4153: tanpa instal ulang

AX : Query Delete Table AX 2012

Contoh :

ttsBegin;
 
while select forUpdate myTable
    where myTable.AccountNum == '1000'
{
    myTable.delete();
}
ttsCommit;

atau

static void DeleteMultiRow1bJob(Args _args)
{
    MyWidgetTable tabWidget; // extends xRecord.
    ;
    ttsBegin;
    while select
        forUpdate
        tabWidget
        where tabWidget .quantity <= 100
    {
        tabWidget .delete();
    }
    ttsCommit;
} 

atau

static void DeleteMultiRow1aJob(Args _args)
{
    MyWidgetTable tabWidget;
    ;
    delete_from tabWidget
        where tabWidget .quantity <= 100;
}

Query : Query Create Table and Insert from other Table ( mssql )

select * into purchdplines from AGREEMENTLINE where 1=0;