Article View: borland.public.vdbase.data.sql
Article #288Referential Integrity?
From: JonTrimble
Date: Wed, 23 Dec 1998 00:00
Date: Wed, 23 Dec 1998 00:00
23 lines
1700 bytes
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-mailShow 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