Even if the vie is messed up, you should be able to list it out to a file, drop it, and re-create it.
out myview.vie list view myview out screen rbe myview.vie -- fix the view and add the drop view myview to the beginning, add the create view line and make sure all the plus signes are there. Now you just need to "run myview.vie" to rebuild it. Don't use wild cards in the view column names. I always keep my views in files. They are much easier to maintain. When I want to change the view, I edit the VIE file and re-run it. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom Eldred Sent: Wednesday, June 18, 2003 9:25 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Corrupted View AMEN!!! Figuring this out is a major pain somedays as the original developer never provided documentation for his original plan and the modification process ran unchecked for about 8 years with three people changing things here and there. I have no clue what the original view started as, but slowly but surely we're getting it back :-) REMEMBER TO DOCUMENT!!!! That is my two cents worth on the issue, but I'm sure you full-timers already practice that Thanks you all for your assistance Tom Eldred County Road Association of Michigan ----- Original Message ----- From: "Javier Valencia" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, June 18, 2003 11:06 AM Subject: [RBASE-L] - RE: Corrupted View > I have run into the same problem that Troy describes and I have had to > recreate the view. Once you figure it out it is not too bad, but before > then, it is a pain... > Javier, > > Javier Valencia, PE > President > Valencia Technology Group, L.L.C. > 14315 S. Twilight Ln, Suite #14 > Olathe, Kansas 66962-4578 > Office (913)829-0888 > Fax (913)649-2904 > Cell (913)915-3137 > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Troy Sosamon > Sent: Wednesday, June 18, 2003 8:27 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - RE: Corrupted View > > My guess is your view has a column wild card in it something like this: > > create view myview as Select * from ....... > > When your view definitions have wild cards in them and you make structure > changes to any of the tables in the view, you have to drop the view and > re-create it. > > I normally make a habit of not using wild cards in views because of this. > > Troy > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tom > Eldred > Sent: Wednesday, June 18, 2003 7:12 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Corrupted View > > > Good Morning all... > > I have a two table view that selects our PAC members from a table called > Membmstr and shows their contributions as selected from a table called > RPCont. > > The where clause limits the selection to members who are PAC members and > links them by their PAC number. > > After adding columns for amount and date for 2003 contributions, the view > returns an error saying that a column that is not associatied with either > table is not present. This view generates several of our finance reports and > each of these indicates the same error. > > Tried unloading the view to no avail... RBase will not allow me to copy it > since it is "missing a column" Any ideas/suggestions? > > Thanks > Tom > >
