Who's On?

	Membership:
	Latest: Kezia West
	Past 24 Hours: 1
	Prev. 24 Hours: 0
	Overall: 5246

	People Online:
	Visitors: 464
	Members: 0
	Total: 464

Name	Points
Greg Moeller	4184
David Williams	3349
JonA	3291
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1375
Roger French	1315
mark.cook	1244

Sort File for Online Update Form?

7 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

Woozy

Veteran Member Send Private Message

Posts: 709

2/5/2014 8:30 PM

We have a customized online update form (copy of BS31 - Web Pending Benefit Enrollments), and the business would like to have this custom form sorted by StartDate/PlanType/PlanCode rather than PlanType/PlanCode/StartDate. The source table is BNBEN which does not have an index the matches their request. Is it possible and reasonable to use a sort file to re-sequence the data for an online update form like this? I'm thinking "no", but thought I'd ask the question. Does anyone have a better suggestion? Thanks! Kelly

jaherb

Veteran Member Send Private Message

Posts: 164

2/5/2014 10:01 PM

Kelly.... typically with on-line forms, it is the index that drives the sort order of the data on the screen. I had a project like this once and we had to add a new index to get the sequence we needed.

John Henley

Posts: 3351

2/5/2014 10:29 PM

The other option in addition to creating a custom index and using that rather than BNBSET1 would be to use an ISAM work file. While more code-intensive, since it is localized to your custom version of BS32, it does remove a database table customization dependency that needs to be maintained from version to version.

Woozy

Veteran Member Send Private Message

Posts: 709

2/6/2014 2:28 PM

Thanks Jim and John. I like the idea of a custom index a little better, even though we have to manage it during patching/upgrades. We have a number of other mods we already have to check and retrofit, so I think we can add this to the list of post-patch checks. I'm sure a sort file would work but it would be quite a significant rewrite for a fairly low-value mod (in the greater scheme of things). I appreciate the feedback! Kelly

jaherb

Veteran Member Send Private Message

Posts: 164

2/6/2014 4:50 PM

Kelly.... If you go with a new Index, be sure to start with a high number to avoid possible issues with future Lawson releases..... such as BNBEN99

Woozy

Veteran Member Send Private Message

Posts: 709

2/6/2014 5:10 PM

Thanks Jim. That's what I was planning. I remember reading that recommendation somewhere...

John Henley

Posts: 3351

2/6/2014 6:06 PM

Posted By jaherb on 02/06/2014 11:50 AM Kelly.... If you go with a new Index, be sure to start with a high number to avoid possible issues with future Lawson releases..... such as BNBEN99

Actually it would be BNBSET99. There is actually some environment code that requires the xxxSETyy naming convention. I had a client that used IDX instead of SET and had to change it when they upgraded from v8 to v9 !!

jaherb

Veteran Member Send Private Message

Posts: 164

2/6/2014 6:07 PM

Super