Small and medium business | Business Central, N...

SetSelection Filter

(1) Share

Report

Posted on by CU27081143-0

Hi all,

I have Transfer some record from One table to Another table , here i need to transfer Only Selected Item From one from another ,I will try But Its won't Work

Kindly Help me

this is my code ..

                        RecStagingOutJnl.RESET;
                        RecStagingOutJnl.SETRANGE(RecStagingOutJnl."Upload in STD", false); 
                        RecStagingOutJnl.SETRANGE(RecStagingOutJnl."Uploded in STD", FALSE);
                        CurrPage.SetSelectionFilter(Rec);
                        IF RecStagingOutJnl.FINDSET THEN BEGIN // rec - custom table ..
                         ----
                         ----
                        End;

thanks In Advance..

Categories:

Dynamics 365 Business Central

All responses (3)

Answers (0)

Suggested answer

Ramiz 368 on at

Like (0)

Report
SetSelection Filter

Hi,

As mentioned by YUN ZHU, you need to loop the record.

trigger OnAction() var Customer: Record Customer; begin CurrPage.SetSelectionFilter(Customer); if Customer.FindSet() then repeat //Code until Customer.Next() = 0; end;
Suggested answer

YUN ZHU 74,218 Super User 2024 Season 2 on at

Like (0)

Report

SetSelection Filter

It seems that there is no loop, and you will only insert one piece of data this way. Try the Repeat-until control structure.

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-al-control-statements#repeat-until-control-structure

Thanks.

ZHU
Suggested answer

Khushbu Rajvi. 5,496 on at

Like (1)

Report

SetSelection Filter

Hope this helps: https://forum.mibuso.com/discussion/57178/copy-of-data-from-one-table-to-another-table