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

1 reply [Last post]
Guest's picture
Guest

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.

Hari_aindian's picture
User offline. Last seen 5 years 18 weeks ago. Offline
Joined: 08/02/2010
Posts: 84
Re: Inserting records

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