General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only