Tuesday, June 5, 2012

insert_recordset doesn't take the value of TableId from the value

Hi Folks,

Today, I have observed a very strange thing in AX.

I had to do a bulk insert from some other table where I also need to copy the tableId from the other table.

I have found a strange issue i.e.,everything was getting copied except the tableId. You can try this in a job.

insert_recordset TestTable1(RefRecId, RefTableId) select recId, TableId from TestTable2;

So, the tableid from some other table cannot be used in Insert_recordSet. Atlast, I had to use RecordInsertList class to insert the bulk data.

1 comment:

Jan B. Kjeldsen said...

You could insert from a variable (at least in later versions of AX).

int tab2 = tableNum(TestTable2);

insert_recordset TestTable1(RefRecId, RefTableId) select recId, tab2 from TestTable2