Re: Reseuqence data in file based on screen seq

In other words, the sequence number on the screen is really not the sequence number in the record - it is just coincidental that they are normally identical?

In similar situations I have generally not bothered with compares, etc. At update time, just delete all existing records in the displayed group and rewrite them.

Jeff Young wrote:

This is an example of what I need to do:
For a given Company/Location/Item:

Data File: Seq# Substitute Item
10 Sub 1
20 Sub 2

Screen: (as displayed on initial load)
Seq# Substitute Item
10 Sub 1
20 Sub 2

Screen (as seen after user changes)
Seq# Substitute Item
10 Sub 1
05 Sub 2

Data File (final result after processing user changes)
Seq# Substitute Item
10 Sub 2
20 Sub 1


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: Booth Martin <booth@xxxxxxxxxxxx>
To: RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
Sent: Thursday, December 6, 2007 2:04:44 PM
Subject: Re: Reseuqence data in file based on screen seq

I am not sure what you mean by "resequence data."
As the sequence number is part of the key, the process will apparently just happen as you process the subfile and add/update records. You will want to keep the original key fields as hidden fields in the subfile. That way you can compare original key fields to the viewable key fields and see if you are adding. updating, or deleting data records.

If you really need the data to be reorganized, you could reorganize at the end of the process?

Jeff Young wrote:

Does anyone have a simple method to resequence data in a file based on the new sequence # on a screen?
I am limited to V5R1 with any concepts used.

The file has a sequence # as part of the primary key.
The user will see a subfile of all records in the file with the sequence # available to be changed.
In addition, they can add records and specify any sequence # they choose.
Add, Change and Delete are all done in one pass.

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


____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs