You can try file#9474 eView by Erik Moore, ViewEdit by Steve Sawyer from http://home.twmi.rr.com/ssawyer/intro.html or
MakeView by Barbara Peisch at http://www.peisch.com/downloads.html

>How does one get around the limitations of the view designer? For example:
>
>I am defining a wiew that is a right join, but I want a character field to be character, not null, in the cursor when there was nothing there. Tried using an expression, but don't know how to give it a name. Ideally, I would like to just define the SQL and then define all the "extras" (defining updateable fields etc) graphically. Tried to hack the DBC... oops, it became unretrievably corrupted.
>
>TIA,
>
>Alex