Validation of the records should be like current value of D field should be equal to the previous
value of E of that particular set of the child records.
If B field in the parent record is 2 and C is 7 then 14 child records (7 sets containing 2 records each)
for that parent record will be present.
For example:
Parent record : B = 2
C = 7
then the data for the child record will be in the order A,B,C,D,E respectively.
Parent 3 7 NULL NULL
Child NULL NULL 7 15-----------1st set
Child NULL NULL 15 23-----------1st set
Child NULL NULL 7 15-----------2nd set
Child NULL NULL 15 23-----------2nd set
Child NULL NULL 07 15-----------3rd set
Child NULL NULL 23 07-----------3rd set-----Error
Child NULL NULL 15 07-----------4th set-----Error
.....
.....
.....
I would appreciate any help regarding this...
Processing set of records
Moderators: chulett, rschirm, roy
Processing set of records
Kruthika
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Can you please provide more meaningful explanation of your requirement along with few sample data sets - some which are correct and some which are incorrect.
This way, we will have an idea of what you intend to achieve.
Also any information of how this fits in your overall flow will be worth discussing as there may be alternate but easier & efficient methods to achieve the same.
This way, we will have an idea of what you intend to achieve.
Also any information of how this fits in your overall flow will be worth discussing as there may be alternate but easier & efficient methods to achieve the same.