Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automatic update of related dbf FoxPro 2.5
Message
From
23/10/1996 12:11:32
 
 
To
23/10/1996 11:06:12
Bill Brown
Alpena General Hospital
Alpena, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00010777
Message ID:
00010788
Views:
27
>I am trying to set up a date base and relate it to a field in another database, ie: a date field. The First database is an inventory of equipment with a last serviced date field. I want to create another dbf that will have the same equipment Id# and several date fields that will update every time I update the date field in the first database, thus giving me a running record of service with out cluttering up the main database or having to do entries on each database seperatly.
>
>Thankyou to any one who has a solution to this!

Actually each time first table' field gets updated your application must fire some procedure which will scan second table using equipment id and reset values in date fields (using your algorithm). Hopefully 2.5 supports UPDATE command which will solely do this job. If you something behind the scene move to VFP with referential integrity triggers.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform