Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some RI ideas
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01216870
Message ID:
01216885
Views:
13
This message has been marked as a message which has helped to the initial question of the thread.
>Hi everybody,
>
>I'm thinking, should I use the built-in RI Builder for a simple application or should I try to enforce RI rules from the interface?
>
>I have the following tables in a database:
>
>Tickets, Problems, Resolutions, ProblemResolution, Software, Hardware, Other.
>
>Tickets may have pointers to all of these tables. I allow to Delete Problems and Resolutions in the interface, I also allow to make inactive Software/Hardware/Other.
>
>What would be the best course of action for me to proceed in enforcing some integrity rules?
>
>What do you suggest?
>
>Thanks a lot in advance.

For a simple application I would use built-in RI builder. But If I want to have more control over the triggers I would use my functions to do that.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform