OOFILE Validation Suite - Test 12 Simple test to build compound indexes and demonstrate sorting and searching by them and their components Listing records by combined names 12600 Dent Andrew MIS Boss 40000 DentAndrew Dent40000 MISBoss1982 1982 12444 Dent Andy Acc XXX 25000 DentAndy Dent25000 AccXXX1992 1992 12288 DENT Trissa Acc Rec 5000 DENTTrissa DENT5000 AccRec1985 1985 12756 Denton Andrew Pur XXX 39000 DentonAndrew Denton39000 PurXXX1994 1994 7168 Smith John Acc XXX 0 SmithJohn Smith0 AccXXX1970 1970 12912 Taylor Ken MIS Cntr 75000 TaylorKen Taylor75000 MISCntr1994 1994 Listing records by Name and reverse Salary 12600 Dent Andrew MIS Boss 40000 DentAndrew Dent40000 MISBoss1982 1982 12444 Dent Andy Acc XXX 25000 DentAndy Dent25000 AccXXX1992 1992 12288 DENT Trissa Acc Rec 5000 DENTTrissa DENT5000 AccRec1985 1985 12756 Denton Andrew Pur XXX 39000 DentonAndrew Denton39000 PurXXX1994 1994 7168 Smith John Acc XXX 0 SmithJohn Smith0 AccXXX1970 1970 12912 Taylor Ken MIS Cntr 75000 TaylorKen Taylor75000 MISCntr1994 1994 Listing records in OtherNames order 12600 Dent Andrew MIS Boss 40000 DentAndrew Dent40000 MISBoss1982 1982 12756 Denton Andrew Pur XXX 39000 DentonAndrew Denton39000 PurXXX1994 1994 12444 Dent Andy Acc XXX 25000 DentAndy Dent25000 AccXXX1992 1992 7168 Smith John Acc XXX 0 SmithJohn Smith0 AccXXX1970 1970 12912 Taylor Ken MIS Cntr 75000 TaylorKen Taylor75000 MISCntr1994 1994 12288 DENT Trissa Acc Rec 5000 DENTTrissa DENT5000 AccRec1985 1985 Listing Andy Dent by compound key search of LastName & Salary: 12444 Dent Andy Acc XXX 25000 DentAndy Dent25000 AccXXX1992 1992 Listing Andrew Dent by compound key search on both names: 12600 Dent Andrew MIS Boss 40000 DentAndrew Dent40000 MISBoss1982 1982 Listing Andy Dent & Denton: 12756 Denton Andrew Pur XXX 39000 DentonAndrew Denton39000 PurXXX1994 1994 12600 Dent Andrew MIS Boss 40000 DentAndrew Dent40000 MISBoss1982 1982 12444 Dent Andy Acc XXX 25000 DentAndy Dent25000 AccXXX1992 1992 Test Getting copy from read-only compound field JobCode is: PurXXX1994 Repeat above read-only compound field test on cloned selection JobCode is: PurXXX1994 Test Completed