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 |
|---|---|---|
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
| PSFT Authentication token failed for Node PSFT_HR | PeopleSoft Technical | 01/03/2012 - 12:21am |
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
Post new comment