Emplid increment automatically

Your rating: None Average: 3.8 (4 votes)

Hi Friends,

For scenario like i want to increase Emplid value when am click search page automatically.

It is possible in Rowinit Peoplecode.

Sample Code:
If %mode = "A" then /*A Means add mode */
SQLExec("Select max(Emplid) from ps_abc",&a); /* &a is a variable */


Please try to help out with unanswered topics on the forum. Chances are you have had the same issue/question some time in your IT career!


Have a question? Please ask it on the forum instead.
Brett B's picture
Brett B (not verified)
Re: Emplid increment automatically

GetNextNumber is the preferred way to accomplish that.


Lepa's picture
User offline. Last seen 3 years 14 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
Re: Emplid increment automatically

There is one on the blog about that as well. Check it out here http://www.compshack.com/peoplesoft/auto-increment-number-peoplesoft

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

lindagates's picture
User offline. Last seen 9 years 44 weeks ago. Offline
Joined: 03/24/2012
Posts: 1
Re: Emplid increment automatically

Checked that and got a lot more things to learn!!