>>>Does anyone know if you can assign alias field names when creating local views with the View Wizard?
>>>
>>>In the field selection tab I'd like to select field x AS y for the View output, but don't see any way to do it.
>>>
>>>Thanks!
>>>
>>>Mandy
>>
>>You can modify the view you created with View Wizard, and use Fields/Expressions option to add something like "field1+field2 As Newfield" into View definition. BTW, it works better if you create a view programmatically.
>
>Edward,
>I tried using the expression and it worked. Thanks.
>
>I'm just curious, if I created the view with the View Wizard initially, can I modify the code (programmatically) afterwards? I tried MODI VIEW Myview, but only got the Wizard back.
>
>Thanks again,
>Mandy
Probably not, at least I couldn't do it right now with 3b. However, you can create/delete view on fly using CREATE SQL VIEW, DELETE VIEW.
Edward Pikman
Independent Consultant