OOFILE Validation Suite - Test 1
Simple test to store some data and retrieve it
in a single-table database, with no relations

Just opened...

table:  People
2380    Smith   John    0   John is a plain sort of bloke, not the kind to stand-out in a crowd
and in fact you'd probably say he's the classic Mr Average. However he harbours secret dreams of being a brain surgeon and a bloke 'wot goes down the sewers in big rubber boots'
    12/3/1997   
2520    Dent    Trissa  5000    Trissa is married to Andy and mother of Tanith and Ryan 2/4/1997    
2660    Dent    Andy    25000   Andy has a Don Quixote complex but his Sancho Panza stops him tilting at too many software windmills    26/3/1997   
2800    Taylor  Ken 75000       2/4/1997    





Listing records
2380    Taylor  Ken 75000       3/4/1997    
2520    Dent    Andy    25000   Andy has a Don Quixote complex but his Sancho Panza stops him tilting at too many software windmills    27/3/1997   
2660    Dent    Trissa  5000    Trissa is married to Andy and mother of Tanith and Ryan 3/4/1997    
2800    Smith   John    0   John is a plain sort of bloke, not the kind to stand-out in a crowd
and in fact you'd probably say he's the classic Mr Average. However he harbours secret dreams of being a brain surgeon and a bloke 'wot goes down the sewers in big rubber boots'
    13/3/1997   
Listing records in OtherNames order
Last Name   Other Names 

Dent    Andy    
Smith   John    
Taylor  Ken 
Dent    Trissa  

Now retrieving by index
Retrieving Taylor: Taylor
Retrieving Smith by Salary: Smith

Listing two Dent records: 
Last Name   Other Names 

Dent    Andy    
Dent    Trissa  


now producing a subset of Taylor & Dent
Last Name   Other Names 

Dent    Andy    
Dent    Trissa  
Taylor  Ken 

Just cloned a selection of 3 records

now reducing original via Intersection to Dent
2520    Dent    Andy    25000   Andy has a Don Quixote complex but his Sancho Panza stops him tilting at too many software windmills    27/3/1997   
2660    Dent    Trissa  5000    Trissa is married to Andy and mother of Tanith and Ryan 3/4/1997    

now Inverting to Smith & Taylor
Last Name   Other Names 

Taylor  Ken 
Smith   John    

Show the cloned selection is still Dent & Taylor
Last Name   Other Names 

Dent    Andy    
Dent    Trissa  
Taylor  Ken 


now reducing via Difference to Dent
Last Name   Other Names 

Dent    Andy    
Dent    Trissa  

Retrieving Taylor by relative record number: Taylor

Retrieving previous record Smith: Smith

Now finding people who've been paid in the last 2 weeks 
Last Name   Other Names Last Paid   

Dent    Andy    27/3/1997   
Taylor  Ken 3/4/1997    
Dent    Trissa  3/4/1997    

Matching Salaries of : 75000 for Taylor, Taylor

Test Completed