[RBASE-L] - Re: Corrupted View - Razzak's Reply

[A. Razzak Memon]

Tom,

That's exactly the cause of broken VIEW definition.

So, what you have to do is the following:

01.     At the R> prompt:

        OUTP ViewName.VIE
        UNLOAD STRUCTURE FOR ViewName
        OUTP SCREEN
02.     RBEDIT ViewName.VIE

        . Delete all information up to the line before "CREATE VIEW ...."

        . Insert a new line before "CREATE VIEW ..." as following:

        . DROP VIEW ViewName

        . Make all adjustments accordingly.

        . Save ViewName.VIE

03.     RUN ViewName.VIE

That should DROP the original view and will create a new view with SAME
name along with correct definition.
Using the Next Generation R:BASE 7.0 for Windows, things are more simpler!
(I know you are using R:BASE 7.0)
01.     You can UNLOAD the view simply by right clicking a mouse on
        selected view.
or

02.     Use cooooool Query Wizard and/or Query Designer to achieve the
        same goal!
Very Best R:egards,

Razzak.

At 10:05 AM 6/18/2003 -0400, Tom Eldred wrote:
Razzak,

Two columns were added (Amt_03 and Date_03) and a total column was modified
by adding (amt_03) into its composite expression.
The column that is referenced in the error message was dropped form an
unrelated table in July of 2002.
Tom

----- Original Message -----
From: "A. Razzak Memon" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[EMAIL PROTECTED]>
Sent: Wednesday, June 18, 2003 9:12 AM
Subject: [RBASE-L] - Re: Corrupted View - Razzak's Reply
> At 09:12 AM 6/18/2003 -0400, Tom Eldred wrote:
>
> >Tried unloading the view to no avail... RBase will not allow me to copy
it
> >since it is "missing a column"  Any ideas/suggestions?
>
> Tom,
>
> Have you renamed/dropped any column(s) associated with that VIEW?
>
> Very Best R:egards,
>
> Razzak.