records modifications

sbilly · **Posted:** Mon Mar 26, 2012 7:05 pm

Hi all,
I have a table with many lines. Only the "Entry No." is diffrent between lines.
I have many identical lines 2 by 2, only the "Entry No." is diffrent.
And I want to modify every second line of these 2 lines.
I hope that u understand what I want to do.
I created a report but it changes the 2 lines.
Thanks

Big D · **Posted:** Mon Mar 26, 2012 9:52 pm

Hi sbilly

You can have something like...

loop := 0
IF EntryRec.FINDFIRST then
repeat
loop += 1;
IF (loop MOD 2) = 0 THEN
//modify 2nd record code

until EntryRec.NEXT = 0;

Good luck

David Singleton · **Posted:** Mon Mar 26, 2012 10:14 pm

sbilly wrote:

Hi all,
I have a table with many lines. Only the "Entry No." is diffrent between lines.
I have many identical lines 2 by 2, only the "Entry No." is diffrent.
And I want to modify every second line of these 2 lines.
I hope that u understand what I want to do.
I created a report but it changes the 2 lines.
Thanks

sbilly, you should never be modifying entry tables directly.

Big D · **Posted:** Mon Mar 26, 2012 11:05 pm

Hi sbilly

You didn't mention Entry tables did you

!

Good luck

vijay_g · **Posted:** Tue Mar 27, 2012 8:11 am

Big D wrote:

Hi sbilly

You didn't mention Entry tables did you

!

Good luck

Is there any other table in navision having entry no. field(other than ledger table)? :-k

kriki · **Posted:** Tue Mar 27, 2012 3:22 pm

And using FINDFIRST in a LOOP is not a good idea.

Better would be:

Code: Select all

loop := 0
IF EntryRec.FINDSET(TRUE,TRUE) then
repeat
  loop += 1;
  IF (loop MOD 2) = 0 THEN BEGIN
    EntryRec2 := EntryRec;
    Change EntryRec2; 
  END;
until EntryRec.NEXT = 0;

The second TRUE in FINDSET(TRUE,TRUE) + using a second variable is maybe a little overkill, but it is definitely worth it using this technique to avoid possible problems that might arise if not using it. (problems like records that are skipped or changed multiple times,...)

mibuso.com

records modifications

Who is online