update_recordset , insert_recordset, Delete records and select record of SQL in Dynamic AX 2012

//Select query in Dynamic AX 2012

 MyTable myTableBuffer;

;

Select myTableBuffer

where field1 == 0;

//use while select for multiple select

// Update query in Dynamic AX 2012

MyTable myTableBuffer;

;

update_recordset myTableBuffer

setting

    field1 = 1,

    field2 = fieldX + fieldY

where field1 == 0;

//Delete query in Dynamic AX 2012

static void DeleteMultiRow1aJob(Args _args)

{

    MyWidgetTable tabWidget;

    ;

    delete_from tabWidget

        where tabWidget .quantity <= 100;

}

// Insert query in Dynamic AX 2012

insert_recordset myTable (Field1, Field2)

    Field1= “QWERTyuioP”

Field2 = “ASDFghjkl” ;