11/06/2016

Axapta : How to update TmpTable.

Axapta : How to update TmpTable.
how to update a temporary table?
  1. TmpFormLookUp       TableTmpFormLookUp;
  2.  ;
  3.  
  4. TableTmpFormLookUp.setTmpData(TmpFormLookUp);
  5. ttsbegin;
  6.    SELECT FORUPDATE * FROM TableTmpFormLookUp
  7.    WHERE TableTmpFormLookUp.RecId == 'DATA ID';
  8.    {
  9.         TableTmpFormLookUp.adjustNow  = 'DATA';
  10.         TableTmpFormLookUp.doUpdate();
  11.    }
  12. ttscommit;
  13. TmpFormLookUp.setTmpData(TableTmpFormLookUp);
  14. TmpFormLookup_ds.executeQuery();


Example :: Forms\InventAdjTransaction ---> UpdateFromFile
Example :: Web http://dynamicsuser.net/ax/f/11/t/42653

No comments:

Post a Comment