>Hi Sylvia,
>
>The easiest thing to do is create as much of the view as possible in the view designer, set all of the update properties, etc. Once you've done that run GENDBC against the DBC that contains the view. If you search the the prg generated by GENDBC for your view name you'll find the CREATE SQL VIEW statement followed by all of the necessary DBSETPROP calls. Copy all of this code to a new .PRG file, edit to your heart's content and then run it.

Mike -

Thanks. That's a good idea - basically a variation of Dave's where he adds all those properties or changes then with Dbviewprop. I hadn't thought of using Gendbc in this way, but then again, I hadn't thought of a lot of the ideas I get from this great group of people:)!

Sylvia