Use the GetNextNumber function to increment the value in a record for the field you specify by one.
Syntax:
GetNextNumber ({record.field | record_name, field_name}, max_number)
Best place to add such code is in SavePostChange event.
Example:
My_Field = GetNextNumber(My_Record.My_Field, 99999999);
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| 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 |
Comments
Hi
Nice
There ia another function GetNextNumberWithCommits.
This created a new connection .. fetch the number,.. updated with new and commits.
One of them is having an Issue on OS390.
Nitin, your talking about GetNextNumberWithGapsCommit, right? I think you just forgot the word "Gaps". But yes I agree with you, GetNextNumberWithGapsCommit has more flexibility and provides better performance. Thanks for your tip!
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
Nitin / Lepa i do agree with both of you..and want to update 1 more thing which is --
The GetNextNumberWithGaps function is very restrictive in its usage. The GetNextNumberWithGapsCommit function can be used in any event.
do you place the code on the record or on the page?
I would put that code on the component level if you code under savepostchange event.
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