Who's On?

	Membership:
	Latest: Zac Shields
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5210

	People Online:
	Visitors: 131
	Members: 0
	Total: 131

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

Custom code to find a previous record

2 Replies

2 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

Chesca

Veteran Member

Posts: 490

11/4/2014 4:26 PM

Hello, I am looking in the docs for Developers API only found for online programs. Is there a Lawson batch program you can point me to so I can see sample code to find a previous record. I am trying to find a record in HRHISTORY and then get the previous record. Thanks in advance for your time.

jaherb

Veteran Member

Posts: 164

11/4/2014 5:06 PM

You can use 870-FIND-PREV-index. But this has to be used in conjunction with the 850-FIND-NLT-index

This is described in the API manual.

Woozy

Veteran Member

Posts: 709

11/4/2014 8:50 PM

Hi bernfc10 - Just to expand on Jim's response, the code for navigating records is identical for online forms and batch programs, and it works the same way for every table. The only trick is that you must know the correct index to use to get the records returned in the sequence you expect. There are five different delivered indexes on the HRHISTORY table for you to choose from.

Good Luck!