Finance | Project Operations, Human Resources, ...

Insert Recordset and If statement

(0) Share

Report

Posted on by Community member

Hi, I would like to change isnert statement to insert_recordset in if statement.

Here is the sample code.

MyTable.Field1 = Value1

MyTable.Field2 = Value2

If (A=B)

{

MyTable.Field3 = Value3

}

Select firstonly InvoiceType

If (InvoiceType)

{

MyTable.Field4 = '0'

}

MyTable.Field5 = Value5

MyTable.insert();

How to change this code with insert_recordset??

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I think you can use RecordInsertList

Refer to this : https://learn.microsoft.com/en-us/dotnet/api/dynamics.ax.application.recordinsertlist

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Community member 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you for suggesting the answer.

I read the article but I did not get it completely.

Could you rewrite my code with RecordInsertList ?

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,801 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

e.g.

MyTable MyTable; SourceTable sourceTable; RecordInsertList myList; myList = new RecordInsertList(tableNum(MyTable)); while select sourceTable where ... { MyTable.clear(); MyTable.Field1 = sourceTable.Value1; MyTable.Field2 = sourceTable.Value2; If (sourceTable.A=sourceTable.B) { MyTable.Field3 = sourceTable.Value3; } Select firstonly InvoiceType; If (InvoiceType) { MyTable.Field4 = '0'; } MyTable.Field5 = sourceTable.Value5; myList.add(MyTable); } myList.insertDatabase();

Best regards,

Mohamed Amine MAHMOUDI

Was this reply helpful? Yes No
Suggested answer

Community member 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you for answering my question. I undestand that how to use RecordinsertList in general.

I still need to get support for the code below.

I think I can join the tableB and tableC, but I am really appreciate if you can rewrite the code again.

Thank you for in advance.

SourcetableA TableA;

SourcetableB TableB;

SourcetableC TableC;

str text;

MyTable.Field1 = Value1

MyTable.Field2 = Value2

If (TableA.A = TableA.B)

{

MyTable.Field3 = Value3

}

Select firstonly crosscompany InvoiceType

where InvoiceType.Filed4 = TableA.Field4

If (InvoiceType)

{

MyTable.Field5 = '0'

}

while select crosscompany TableC

order by InvoiceNumber asc

where TableC.Field6 = TableA.Field6

{
text+= strFmt('%1/',TableC.text);
}
text= subStr(subStr(text, 1, strLen(text) -1),1,155);
MyTable.text= text;

MyTable.insert();

Was this reply helpful? Yes No
Martin Dráb 239,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Your latest code doesn't make a good sense. You use fields of TableA (e.g. A or Field4), but they'll always be empty, because you've never set any value to tableA variable.

On the other hand, you've declared TableB but never used it for anything.

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi Community member,

Insert_recordset is used to copy data from one table to another. You can check this link for more details about it
https://learn.microsoft.com/en-us/dynamicsax-2012/developer/insert-recordset

However, as Mohamed said, i think you mean you want to use recordInsertList instead.

Looking at the last code you shared:
myTable and invoiceType tables are not declared

TableB is not used

TableA and TableC are not selected, so they will always be empty

So i'm not sure what you really mean by "I think I can join the tableB and tableC" if you don't use tableB in the first place and if table C is empty -- so please provide us with the correct code in order to help you.

Thanks,
Layan Jweihan

Was this reply helpful? Yes No
Suggested answer

Community member 10 on at

Like (0)

Report
Copy link

Link copied!

Sorry for the messy.

Here is the code which I would like to write with RecordInsertList.

MyTable My Table;

InvoiceTypeTable InvoiceType;

SourcetableA TableA;

SourcetableB TableB;

SourcetableC TableC;

str text;

MyTable.Field1 = TableA.Value1;

MyTable.Field2 = TableA.Value2;

Select firstonly crosscompany TableB

where TableB.Filed3 = TableA.Value3;

If (InvoiceType)

{

MyTable.Field3 = '0';

}

while select crosscompany TableC

order by TableC.InvoiceNumber asc

where TableC.Field4 = TableA.Value4

{
text+= strFmt('%1/',TableC.text);
}
text= subStr(subStr(text, 1, strLen(text) -1),1,155);
MyTable.text= text;

MyTable.Field5 = TableA.Value5;

MyTable.insert();

Was this reply helpful? Yes No
Martin Dráb 239,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
You marked your last reply as a suggested answer, but it doesn't seem to contain any solution for this thread. Please don't use it unless you're providing a possible solution.

Unfortunately your code still contains similar bugs. You never populate TableA and InvoiceType variables, therefore they'll always be empty. You also never use the value of TableB. Your code effectively does this:

SourcetableC tableC; str text; while select crosscompany tableC order by tableC.InvoiceNumber asc where tableC.Field4 = '' { text += strFmt('%1/',TableC.text); } text = subStr(subStr(text, 1, strLen(text) -1), 1, 155); MyTable myTable; myTable.Text = text; myTable.insert();

Was this reply helpful? Yes No
Community member 10 on at

Like (0)

Report
Copy link

Link copied!
Could you please just do only the code that can make sense?

I would like to rewrite with RecordInsertList.

SourcetableC tableC; str text; while select crosscompany tableC order by tableC.InvoiceNumber asc where tableC.Field4 = '' { text += strFmt('%1/',TableC.text); } text = subStr(subStr(text, 1, strLen(text) -1), 1, 155); MyTable myTable; myTable.Text = text; myTable.insert();

Was this reply helpful? Yes No
Martin Dráb 239,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

There is no need for RecordInsertList, because your code inserts a single record.

Note that Mohamed showed you how to use RecordInsertList (and you even replied that you knew how to use it).

Was this reply helpful? Yes No