Use the SourceTableTemporary in Page

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 Posts: 199Member
    If you set SourceTableTemporary to yes, rec is temporary. Use it instead of TempRecJetReportOpalrt and drop the last two lines of your code.
  • krikikriki Posts: 8,570Member, Moderator
    [Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2018: 22 & 23 November 2018, Antwerp (Belgium)
  • harounmounirharounmounir Posts: 6Member
    edited 2018-11-08
    Thanks it working
Sign In or Register to comment.