Auto Increment a Number in PeopleSoft

Ask Question

Help Others

Mon, 12/10/2007 - 1:43am — Lepa

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:

Lepa's blog

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

hari (not verified)

Hi Nice

Hi
Nice

Mon, 06/30/2008 - 5:41am

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.

Mon, 06/30/2008 - 8:39am

Lepa

Offline

Joined: 06/23/2008

Posts: 457

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

Tue, 01/27/2009 - 3:24am

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.

Post new comment

Your name: *

E-mail: *

The content of this field is kept private and will not be shown publicly.

Homepage:

Subject:

Comment: *

Input format

Filtered HTML

Allowed HTML tags: <div> <pre> <br> <code> <a> <em> <blockquote> <strong> <ul> <ol> <li> <dl> <dt> <b> <p> <h1> <h2> <u> <img>
Web page addresses and e-mail addresses turn into links automatically.
Lines and paragraphs break automatically.
You can enable syntax highlighting of source code with the following tags: <code>.

BBcode

You can use BBCode tags in the text.
Lines and paragraphs break automatically.
Web page addresses and e-mail addresses turn into links automatically.

More information about formatting options

Notify me when new comments are posted

CAPTCHA

The question below is to prevent automated spam submissions.

Math question: * 6 + 6 =

Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.

Unanswered Forum Posts

Title	Under	Posted on
Abs Mgmt: How can Abs rule pro-rate contractor's last month's entitlement (need help urgently)	PeopleSoft Functional	03/10/2010 - 9:21pm
Can we user LONG datatype as a search option in PeopleSoft	PeopleSoft Technical	03/10/2010 - 11:22am
special caracters are not translated correctly when ftp from windows to unix	Programming	03/09/2010 - 3:23pm
How to view the employees from particular country in peoplesoft?	PeopleSoft Technical	03/03/2010 - 1:56am

Main Menu

User login

Quick links

Sponsored links

Recent blog posts

Who's new