Toad Edge 1.1 - User Guide

User Interface

Connections View

All of your existing connections can be found in this view. You can edit or delete them as well as add new ones.

To create a new connection

1. Click the New Connection button or click the Connect button in application toolbar and select New Connection
2. In the dialog, first select whether you want to create a new connection using Manual Settings or enter a Custom Connection String
3. Fill in the Connection Settings. If you would like to use SSL or SSH connection, do not forget to enter their respective details as well
   
4. Next, enter the Authentication details
5. Note the Options where you can enable/disable AutoCommit and automatic restore of your windows and editors every time you connect to a database
6. Optionally, you can change the Connection Name and Use Color in order to distinguish windows and editors of different connections
7. You can Test Connection before you actually create it to see whether Toad Edge is able to connect to your database successfully
8. Finally, click OK to save the connection

Button	Option	Description
	Link with Editor	If enabled, bringing a window (Worksheet, Object Detail and Describe Object...) into focus will highlight the window in Connections View and selecting the window in Connections view will bring it into focus
	New Connection	Displays a dialog where you can create a new connection as described above
	Connect Selected	Connects the selected connection
	Disconnect Selected	Disconnects the selected connection

Connection properties

Existing connections, connection drivers and performance settings can be configured in this dialog.

To configure a connection

• Right-click any connection in Connections and select Properties

Error View

This view provides you with information about issues encountered during the execution of SQL statements.

• Click the error description to highlight the statement that caused the problem while working with Worksheet

Object Detail and Describe Object

Object Detail and Describe Object are the primary ways to view and modify objects in your database (especially data in Data tab). They are nearly identical except for one key difference:

• Object Detail is opened to view any database object of any connection
• Describe Object is opened for each connection to view all database objects of the connection

To view an object in Object Detail window

• In Object Explorer, double-click the object you would like to view
• Note how each object is displayed in its own Object Detail window

To view objects in Describe Object window

1. In Object Explorer toolbar, enable the Open Objects in Common Detail Window option
2. Left-click any object in Object Explorer that you would like to view

• Note how all objects of a connection are displayed in one Describe Object window

The tabs displayed in Object Detail and Describe Object depend on the specific type of an object you are trying to view. For example, if you open a table, you will see additional tabs such as Columns, Indexes and Constraints.

Data tab

One of the most useful features of both Object Detail and Describe Object is this tab where you can view, filter and edit data in your tables and views without the need of writing complicated SQL queries.

TIP: While working with records in a child table, you can quickly move to the linked record in the parent table by pressing CTRL (⌘) and clicking on the record value in its foreign key column. You can recognize such values by hovering over them while holding the key - they will turn into a hyperlink.

Button	Option	Description
	Refresh Query	Refreshes the data currently visible in the grid
	Cancel Query	Cancels loading of the data in grid. Useful in cases where your tables/views have millions of rows and you have disabled the Use fetch limit option
	Insert Row	Creates a new record in the table, simply fill in the values for all columns
	Delete Rows	Deletes the selected row(s)
	Apply Changes	Saves the value that is currently being edited
	Discard Changes	Restores the original data in the value that is currently being edited
	Commit Transaction	Commits the changes you have made to the table. See AutoCommitfor more information
	Rollback Transaction	Rolls back the changes you have made to the table. See AutoCommitfor more information
	Resize Columns to Data	Resizes columns so they fit the values they contain
	Sort Columns Alphabetically	If enabled, the columns are ordered alphabetically
	Select Visible Columns	Opens a dialog where you can select which columns you would like to display or hide
	Sort Data	Opens a dialog where you can sort the records by one or more column values in ascending or descending order
	Filter	Filters the currently shown data. Use the same notation as you would in the WHERE clause in a query. In case of multiple conditions, put "and" between them TIP: The light bulb icon suggests that there is an available history of your Where conditions. Press CTRL (⌘) + ARROW DOWN while typing in the field to view it.