Larry, About the stored procedures, I keep my source files in a separate directory and have code to reload them whenever I wish. This has worked fine for me.
I agree with your observations about the view definition order. I have wished for a fix for this for years also. Dennis McGrath -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Lawrence Lustig Sent: Thursday, January 24, 2008 1:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: UNLOAD Command in R:BASE (was Re: How do I get ridof a DBFTable??) The biggest enhancement(s) I would like to see in UNLOAD: 1. Transitive closure for PK/FK dependencies when unloading table structures. I believe it's currently possible for a table with an FK into another table to be unloaded _before_ the table with the corresponding PK. Trying to load this structure will fail. R:Base ought to ensure that the order of tables is reloadable. 2. Transitive closure for view dependencies when unloading views. I believe it's currently possible for view B that depends on view A to be unloaded before view A is unloaded. This can happen if you define A, then B, then drop A and redefine it. Obviously, the resulting file will fail to create view B when it is run. 3. Currently, stored procedures are not unloaded in any way. I'd like to see the SYS_PROCEDURES and the other table for procedures (the name escapes me at the moment) unloaded as well. -- Larry
