RE: [RBASE-L] - [Business Web Applications using Java]

2018-01-09 Thread Steve Johnson
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

RE: [RBASE-L] - delete from child tables

2018-01-09 Thread Dan Goldberg
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

Re: [RBASE-L] - delete from child tables

2018-01-09 Thread A. Razzak Memon
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

Re: [RBASE-L] - delete from child tables

2018-01-09 Thread A. Razzak Memon
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

[RBASE-L] - delete from child tables

2018-01-09 Thread Dan Goldberg
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.