/text/shared/02/12000000.xhp Sun Microsystems, Inc. converted from old format - fpe

Explorer On/Off Turns on and off the view of the data source explorer. The Explorer On/Off icon is visible on the Table Data bar.

Icon Explorer On/Off

In the data source explorer you see the data sources registered in $[officename] with their links, queries and tables. Establishing a connection - As soon as you select an individual table or query, a connection to the data source is established. Once the connection is opened, the name of the data source, the Queries or Tables entry, and the name of the query or table selected is shown in bold type.

The context menu of the data source explorer contains the following commands relating to the entry to be displayed in inverted form: The commands in the context menu vary depending on whether a connection to the data source has been established. For example, you only see the command Disconnect if a connection has been established. Context menu of a data source main entry Administrate Data Sources Opens the Data Source Administration dialog. SQL Opens the Execute SQL Statement dialog. Disconnect Closes the connection to the data source. See Tools - Options - Data sources - Connections. Rename (for tables, views, queries) To rename an entry, call this command and enter the new name.. You can also do this by selecting the entry and pressing F2. The database must support renaming, otherwise this command is not enabled. Additional commands in the context menu of "Queries" New Query (Design View) Opens the Query Design window. New Query (SQL View) Opens the Query Design window, allowing you to create an SQL command directly. Additional commands in the context menu of an individual query Edit Query Opens the query in the Query Design View. Delete Query Queries are physically deleted. Copy Query Copies the query to the clipboard. From there it can be inserted into another document. Choosing the insert command opens the Insert Database Columns dialog. Additional commands in the context menu of "Tables" New View Design Opens the View Design window. This window is controlled the same way as the Query Design window. The view is designed and used like a query. Insert Table Inserts a table from the clipboard to the selected table container. You will see the Copy Table dialog. Relation Design Opens the Relation Design window. Additional commands in the context menu of an individual table Copy Table Copies the selected table to the clipboard. Additional commands in the context menu of a view Delete View Deletes the selected view. Copy View Copies the selected view to the clipboard. Insert View Pastes a view from the clipboard to the selected table container. You will see the Copy Table dialog..