Microsoft Dynamics AX (Archived)

How to insert the second record in a Temp Table?

(0) Share

Report

Posted on by daniele scr

110

In my form I used a Temporary Table in DataSource - with property TableType: InMemory .

In My form I have a simple code,like this:

public TableTmpTable insertRecords(String _param_I, string _param_II)
{ 
  TableTmpTable myInMemoryTable;

  myInMemoryTable.clear();
  myInMemoryTable.initValue();

  myInMemoryTable.Field_I =  _param_I;
  myInMemoryTable.Field_II = _param_II;

  myInMemoryTable.insert();

  return myInMemoryTable;
}

I need to call this method more than once.

But, whenI call the method I lost my previous record. How can insert more record in InMemory table in different time?

Thanks in advice!

*This post is locked for comments

All responses (4)

Answers (0)

daniele scr 110 on at

Like (0)

Report

RE: How to insert the second record in a Temp Table?

Very helpful advice. Thanks @Crispin John Augustine
daniele scr 110 on at

Like (0)

Report

RE: How to insert the second record in a Temp Table?

Thanks @Vilmos Kintera , good advice.
daniele scr 110 on at

Like (1)

Report

RE: How to insert the second record in a Temp Table?

Very helpful advice. Thanks @Crispin John Augustine
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

RE: How to insert the second record in a Temp Table?

You have to link the locally declared temporary table against the form datasource. It is done with setTmpData() for InMemory temporary tables.

https://community.dynamics.com/ax/b/dynamicsaxinsightbyanas/archive/2014/08/20/ax-2012-using-temporary-table-as-form-s-datasource