Yes sir.. I LOVE 7.0 and the way it can handle this!!! (p.s. 7.0 didn't even flinch at this change)
at the R:prompt I get the message " Unable to open file RPMEMBERS.vie (2583)" tom ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 10:25 AM Subject: [RBASE-L] - Re: Corrupted View - Razzak's Reply > > 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. > >
