Processing set of records
Posted: Thu Apr 21, 2005 5:47 am
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...
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...