Code not working for all lines of table

lavanyaballurgi

Hey guys,

My aim - to make ENDING NO field of NO. SERIES LINES blank for last month's number series. So I created a form with a button & here is code.

<Control1000000000> - OnPush()
gdt_firstdate := 0D;
gdt_firstdate := CALCDATE('<-CM>', TODAY);
grc_NoSeriesline.SETRANGE("Starting Date",gdt_firstdate);
IF grc_NoSeriesline.FINDSET THEN
REPEAT
grc_NoSeriesline.VALIDATE("Ending No.",'');
UNTIL grc_NoSeriesline.NEXT=0;

Now this works only for last line of table. What am I missing here?

mohana_cse06

How many lines you have in No. Series Line table with Starting Date 01-06-2012?

lavanyaballurgi

9 lines and if i put
message('%1', "series code");
it shows all 9 series code which means the loop is working fine but when I see the field "ENDING NO." for those 9 lines only last one is blank

mohana_cse06

where is
grc_NoSeriesline.MODIFY;
in Loop..

lavanyaballurgi

YOU ARE RIGHT ... ](*,)

now its working... i shud have realized this #-o by seeing that only last line was getting updated which means the MODIFY is working only outside loop.

thanks & sorry for consuming so much time of yours/