AX Update Example

// Create an Axapta record for the StateAddress table.
axRecord = ax.CreateAxaptaRecord(tableName);

// Execute a query to retrieve an editable record where the name is MyState.
axRecord.ExecuteStmt(\"select forupdate * from %1 where %1.Name == 
    \'MyState\'\");

// If the record is found then update the name.
if (axRecord.Found)
{
    // Start a transaction that can be committed.
    ax.TTSBegin();
    axRecord.set_Field(\"Name\", \"MyStateUpdated\");
    axRecord.Update();

    // Commit the transaction.
    ax.TTSCommit();
}

// Create an Axapta record for the StateAddress table.

axRecord = ax.CreateAxaptaRecord(tableName);

// Execute a query to retrieve an editable record where the name is MyState.

axRecord.ExecuteStmt(\"select forupdate * from %1 where %1.Name ==

\'MyState\'\");

// If the record is found then update the name.

if (axRecord.Found)

{

// Start a transaction that can be committed.

ax.TTSBegin();

axRecord.set_Field(\"Name\", \"MyStateUpdated\");

axRecord.Update();

// Commit the transaction.

ax.TTSCommit();

}

AX Update Example

Search