OOFILE Validation Suite - Test 16
Simple test to demonstrate updating related fields
using a similar database to ooftst06 but with direct OID relationships
Generating new test records...

Now finding the Flu sufferers: 
21098   Dent    Andy    0   50000   
20712   DENT    Trissa  0   99999   


Now finding the poorly-paid Flu sufferers: 
21098   Dent    Andy    0   50000   


Dumping Smith and his visits: 
12288   Smith   John    0   20000   

VisitDate   Reason for Visit    

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

changing the first reason to 'Computer-Induced Sanity' 
changing the second reason to 'Funny Views' 
Dumping Smith and changed visits: 
12288   Smith   John    0   20000   

VisitDate   Reason for Visit    

14/10/1994  Computer-Induced Sanity 
1/10/1994   Funny Views 

Dumping Smith and visits with added visit: 
12288   Smith   John    0   20000   

VisitDate   Reason for Visit    

14/10/1994  Computer-Induced Sanity 
1/10/1994   Changed Again   
15/2/1994   Anxiety Attacks 

Now dumping the entire database: 

table:  dbPatients
23552   Taylor  Ken 0   75000   
21098   Dent    Andy    0   50000   
20712   DENT    Trissa  0   99999   
12288   Smith   John    0   20000   



table:  dbVisits
26624   12288   15/2/1994   Anxiety Attacks 
21252   21098   4/10/1994   Flu 
20866   20712   23/11/1994  Flu 
20480   12288   1/10/1994   Changed Again   
16384   12288   14/10/1994  Computer-Induced Sanity 



Description of database schema: 
Connection: ooftst16.db
table: dbPatients contains fields:
field: Last Name     type: fixed-length chars
    index: indexed, allowing dups & ignoring case
    and a maximum length of : 40
field: Other names   type: fixed-length chars
    index: indexed, allowing dups & ignoring case
    and a maximum length of : 80
field: dbVisits is a 1:N relationship  and propagating deletes to related records
field: Salary    type: long integer
    index: indexed, allowing dups & ignoring case

table: dbVisits contains fields:
field: dbPatients is a N:1 relationship 
field: VisitDate     type: date
    index: indexed, allowing dups & ignoring case
field: Reason for Visit  type: fixed-length chars
    index: indexed, ignoring case, compress front & padding
    and a maximum length of : 200


done