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
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
Comments
GetNextNumber is the preferred way to accomplish that.
peoplesoft,wikidot,com/auto-numbering
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
Checked that and got a lot more things to learn!!
business mobile phone deals