update_recordset / insert_recordset

Update recordset:
    MyTable myTableBuffer;

    update_recordset myTableBuffer
        field1 = 1,
        field2 = fieldX + fieldY
    where field1 == 0;

Insert recordset
    insert_recordset myTable (myNum, mySum)
        select myNum, sum(myValue) 
            from anotherTable 
            group by myNum 
            where myNum <= 100;




DaxOnline.org is free platform that allows you to quickly store and reuse snippets, notes, articles related to Dynamics AX.

Authors are allowed to set their own AdSense units.
Join us.

Blog Tags