You can use views in browse windows, data sessions, and programmatically in the same way you open tables. When you use a view, the view is opened as a cursor in its own work area. If the view is based on local tables, Visual FoxPro also opens the base tables in separate work areas. The base tables for a view are the tables accessed by the SQL SELECT statement that you specify in the CREATE SQL VIEW command when you create a view. In the previous example, using
product_view automatically opens the
products table as well.
When a view is based on remote tables, the base tables are not opened in work areas. Only the name of the remote view appears in the Data Session window.