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?
Using InsertRow Function for copying values from one rowset to another.
Hi All,
I am working with rowsets for my current requirement and trying to insert values from one rowset to another. I have a rowset which gets values one row at a time from a fileLayout,inside a While Loop. And i am trying to insert this Values into another Rowset which must consist of all the values that comes from the file. It might be clear from the example below.
&rsRepDtlsTmp = CreateRecord(Record.RECORD1);
&rs1 = CreateRowset(Record.RECORD1);
While &rsFile <> Null
&rsFile.GetRow(1).RECORD1.CopyFieldsTo(&rsRepDtlsTmp);
&rs1.Insertrow(0);
MessageBox(0, "", 0, 0, &rs1.getrow(1).RECORD1.FIELD1.value);
End-While;
I was trying to fetch values from a file into the work record &rsRepDtlsTmp,row by row and then insert it into another rowset &rs1 and try to get the value through a message box. But this seems to be not working...Any thoughts why??
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 |
Here is your code revised.
&rsRepDtlsTmp = CreateRecord(Record.RECORD1);
&rs1 = CreateRowset(Record.RECORD1);
While &rsFile <> Null
&rsFile.GetRow(1).RECORD1.CopyFieldsTo(&rsRepDtlsTmp);
&rs1.Insertrow(1);
&rsRepDtlsTmp.copyfieldsto(&rs1.GetRow(1).RECORD1);
MessageBox(0, "", 0, 0, &rs1.getrow(1).RECORD1.FIELD1.value);
End-While;
Post new comment