>Thank You Very Much for your Reply Bonnie
>
>Hi
>
>Do you know if it is possible to edit the SQL statement directly.
>Using the View Designer it is hard to control the placement of
>parentheses.
>
>Thank You
>
>Gary Hagerty

No, but you can copy and paste the SQL to a PRG. Leave the view in the DBC temporarily. DO Home() + "tools\gendbc\gendbc" to run the GenDBC app which will generate the code needed to create all your tables, views, etc. GenDBC will output this to a PRG of your own naming. MODI COMM that prg, look for the code used to generate that view. Paste that code to a new PRG, tweak the code, the run that PRG.

You can also use Erik Moore's EVIEW utility found in the files section to help setup updating of views, getting the code, etc.