Eview is in the downloads. Not sure about Viewedit though I know you can get the latest version at Steve Sawyer and Rick Schummer's website
http://www.geeksandgurus.com/>Charles,
>
>Thanks. I will look into these tools. Are they in the download section? Also, to Jerry thanks for the tip on Gendbc.
>
>
>>First rule of views: the VFP View Designer isn't smart enough to do much of anything. DON'T DEPEND ON IT - EVER ! Learn to deal with views in code, using one of the excellent third party tools available like Steve Sawyer's ViewEdit or Eric Moore's EView.
>>
>>The VFP VD is not capable of doing two joins from one table, will munge AND...OR in where clauses, and often screws up the table list and tries to update tables that are there only for lookup.
>>
>>With one of the tools mentioned above it is very easy to control your views and create very complex views limited only by your understanding of SQL.
>>
>>To avoid the problem your faced with here - never create a view where the SQL code says SELECT *. Force the VD to ennumerate the field names by changing the order of two of the fields. Always check the SQL code to make sure all the field names are named.
>>
>>Finally, when you want to change data structure of a table by removing or renaming fields, be sure you open all the views first that use that table and remove that field from the selected fields list.
>>
>>Regarding fixing your existing views, you may be able to open them with ViewEdit enough to fix them ...
>>
>>HTH
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.