>>>How do you create a VIEW from within a VIEW?
>>
>>Go to the view designer and select add table. Notice the radio button on the bottom right that says "Tables/Views"? Click on views. You'll be able to see the views you have already defined. This is particularly useful if you need to combine remote data with local data, because VFP won't allow you to add a remote table to a local view or a local table to a remote view. Is this what you needed?
>---
>I made a VIEW with CREATE SQL VIEW as firstview and now I need to CREATE a VIEW from firstview. would you please show me some code to do that..
>thanks :)
Robert,
Simply create your SQL SELECT with your view as if it were a table. Suppose lv_Customer is your view, then
SELECT * FROM
!lv_Customer WHERE ...
Jose
