AX / Dynamics 365 For Finance and Operations blog

AX / D365FO – insert_recordset with a constant value X++

How can I use insert_recordset command in order to insert to table a column with ‘constant’ value.

something like:

insert_recordset mytable(mycol1, mycol2, mycol2)

select col1, col2, ‘bbbb’ from mytable2;

This can be achieved like shown in following code

String255 txt = "bbbb";<br>insert_recordset mytable(mycol1, mycol2, mycol2)<br>select col1, col2, txt from mytable2;