Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referential Integrity
Message
From
11/11/1996 14:54:08
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00011939
Message ID:
00011990
Views:
26
>1) Should I create local views of the data required for each of the forms?
>2) Referential integrity...I have one parent table and 8 associated child tables with indexes set to the SSAN. Now I want to add the SSAN to each of these child tables (with 1 to 1 relationships. Must I have all these tables open when I add new personnel, create views with all these SSAN's, or will the information update to the child tables automatically?
>3) Are there any white papers concerning RI and a better explanation on
>its use?
>
>4) How do I go about installing the database and tables on our server and have the installation routine of my program be smart enough to know the database is elsewhere with the ability to search our server and write the "databasepath" to either my program ini file or main header file?
>And 5) Ultimately, what is the most LOGICAL way to accomplish this task??

I will try to answer most of your questions:
1. It's up to you to decide what is better suited to your needs: local views or whole tables opened with USE (basically it depends how speed you LAN is).
2-3. RI Builder will care about all standard referential staff, including opening and closing tables. If you are happy with standard triggers you shouldn't edit stored procedures manually.
4-5. Create configuration setting in your application which will check database file on stored path and prompt user to locate file if file doesn't exist. You can create application object with specific method to reset database path any time you go to Form.DataEnvironment.Init.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform