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.