Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Some RI ideas
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01216870
Message ID:
01216899
Vues:
19
>>>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.
>
>Since your advice is the exact opposite of Ed's I'll try a mixture of both. <g>
>
>Thanks a lot.

:o)))))
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform