Emplid increment automatically

No votes yet

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 5 weeks 2 days ago. Offline
Joined: 06/23/2008
Posts: 565
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

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.