Use the SourceTableTemporary in Page

harounmounir

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

AK

If you set SourceTableTemporary to yes, rec is temporary. Use it instead of TempRecJetReportOpalrt and drop the last two lines of your code.

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

harounmounir

Thanks it working