Thanks to everyone who replied.
I will look into the method of updating the old records based on the original sequence number rather than just deleting all old records and adding the data back.
Thanks,
Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
IBM Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3
----- Original Message ----
From: Lim Hock-Chai <Lim.Hock-Chai@xxxxxxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, December 7, 2007 10:29:33 AM
Subject: RE: Resequence data in file based on screen seq
If seq# is not part of the unique key, you could do something like below
(Note: Syntax might be wrong.)
For sfRRN = 1 to ??
Chain sfRRN mySubFile;
if %found;
Chain (orgKey1 :orgKey2...) myFile;
if %found;
Seq# = sfRRN * 10;
update myFile;
endif;
endif;
Endfor;
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Young
Sent: Friday, December 07, 2007 9:05 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Resequence data in file based on screen seq
The reason I do not just update is that after the user enters all their
data, when writting back to the file, I need to sequence the data in
increments of 10 so that they can move things around without having to
change all records.
Thanks,
Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical
Solutions V5R2 IBM Certified Specialist- e(logo) server i5Series
Technical Solutions Designer V5R3 IBM Certified Specialist-
e(logo)server i5Series Technical Solutions Implementer V5R3
----- Original Message ----
From: Joep Beckeringh <joep@xxxxxxxxxxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Friday, December 7, 2007 9:02:22 AM
Subject: Re: Resequence data in file based on screen seq
Jeff,
Why do you delete all the records of the group? Why don't you just
update?
What I do in situations like is to store the original sequence # as a
hidden field in the subfile. With the original and new sequence # you
can determine what to do:
- original = 0 and new > 0: add
- original > 0 and new = 0: delete
- original <> new: update
The tricky bit is checking for duplicates. You need to check each
new/changed sequence # with the file and also check for duplicates
within the subfile.
Joep Beckeringh
Jeff Young schreef:
Let me clarify what I am attempting to do.
I have a file with the key: Company, Location, Item, Seq#, Substitute
Item.
The file has additional fields.
The user sees all substitute items for the Company, Location, Item and
can change the Sequence # and other data shown.
Since the user can change the sequence #, I need to process all
records for the group.
When I do the update/add, I need to resequence the data on file based
on the seq# the user keyed.
This is similar to what is done in SEU when you insert or delete
lines.
What I am doing now is storing the screen seq# & substitute item in an
array, sorting the array and then deleting all records for the group.
When I output the records from the subfile, I assign a sequence #
based on the location of the seq#/item in the array.
I was hoping for a less messy method to get the same result.
Thanks,
Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical
Solutions V5R2 IBM Certified Specialist- e(logo) server i5Series
Technical Solutions Designer V5R3 IBM Certified Specialist-
e(logo)server i5Series Technical Solutions Implementer V5R3
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
________________________________________________________________________
____________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
midrange.com
