 Rewferential Integrity question
|
|
not2worry
(Inactive)
Yorba linda, CA
|
|
I'm wondering if I need to use Referential Integrity (RI) on my new database. It contains about eight tables linked together in a form via the data model tool. It is on a network and has multiple users. There are several 1:M and 1:1 relationships set up on the data model.
The question is, if I don't allow users to access tables directly (using runtime) and they always use this form with the relationships all set up, is there some reason I should also setup RI?
My main reason for not wanting to use RI is that I have heard thet it may more easily cause table corruption.
Thank you,
Bruce
|
|
Posted 24 years ago (Thread Starter)
|
|
| About not2worry |
|
Inactive member.
Member does not subscribe to this thread.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #8245, 4 replies
Thread Started 11/11/2002 7:55:00 AM
View Counter=1817
Last Reply Posted 11/14/2002 6:47:00 AM)
|
|
|
|
Location=Yorba linda, CA
|
|
 |
|
|
|
Rick Carter
|
|
I've heard from Paradox developers on both sides of this issue.
You may be interested in an article by Liz Wodehouse on how she duplicated the functionality of RI using code, at http://www.thedbcommunity.com/ Rick Carter
Chair, Delphi/Paradox SIG
Cincinnati PC Users Group
|
|
Posted 24 years ago
|
|
| About Rick Carter |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #8271 (Level 1.1)
Reply to 8245
Thread Started 11/12/2002 8:44:00 AM
View Counter=2
|
|
|
|
Location=Cincinnati OH USA
|
|
|
Most Recent Post
|
|
|
Rick Carter
|
| That's Liz Woodhouse.
Soon to be Liz McGuire.  |
|
Well, congratulations and best wishes, Tony! And my apologies to The Goddess for maligning her Name. Rick Carter
Chair, Delphi/Paradox SIG
Cincinnati PC Users Group
|
|
Posted 24 years ago
|
|
| About Rick Carter |
|
Approved member.
Member subscribes to this thread with a verified email.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #8301 (Level 1.2)
Reply to 8245
Reply Posted 11/14/2002 6:47:00 AM
|
|
|
|
Location=Cincinnati OH USA
|
|
|
|
|
not2worry
(Inactive)
Yorba linda, CA
|
|
Thanks a lot for your help! I've got the article now and I think it will help a lot.
-Bruce
|
|
Posted 24 years ago (Thread Starter)
|
|
| About not2worry |
|
Inactive member.
Member does not subscribe to this thread.
|
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
|
|
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html,
social networking links, message board signature, company profile, etc.
|
Post ID #8279 (Level 1.3)
Reply to 8245
Reply Posted 11/12/2002 4:04:00 PM
|
|
|
|
Location=Yorba linda, CA
|
|
|
|
|
|
Tony M
|
That's Liz Woodhouse. Soon to be Liz McGuire. And specifically, http://www.thedbcommunity.com/interact/refint.htm and http://www.thedbcommunity.com/code/refintcode.htm Might be a little better to post specific links for the 'Link Police' than a generic site link. |
|
Posted 24 years ago
|
|
| About Tony M |
|
Inactive member.
Member does not subscribe to this thread.
Post ID #8273 (Level 1.4)
Reply to 8245
Reply Posted 11/12/2002 9:11:00 AM
|
|
|
|
Location=
|
|
Revive Thread!
Add a comment to revive this old thread and make this archived thread more useful.
| Thread #8245 Counter |
| 1817 |
|
Since 4/2/2008
|
|
|
Paradox
Print This
