>CREATE SQL VIEW seems to always expand my macro. Thus, leaving me with the same statement in View Designer I started with.
But you shouldn't use View Designer anymore. View is ready and can be used in your program. You can also use DBSETPROP() to modify view properties.
Edward Pikman
Independent Consultant