Emplid increment automatically

Your rating: None Average: 5 (2 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 */
&a=&a+1;
PS_ABC.Emplid.value=&a;
gray(PS_ABC.Emplid);
end-if;

Regards,
Mahendra

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!

Comments

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.

peoplesoft,wikidot,com/auto-numbering

Lepa's picture
User offline. Last seen 3 days 16 hours ago. Offline
Joined: 06/23/2008
Posts: 590
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 5 years 17 weeks ago. Offline
Joined: 03/24/2012
Posts: 1
Re: Emplid increment automatically

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

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
3 + 3 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.