RecordInsertList and TempDB

(1) Share

Report

Posted on by Jason0810M

Hello,

I have a tempDB datasource on my form and I need to optimize my logic a bit.

I wanted to implement a RecordInsertList but there are no records being found in the temporay table using this.

The method to populate the temp table is as follows;

RecordInsertList list = new RecordInsertList(tableNum(XXXTableTmp));

XXXTableTmp tmp;

int countLoops;

while (qr.next())
{

CustTable custTable = qr.get(tablenum(CustTable));

tmp.CustAccount = custTable.AccountNum;

list.add(tmp);

countLoops++;

//tmp.doInsert()

}

if (countLoops)

{

ttsbegin;

list.insertdatabase();

ttscommit;

}

select * from tmp;

return tmp;

The doInsert() logic works perfectly fine. However not the insertrecordlist.

Is this the correct approach to do this?

All responses (8)

Answers (1)

Sort by

Verified answer

Martin Dráb 240,817 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!
You need to tell RecordInsertList which temporary buffer it should insert records to:

Notice the last argument of the constructor:

XXXTableTmp tmp; RecordInsertList list = new RecordInsertList(tableNum(XXXTableTmp), true, true, true, true, true, tmp);
Suggested answer

Ariba Mehdi 166 on at

Like (0)

Report
Copy link

Link copied!

Hi there,

I believe that RecordInsertList is not initialized correctly. Please try initializing these elements like this:

RecordInsertList list;

CustTable custTable;

list = new RecordInsertList(tableNum(custTable));

Refer to these link:

https://www.schweda.net/blog_ax.php?bid=509&wdl=en

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

Hope it helps!
Martin Dráb 240,817 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Ariba, what problem do you think that your code solves? As far as I know, it's exactly the same thing as what Jason had, you just used a different table (CustTable) instead of XXXTableTmp.

Your code can be rewritten as

RecordInsertList list = new RecordInsertList(tableNum(CustTable)); CustTable custTable;

and it'll still behave exactly the same.

It doesn't address the problem of the temporary table buffer.
Suggested answer

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

Like (0)

Report
Copy link

Link copied!

Hi Jason0810M,

I hope this can help you and give you some hints

https://alexdmeyer.com/2022/02/01/how-to-use-temp-tables-as-grid-datasources-for-data-analytics-in-d365fo/

https://www.linkedin.com/pulse/tempdb-table-form-datasource-populated-using-evgeniy-voloshchenko

https://community.dynamics.com/forums/thread/details/?threadid=5c055599-c111-45ef-8d04-38f62e93d9ad

Best regards,

Mohamed Amine MAHMOUDI
Martin Dráb 240,817 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Mohamed, please tell how these links solve the problem. All three look off-topic to me.

Just posting some random links is not a way how make this forum useful.
Layan Jwei 8,301 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Jason,

Using recordInsertList with tmp tables requires specifying the tmp table buffer in the 7th argument of RecordInsertList() -- just as Martin showed you.

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Jason0810M 8 on at

Like (0)

Report
Copy link

Link copied!

Hello Martin,

I think there's an issue as I am unable to mark your response as definite answer.

Passing the temp table buffer as argument parameter has indeed fixed my problem.

Thanks.
Martin Dráb 240,817 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, verifying answers often doesn't work.I was able to do it on your behalf; it seems to work better (but far from perfect) for moderators.