How do I display my data on a form when the datasource is a tempDb table

(0) Share

Report

Posted on by Sophs@4Sight

185

I have created a D365 F&O form that allows the user to define parameters and then press an Apply button. This button then runs a number of calculations and then writes the results to a tempDB table.

I have added this tempDb table as my datasource on the form. However I can not get the results to display on the form.

I originally created the table as a regular table so that I could debug and see the complete results in the db. So I used research(true) and refresh() to display the results on the form. Everything was working with the regular table.

This is not working on the tempDb table.

Please can you help and maybe point me to an example.

I get the following error also

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

All responses (1)

Answers (0)

Suggested answer

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

Like (0)

Report
How do I display my data on a form when the datasource is a tempDb table

Hi @Sophs@4Sight,

I think you need to add linkPhysicalTableInstance in init method.

public void init() { super(); {{yourdatasourcename}}_DS.linkPhysicalTableInstance({{tmpTableName}}); }

Otherwise can you please share with us your code.

Best regards,