how to update a temporary table?

Finance and Operations/AX Developer Forum
1

Hi,

i have a form with some records from temporary table.i am opening a new form where i am giving some values.

and after clicking ok that values should update against the records(from temporary table) showing in the main form.

how can i update the records against records from temporary table.

2

Hi shashank,

In case your still want to update the data.

If your datasource of the temptable is called tmptable this is the code to do it.

TmpTable localTmpTable;
;
localTmpTable.setTmpData(tmpTable);

ttsbegin;
while select forupdate localTmpTable
{
localTmpTable.Field1 = “NewValue”;
localTmpTable.doUpdate();
}

ttscommit;
tmpTable.setTmpData(localTmpTable);
tmpTable_ds.executeQuery();

Hope it helps you.