Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Field names in View Wizard
Message
From
16/09/1997 16:54:43
 
 
To
16/09/1997 16:28:00
Mandy Mccord
Public Interest Breakthroughs, Inc.
Albany, New York, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00050200
Message ID:
00050284
Views:
16
>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform