Mike, It is not helping you right now, but you could consider to create views using a command file or even a stored procedure. Put all your defined (temp) views in a program, run it whenever you like, don't forget to drop views at the beginning of the program.
In this way you are perfectly in control of your views, even when a view contains a variable in the where clause. In this case you have to surround the variable with parentheses, otherwise the variable's content of that particular moment will be replaced in the view. Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: woensdag 13 maart 2013 19:09 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Problems with unload ALL Mike, *SELECT sys_table_name from sys_views t**1, sys_tables t2**where t1.sys_table_id = t2.sys_table_id and t1.sys_query contains 'BP1'* This will return a list of all the views with BP1 in them.Now do this 1. OUTPUT AllViews.str 2. UNLOAD STRUCTURE FOR View1 3. UNLOAD STRUCTURE FOR View2 ... 4. OUTPUT SCREEN 5. DROP VIEW View1 6. DROP VIEW View2 ... 7. OUTPUT db.all 8. UNLOAD ALL 9. OUTPUT SCREEN 10. RUN db.all 11. RUN allviews.str You really should, when you recreate the views, use defined column names and change your commands to the new names when selecting from the views. This is a much better solution in the long run, but probably a lot of work in the short run. Albert *From:* Michael J. Sinclair <[email protected]> *To:* RBASE-L Mailing List <[email protected]> *Sent:* Monday, March 11, 2013 10:48 PM *Subject:* [RBASE-L] - Problems with unload ALL > > Hi, > > I am trying to clean up my database (Rbase 9.5 32) When I try to run > this command... > > UNLOAD ALL > > I get this error message... > > -ERROR- Column BP1 exists as both a computed and non-computed column. > (195) > > But when I try to find it by doing this... > > LIST column BP1 > >
