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?

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Martin Dráb 237,878 Most Valuable Professional on at

Like (2)

Report
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);

Was this reply helpful? Yes No
Suggested answer

Ariba Mehdi 166 on at

Like (0)

Report

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!

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

Like (1)

Report
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.

Was this reply helpful? Yes No
Suggested answer

Mohamed Amine Mahmoudi 26,390 Super User 2025 Season 2 on at

Like (0)

Report

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

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

Like (1)

Report

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.

Was this reply helpful? Yes No
Layan Jwei 8,112 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Jason0810M 8 on at

Like (0)

Report

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.

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

Like (0)

Report

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.

Was this reply helpful? Yes No