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
