OOFILE Validation Suite - Test 20
Demonstration of ad-hoc query building
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
Last Name   Other Names 

Smith   John    
Dent    Trissa  
Dent    Andy    
Taylor  Ken 
OR Querying either Last or Othernames = 
   Dent
   Andy

Listing result of query
Last Name   Other Names 

Dent    Trissa  
Dent    Andy    

AND Querying either Last or Othernames = 
   Dent
   Andy

Listing result of query
Last Name   Other Names 

Dent    Andy    

Querying Lastname = any of
   Dent
   Tay*

Listing result of query
Last Name   Other Names 

Dent    Trissa  
Dent    Andy    
Taylor  Ken 

Test Completed