>
>You can execute your code to create the view, and you can open the view, but you can not use the view designer to modify the existing view. The VD is expecting nested joins and spits out an error when trying to edit your view. Use EVIEW or run the GENDBC.App in HOME() + "Tools\Gendbc" to create the code needed to set properties for your view.


Actually I could not open the view, (and as I mentioned, I had used eview). I now know why. I lied when I said the properties were all right. This is an updateable view. The fields produced by the various joins are non-updateable. I had set the UpdateName for non-updateable fields to "", which does work sometimes.

When I set the update name for the non-updateable fields to the proper database!table.field the view opened fine. I would swear I have some other views with "" in the updatefieldname for non-updateable fields; they open and update fine. But this fix works, so I'll take it...

Thanks very much for your prompt response. It seems that everytime I run into a bug which I spend hours without solving, I finally find the answer five minutes after posting the question to the UT. Oh well, maybe this will save someone else from making the same mistake.