JavaScript Editor js editor     Web development 

Main Page

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.

FoxProDataSessionView screenshot

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.

See Also

JavaScript Editor js editor     Web development