🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Referential Integrity?

#288
From: JonTrimble
Date: Wed, 23 Dec 1998 00:00
23 lines
1700 bytes
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?  I want to add 1 record to the master
and then many records to the child.  As I understand it
there should be a way to do this and dBASE will even
maintain the pointers without me having to program it.  You
could do this quite easily in 5.5(5.6) using a QBE.
However, with the advancement to SQL the ability seems to
have been lost.  Am I nuts or is this not the most basic
capability of a relational database?  How to do it is well
hidden.  Is there a good reference, such as "Teach Yourself
Visual dBASE 5.5 Programming in 21 Days" available?  I just
want to write a few programs in VDB not be a "VDB Systems
Programmer" expert.  Any help will be appreciated.

Jon Trimble
jontrimble@juno.com
Technical Details
Message-ID: <36812748.CDD8E86C@juno.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,ce37f79e7d2468bf,start
X-Google-Attributes: gidff5a1,public
From: JonTrimble <jontrimble@juno.com>
Subject: Referential Integrity?
Date: 1998/12/23
Message-ID: <36812748.CDD8E86C@juno.com>
X-Deja-AN: 425227860
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
X-Corel-MessageType: EMail
Organization: Another Netscape Collabra Server User
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql