Hmm, I was afraid this would be complicated. If I were 20 years younger, I
might tackle Java. But even a block diagram would be useful to understand the
pieces and relationships. I have an application that has a service request
module in it, and I have always thought it would be cool to have
Thx Razzak for the info. I will give a go!
Thx again
Dan
-Original Message-
From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of
A. Razzak Memon
Sent: Tuesday, January 9, 2018 2:49 PM
To: rbase-l@googlegroups.com
Subject: Re: [RBASE-L] - delete from child tables
And, here is an example of implementing CASCADE option for table(s)
with PRIMARY Keys.
See attached screen shot for your viewing pleasure ...
Cascade - Maintains primary/foreign key relationships automatically.
A CASCADE can be
applied to UPDATE, DELETE, or BOTH data set changes for primary ke
Dan,
Your situation is a perfect scenario for the implementation of
"CASCADE" option for all tables with PRIMARY Key.
Know how?
If not, just ask.
HELP CASCADE
Table Designer ...
Very Best R:egards,
Razzak
At 05:35 PM 1/9/2018, Dan Goldberg wrote:
I need to run a command to delete rows f
I need to run a command to delete rows from the master table and also need to
remove the rows from the child tables. Is there a single command to do this?
The tables are primary/foreign keyed.
TIA
Dan Goldberg
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.
5 matches
Mail list logo