How to link temp table filled in one class to a dialog form and display the data

(0) Share

Report

Posted on by Sangram Shinde

2,120

Hi Techies,

I am working on one requirement where we are processing some logic and filling temp table by selecting some records on form.Once we click a button- a class behind will process logic on selected records and fills a temp table with output. I have created a new dialog form which has this temp table as data source, and calling this form by using below code.

DialogRunbase dialogParameter = Dialog::newFormnameRunbase(formStr(customDialogForm),this);

        dialogParameter.caption("Parameter form");
        dialogParameter = this.dialogInternal(dialogParameter);
        return dialogParameter;

This shows me a dialog with fields obviously with blank data. Now my question is how can I refresh this dialog form with latest temp table buffer. Possibly I need to use linkPhysicalTableInstance() to get the latest buffer, I am searching more.

Can anyone help me on this please?

Any response is appreciated!

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

André Arnaud de Cal... 306,854 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi Sangram,

You can create a button on the form which will create an instance of the class using x++ coding. Then you can also create a method on the class to pass the temporary table to a variable of the class.

Was this reply helpful? Yes No
Verified answer

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

Like (1)

Report
Copy link

Link copied!

Yes, linkPhysicalTableInstance() is the right method *if* the type of the table is TempDB.

If it's an InMemory table, you need setTmpData().

Nevertheless I wonder whether temporary table is the right choice. How will you pack the data to store for batch processing, for instance?

Was this reply helpful? Yes No
Sangram Shinde 2,120 on at

Like (0)

Report
Copy link

Link copied!
Thanks Andre, Martin!

As said linkPhysicalTableInstance() worked. Below is the code.

DialogRunbase dialog; dialog = element.args().caller(); if (dialog && classIdGet(dialog.caller()) == classNum(callerClass)) { callerClassObject = dialog.caller(); dataSource.linkPhysicalTableInstance(callerClassObject.parmFillTmp()); }

Was this reply helpful? Yes No