Article View: borland.public.vdbase.data.sql
Article #290Re: Referential Integrity?
From: Gary Gary White
Date: Wed, 23 Dec 1998 00:00
Date: Wed, 23 Dec 1998 00:00
26 lines
1504 bytes
1504 bytes
On Wed, 23 Dec 1998 12:24:25 -0500, JonTrimble wrote: > I have two tables that I would like to update in a form. > They both have a common index. I have set up Referential > Integrity rules in the Database Administrator as indicated > in the Developer's Guide. They are set up in a one > (obviously parent) to many (child) relationship with > restricted update and cascading delete. They have a rule > Name. I can find nowhere in the guide that says how to use > this facility. Only Create, Modify and Remove it. Is there > a way to utilize it? Defining RI rules does nothing to create a relationship. You still need to do this with the masterRowset, masterFields, and indexName properties of the data objects. What RI does is throw an error and disallow edits/appends/deletes which would violate the defined rules. See Ken's MiscCode.how and BegData.how at: http://www.mindspring.com/~hirschv/dbase/dbase.htm Gary Some dBASE Stuff at http://www.AppTools.com/dbase
Technical Details
Message-ID:
<36813e48.74435562@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<36812748.CDD8E86C@juno.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,ce37f79e7d2468bf X-Google-Attributes: gidff5a1,public From: Gary (Gary White) Subject: Re: Referential Integrity? Date: 1998/12/23 Message-ID: <36813e48.74435562@forums.borland.com> X-Deja-AN: 425253325 Content-Transfer-Encoding: 7bit References: <36812748.CDD8E86C@juno.com> Content-Type: text/plain; charset=us-ascii Organization: Just Me Mime-Version: 1.0 Reply-To: Gary Newsgroups: borland.public.vdbase.data.sql