Export (0) Print
Expand All

update Table Method [AX 2012]

Updated: February 15, 2012

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

The update table method updates the current record with the contents of the buffer. It also updates the appropriate system fields.

The where clause is optional. When used, the where clause specifies a condition for update to test while processing each row of the table. Only those rows that test true against the condition are updated with the new values.

update_recordset is a record-set based operator—it updates multiple records at once.

To override the behavior of update, use the doUpdate method.

CustTable custTable;
    ttsBegin;
      select forUpdate custTable
      where custTable.AccountNum == '4000'; 
      custTable.CreditMax = 5000; 
      custTable.update(); 
    ttsCommit;

The example selects the table custTable for update. Any records with the AccountNum equal to 4000 are updated (in this case only one). The CreditMax field is changed to 5000.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show:
© 2014 Microsoft