SETSELECTIONFILTER and Total Amount
in [Navision]
|
Prev: Freelance/Independant Dynamics Nav (Navision) Consultant looking for new projects worldwide
Next: NAVIN 2009 SP1 : C - FORM Issue
From: Subrata Bauri Subrata on 29 Oct 2009 02:09 Dear all, How to use the SETSELECTIONFILTER function to sum up of a columnar value in realtime during lines selection ??
From: Peter D. J�rgensen on 29 Oct 2009 04:41 > How to use the SETSELECTIONFILTER function to sum up of a columnar value > in > realtime during lines selection ?? Untested: OnAfterGetCurrentRec: MyTotal := 0; CurrForm.SETSELECTIONFILTER(LocalRec); IF LocalRec.FINDSET THEN REPEAT MyTotal := MyTotal + LocalRec.Amount; UNTIL LocalRec.NEXT = 0; Any problems in that? (Besides the performance...) /Peter
From: Subrata Bauri on 10 Nov 2009 02:28
"Peter D. Jørgensen" wrote: > > How to use the SETSELECTIONFILTER function to sum up of a columnar value > > in > > realtime during lines selection ?? > > Untested: > > OnAfterGetCurrentRec: > MyTotal := 0; > CurrForm.SETSELECTIONFILTER(LocalRec); > IF LocalRec.FINDSET THEN > REPEAT > MyTotal := MyTotal + LocalRec.Amount; > UNTIL LocalRec.NEXT = 0; > > Any problems in that? (Besides the performance...) > > /Peter > > > . > Yes , Sir. I have already tested it. It does work correctly. |