🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #290

Re: Referential Integrity?

#290
From: Gary Gary White
Date: Wed, 23 Dec 1998 00:00
26 lines
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-mail
References: <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