>>>>>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.
>
>Thanks. I'll consider doing this for future views now that I've got a handle on what they're all about. Sounds like the easier way once you understand the language.
There is a way to edit the SQL directly using the GETDBPROP function I believe. There was a thread on this a few days ago.