Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Some RI ideas
Message
 
 
To
17/04/2007 13:25:35
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:
01216894
Views:
13
>>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.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform