User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.
AutoIncrement of AlphaNumeric Transaction Number
Wed, 07/16/2008 - 9:30am
Suppose Say we have
Transaction Id : QC0001
This Code Will give output as : QC0002
.
.
-----------------------------------------
Local number &qcno;
If %Component = Component.CB_QC_CMP And
%Mode = "A" Then
CB_QC_TBL.CB_QC_NO.Enabled = False;
SQLExec("SELECT MAX(SUBSTR(CB_QC_NO,3,4)) FROM PS_CB_QC_TBL", &qcno);
&qcno = Int(&qcno) + 1;
&DECIMAL = 4 - Len(String(&qcno));
If &DECIMAL < 0 Then
Error ("FIELD LENGTH EXCEEDS REQUIRED LENGTH.");
Else
&myvalue = NumberToString("%04", &qcno);
CB_QC_TBL.CB_QC_NO.Value = "QC" | &myvalue
End-If;
End-If;
--------------
This Code Will give output as : QC0002
.
.
-----------------------------------------
Local number &qcno;
If %Component = Component.CB_QC_CMP And
%Mode = "A" Then
CB_QC_TBL.CB_QC_NO.Enabled = False;
SQLExec("SELECT MAX(SUBSTR(CB_QC_NO,3,4)) FROM PS_CB_QC_TBL", &qcno);
&qcno = Int(&qcno) + 1;
&DECIMAL = 4 - Len(String(&qcno));
If &DECIMAL < 0 Then
Error ("FIELD LENGTH EXCEEDS REQUIRED LENGTH.");
Else
&myvalue = NumberToString("%04", &qcno);
CB_QC_TBL.CB_QC_NO.Value = "QC" | &myvalue
End-If;
End-If;
--------------
Any Suggestions Revert Back to me
Regards,
Venkat
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| how to create application status in peoplesoft campus solutions 8.9 version | PeopleSoft Functional | 05/17/2012 - 4:09am |
| horizantal text in charts | PeopleSoft Technical | 05/10/2012 - 4:57am |
| no current buffer context error | PeopleSoft Technical | 05/10/2012 - 1:19am |
| Integration Broker : Operating Instance/Pub Contracts/Sub Contracts | PeopleSoft Technical | 04/24/2012 - 11:05am |
Thanks for sharing your code with us. You should be able to share your knowledge with us by posting them as "code sample" or "article". Login and then click on create content and in this example you would want to choose "code sample".
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
I have code to auto-increment an alphanumeric field, using SQL calls. It is specific to a 4-character field, but can easily be adapted to different length fields.
If &newvalue = "0000" Then
&bOverrun_Error = True;
End-If;
Hey Larry, thanks for sharing your code with us. I have added your above post to your blog at http://www.compshack.com/blog/larry - Please feel free to share more with us anytime using your own blog. In doing so, your posts will get more exposure in the community and thus provides a much better value :)
Thanks again - cheers!
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