OOFILE Validation Suite - Test 9
Simple test to demonstrate deleting records
using the database from ooftst02
Entire database before deletions

table:  Patients
24576   Taylor  Ken 5   5   75000   
22122   Dent    Andy    4   4   50000   
21736   DENT    Trissa  3   3   99999   
12288   Smith   John    2   2   20000   



table:  Visits
22276   4   4   4/10/1994   Flu 
21890   3   3   23/11/1994  Flu 
21504   2   2   1/10/1994   Sore Knee   
17408   2   2   14/10/1994  Measles 




Dumping Smith and his visits: 
12288   Smith   John    2   2   20000   

VisitDate   Reason for Visit    

14/10/1994  Measles 
1/10/1994   Sore Knee   

Deleting Smith
Entire database without Smith

table:  Patients
24576   Taylor  Ken 5   5   75000   
22122   Dent    Andy    4   4   50000   
21736   DENT    Trissa  3   3   99999   



table:  Visits
22276   4   4   4/10/1994   Flu 
21890   3   3   23/11/1994  Flu 




Deleting all remaining records
Entire database  - should be empty

table:  Patients



table:  Visits





Testing record position after deletes, with all recs & no sort order
Deleting individual record - Dent, Andy

Should be on next record after delete, which is now first record in file - DENT, Trissa

Goto last record in file - Taylor, Ken

Should be on first record after deleting last - DENT, Trissa

Patients  - should be 2 recs
22122   DENT    Trissa  7   7   99999   
21736   Smith   John    6   6   20000   


Test again, with all recs & sort by othername

Deleting individual record - Dent, Andy

Should be on next record after delete, which is now first record in file - Smith, John

Goto last record in file - DENT, Trissa

Should be on first record after deleting last - Smith, John

Patients  - should be 2 recs
21736   Smith   John    10  10  20000   
24576   Taylor  Ken 13  13  75000   


Test again, with all recs & non-indexed sort by reverse othername

Deleting individual record - DENT, Trissa

Should be on next record after delete, which is now first record in file - Taylor, Ken

Goto last record in file - Dent, Andy

Should be on first record after deleting last - Taylor, Ken

Patients  - should be 2 recs
12288   Taylor  Ken 17  17  75000   
24576   Smith   John    14  14  20000   


done