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.
Inserting records
Wed, 07/28/2010 - 11:03am
Hello,
I am new to Peoplesoft development. I have created an app package with properties that mimic that of a record. I create this object and load it into an array. (have some further processing to do later on once the array is filled) To fill the effected table I have a dynamic SQL statement built and executed via SQLExec().
I have also noticed that a person could create a record object, fill it and do a .insert to populate a record that way as well. Any speed or additional benefits I am not aware of here in doing the insert via the record object method?
Hope that makes sense.
Thanks.
Bookmark/Search this post with
Unanswered Forum Posts
| 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 |
When you are using the SQLExec
1. you need to take care of the key structures.
2. Commit statement you need to exe. Let say 2 rows inserted and commited and 3 rd one got error. How about reverting the inserted rows.
When you are using peoplesoft function that will inturn take care of all those stated above.
Regards,
Hari.A
Post new comment