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 > >
