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
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
