Tuesday, May 22, 2007 Tip of the Day: Changing CASCADE Options
Supported Versions: . R:BASE 7.6 (7.6.1.30601 or higher ...) . R:BASE C/S:I 7.6 for Windows (Build: 7.6.1.30601 or higher) . R:BASE V-8 Turbo (8.0.15.30601 or higher ...) Using the prior versions/updates of R:BASE, if you have already added the CASCADE option to a table with Primary Key (PK) that automatically executes UPDATE and DELETE options, and if you wish to change the default option to UPDATE only, use the following command at the R> prompt: ALTER TABLE <PKtablename> ADD CASCADE UPDATE This will change the CASCADE option to UPDATE only. If you wish to change the default option to DELETE only, use the following command at the R> prompt: ALTER TABLE <PKtablename> ADD CASCADE DELETE If you wish to change the default option to both, use the following command at the R> prompt: ALTER TABLE <PKtablename> ADD CASCADE And finally, if you wish to cancel the CASCADE option altogether, use the following command at the R> prompt: ALTER TABLE <PKtablename> DROP CASCADE You may also implement these options using the enhanced Data Designer (RBDEFine) of R:BASE as illustrated in the PDF document posted on 05/21/2007. From The Edge: http://www.razzak.com/fte/ Very Best R:egards, Razzak.
