Ask Question
Help Others
Home › Blogs › Lepa's blog

Auto Increment a Number in PeopleSoft

Mon, 12/10/2007 - 1:43am — Lepa
Your rating: None Average: 2 (1 vote)

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);

Bookmark/Search this post with:
  • Delicious
  • Digg
  • StumbleUpon
  • Reddit
  • Furl
  • Facebook
  • Google
  • Yahoo
  • Technorati
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.
Wed, 03/12/2008 - 9:34am
#1
hari's picture
hari (not verified)
Hi Nice

Hi
Nice

Top
  • reply
Mon, 06/30/2008 - 5:41am
#2
Nitin's picture
Nitin (not verified)
Re: Auto Increment a Number in PeopleSoft

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.

Top
  • reply
Mon, 06/30/2008 - 8:39am
#3
Lepa's picture
Lepa
User offline. Last seen 2 days 12 hours ago. Offline
Joined: 06/23/2008
Posts: 479
Re: Auto Increment a Number in PeopleSoft

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

Top
  • reply
Tue, 01/27/2009 - 3:24am
#4
Mayank's picture
Mayank (not verified)
Re: Auto Increment a Number in PeopleSoft

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.

Top
  • reply

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.
5 + 12 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Unanswered Forum Posts

Title Under Posted on
How to run nvision report through portal PeopleSoft Technical 08/31/2010 - 4:45am
Any1 here who can help? PeopleSoft Technical 08/31/2010 - 2:12am
How to create matrix layout PeopleSoft Technical 08/27/2010 - 2:22am
UnCaught C++ Exception PeopleSoft Technical 08/10/2010 - 9:05am
more