>That's right - I created a view in the project using Create SQL View. I then opened that view from the project manager and saw the SQL statement that I had coded was changed. In addition, two tables that I had referenced in the SQL command did not even appear in the SQL code of the view.
>
>Are you saying that if you create a view in this manner, you cannot view the SQL code without the assistance of a utility?
>
>Where do I find GENDBCX?
>
>Thanks
Get the EVIEW utility in the UT files here. You can use the GENDBC.APP that comes with VFP. The version that ships with VFP 6 works correctly.
DO HOME() + "tools\gendbc\gendbc" with 'output_filename_here.prg'
This will create a PRG with all the code used to create your DBC, tables, connections, views, relations, indexes, etc. You can then MODI COMM this PRG to look for the code used to create each view. Copy and paste this code into your own
CreateView.PRGOnce you see the code, you will better be able to tweak your own code and re-create the views as needed. I only use the view designer once per view and that is to get the initial SQL code. Once you select all the tables, join them and slect the fields, click on the SQL button on the view designer toolbar. Highlight all the generated code, Ctrl+C and paste it in your own PRG to create the view. YOu can then use EVIEW to set all the other view properties.
Mark McCasland
Midlothian, TX USA