Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Foxpro's referential integrity
Message
 
 
To
05/12/2000 12:35:11
Walter Meester
HoogkarspelNetherlands
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00449269
Message ID:
00449495
Views:
19
Walter,
What I meant by that is that VFP does not have automatic functionality built in to handle RI (e.g. Cascasde deletes, etc.) the way Access has or SQL Server 2000 has.

You actually have to add some code somewhere. Whether you do it with a builder that generates SP code individually for each table or you use the same RI SP code over and over that can be inserted at database creation time that reads an RI table doesn't much matter in the grand scheme of things.

>Larry,
>
>>No, I don't open the database and hand code the rules. I use the RI Builder from Effective Techniques.
>
>O.K. That explains. But your answer to the original question:
>
>>I do agree that RI should be coded manually (as that is the only way it can be done if VFP currently). However, I would not do it in PRG code, I would use stored procedures and triggers; hence, use a database.
>
>seems a bit misleading. Can we conclude that it is preferred to use some sort of RI builder that generates constraints in the database itself rather than program the RI in the application (which was in fact the question) ???
>
>Walter,
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform