Hi,
I want to create a duplicate rowset for a new key set based on a existing key set in a 3 level rowset..
Eg;
Level0 Record:
Key1: A1
Field1:Abc
Level1 Record:
Key1:A1
Key2:A2
Field2:Abcd
Level2 Record:
Key1:A1
Key2:A2
Key3:A3
Field3:Abcde
Level3 Record:
Key1:A1
Key2:A2
Key3:A3
Key4:A4
Field3:Abcdef
So i want to create duplicate rowset for another level0 key B1 such that the rest of the fieldvalues in the level rowset is the same as the existing one. Like
Level0 Record:
Key1: B1
Field1:Abc
Level1 Record:
Key1:B1
Key2:A2
Field2:Abcd
Level2 Record:
Key1:B1
Key2:A2
Key3:A3
Field3:Abcde
Level3 Record:
Key1:B1
Key2:A2
Key3:A3
Key4:A4
Field3:Abcdef
Its just like a copy feauture for a new keyset.
Im getting few sql errors with my peoplecode. Can anyone share ur thoughts??
Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
anyone can share there application in sql
Vistec Marketing