Use the SourceTableTemporary in Page

harounmounirharounmounir Member Posts: 20
Hi ,

i would like to show just record with 'FINANCES' when page are open

OnOpenPage()
recJetReportOpalrt.RESET;
TempRecJetReportOpalrt.DELETEALL;
recJetReportOpalrt.SETFILTER("Security Group", 'FINANCES');
IF recJetReportOpalrt.FINDSET THEN BEGIN
REPEAT
TempRecJetReportOpalrt.INIT;
TempRecJetReportOpalrt.TRANSFERFIELDS(recJetReportOpalrt);
TempRecJetReportOpalrt.INSERT();
UNTIL recJetReportOpalrt.NEXT = 0;
END;

CurrPage.SETRECORD(TempRecJetReportOpalrt);
CurrPage.UPDATE;

But this code doesn't work properly.

suggestion or help

Thanks


Comments

  • AKAK Member Posts: 226
    If you set SourceTableTemporary to yes, rec is temporary. Use it instead of TempRecJetReportOpalrt and drop the last two lines of your code.
  • krikikriki Member, Moderator Posts: 9,088
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!


  • harounmounirharounmounir Member Posts: 20
    edited 2018-11-08
    Thanks it working
Sign In or Register to comment.