Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Modifyed table name doesn't update view column name
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00215077
Message ID:
00215081
Views:
28
>I have view that gives me error when I try to modify it:
>
>SQL: Column "field | variable" is not found (Error 1806)
>The field or variable you specified cannot be found.
>
>I rename a field in my table, but the new name did not get updated to my view column names and I get the error message above. Is there a way to get the new name from table updated to all my view that access that table name? I did a rebuild and it still didn't work. I don't want to restart over creating view because there a about 20 views that use this name. Help appreciated.
>
>nick

Take a look in the files section, under VFP general. There is a util called eview that Eric did. I think that will help you out.

HTH
Jeff

It's Time to get a gun.

That's what I've been thinkin.

I think I can afford one, If I do a little less Drinkin.

www.TrueGeeks.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform