web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Show temporary buffer ...
Microsoft Dynamics AX (Archived)

Show temporary buffer in form after data is loaded

(0) ShareShare
ReportReport
Posted on by Daniel Kodes 60

Hi,

here is my situation. I have a form (ax2009) with datasource linked to physical table. User open a form, data gets loaded from table and after that user press a button that should do some grouping to temporary buffer of same table as datasource and shown them in grid instead of current buffer.

Problem is that datasource is somehow linked to physical table and i cannot force it to display temporary data. Have you tried something like this? I tried the usually things like setTmp, setTmpData, executeQuery to fetch from tmp buffer,... but nothing works. Maybe i am missing something.

Set tmp buffer to datasource before data is loaded works fine - i.e. http://alexvoy.blogspot.cz/2012/03/how-to-make-temporary-instance-of.html

Thanks, 

Daniel

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,724 Super User 2026 Season 1 on at

    Hi Daniel,

    You can try to use the setCursor() command like:

    FormDataSource_ds.queryRun().setCursor(tmpTable);

  • Daniel Kodes Profile Picture
    Daniel Kodes 60 on at

    Hi Andre,

    thanks, i tried this already but without success.

    Here are snippets of 2 solutions i expected will work, but they are not

    void changeToTmpBuffer()

    {

       TableName tmpTable;

       ;

       // solution 1

       tmpTable.setTmp();

       tmpTable.setTmpData(populateTmpBuffer());

       FormDataSource_DS.queryRun().setCursor(tmpTable);

       FormDataSource_DS.executeQuery();

       // solution 2

       FormDataSource.setTmp();

       FormDataSource.setTmpData(populateTmpBuffer());

       FormDataSource_DS.executeQuery();

    }

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 303,724 Super User 2026 Season 1 on at

    Hi Daniel,

    It was just a guess as I had used the setCursor command in the past in classes. This worked for me. Have you tried also setting the Datasource propery AutoQuery to 'No'?

  • Daniel Kodes Profile Picture
    Daniel Kodes 60 on at

    Hi Andre,

    It didn't help either. I have decided this has no way out and i will have to try different approach for my problem.

    Thanks anyway

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans