Please enable JavaScript to view this site.

R:BASE 11 Beginners Tutorial

You can save a query as a view.

 

To save the query as a view:

 

1.In the Query Builder window, choose File: Save Query as View from the menu bar.

 

R:BASE prompts you for the "View Name:" and "View Comment:".

 

2.Enter "FlightView" as the new view name.
3.Enter "Customers and Flights" as the comment.
4.Click the OK button.        

 

When you save the query as a view, you are only saving the query. The advantage to this is that each time you use the view; R:BASE includes any new data that you've added to the tables that make up the view.

 

Now we'll close the "Query Builder" window.

 

To close the "Query Builder" window:

 

In the Query Builder window, choose File: Close from the menu bar.

 

The view is saved and is listed in the Database Explorer.

 

To open a view in the Data Browser:

 

In the Database Explorer window, highlight the view FlightView, and select the "Open View" option.

 

R:BASE displays the data retrieved by the query in the Data Browser window.

 

To close the Data Browser window, select the "X" button, or by press the [Esc] key.