How to pass temporary table from form to another?

(0) Share

Report

Posted on by BASMA

932

I pass a temporay table from form A :

 select * from browsedmenuItemsTmp where browsedmenuItemsTmp.MatrixRole == matrixRole.MatrixID;
        args.record(browsedmenuItemsTmp);
        args.parm(matrixRole.MatrixID);

        args.name(formstr(form B));
        formRun        = ClassFactory.formRunClass(args);
        formRun.init();
        formRun.run();
        formRun.wait();

in the form B , I add the temporary table in datasource and I add this code in the init method of from B:

    parmid   = element.args().parm();
    browsedMenuItemsTmp = element.args().record();
    query                    = new Query();
    queryBuildRange1         = query.addDataSource(tablenum(MenuItemTmp)).addRange(fieldnum(MenuItemTmp,MatrixRole));
    queryBuildRange1.value(parmid);
    MenuItemTmp_ds.query(query);

But I don't get any values in the form B

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi BASMA,

After the queryRun is initialized on form B and temp datasource added you need to indicate which temp cursor to use with setRecord method.

this.queryRun().setRecord(browsedMenuItemsTmp)

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

I would try to split the problem in many pieces.

1) Sending temp table pointer from place A to place B. Please make sure that you have data in your temp table pointer. Also, if you use args.record() it passes only one record so that's not the way to pass a temp table pointer (of many records). Instead you could use args.object to pass it.

2) Using temp table as form data source. It seems that you are not setting the temp table correctly as data source of form B. Have you used temp tables as form data sources before? The detailed solution depends if you use InMemory or TempDB table so please try to search articles for your case.

3) I always suggest launching forms via menu items (using MenuFunction class), this way the security framework of AX is used (it doesn't open the form if your user doesn't have access to the menu item via privileges).

Does this help? If not, please share more details about which part is not working, and also your updated code. Thanks!

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

Thanks Nikoloas,

I can now get the values from tmp table

I stock values in this table on form B using the insertRecord method then I call it in the init method of form B .

But now I can't get selected record from grid which has tmp table as datasource.

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

What do you mean that you can't get selected record from the grid?

Do you now see the temp table records in the grid of form B?

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report
Yes now I can see all record of tmp table :

But When I select record always I get the first record:

MultiSelectionHelper selectionHelper = MultiSelectionHelper::construct(); selectionHelper = MultiSelectionHelper::construct(); selectionHelper.parmDataSource(MenuItemTmp_ds); browsedMenuItems = selectionHelper.getFirst(); while (browsedMenuItems) { browsedMenuItems = selectionHelper.getNext(); }

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (0)

Report

What do you mean "always I get first record"?

Do you mean that multiselectionhelper returns you only the first (on the top of the grid) record of your grid? Or something else?

Do you have many data sources in your form? Are you sure that the grid and the multiselectionhelper are using the same data source?

Was this reply helpful? Yes No
BASMA 932 on at

Like (0)

Report

yes, I means that multiselectionhelper returns only the first(on the top of the grid) record of your grid.

I have 2 datasources .

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Then most likely your MultiSelectionHelper is attached to the wrong data source.

Please double check that the DS of your grid is really called MenuItemTmp_ds (which is the one that you use with MultiSelectionHelper).

Was this reply helpful? Yes No