Installation
System Requirements
Install Toad
Specify App Data Directory Location
Read-Only Installation
Install Toad Silently
Install Toad on Citrix Systems
Upgrade Toad
Upgrade Automation Scripts
Files Migrated During Upgrades
Uninstall Toad
Configure Toad Layouts
Create Connections
Understand Toad Connections
Create Access Connections
Create Amazon Redshift Connections
Create BusinessObjects Connections
Configure DB2 Client Connections
Configure DB2 LDAP Support
Create DB2 Connections
Create Excel Connections
Create SharePoint Connections
Create Google Analytics Connections
Create Hive Connections
Create Intelligence Central Connections
Create MySQL Connections
Create ODBC Connections
Configure Oracle LDAP Support
Create Oracle Connections
Create Oracle BI Connections
Create PostgreSQL ODBC Connections
Create Salesforce Connections
Create Snowflake Connections
Create SQL Server Connections
Create SSAS Connections
Create SAP Connections
Create SAP HANA Connection
Create Teradata Connections
Troubleshoot Connections
Troubleshoot Access Issues
Troubleshoot Hive Issues
Troubleshoot Excel Issues
Troubleshoot DB2 LUW Issues
Troubleshoot DB2 z/OS Issues
Troubleshoot Informix Issues
Troubleshoot MySQL Issues
Troubleshoot Oracle Issues
Troubleshoot SQL Server Issues
Troubleshoot Sybase ASE Issues
Configure Version Control
Edit Data in Read-Only Grids
If you cannot edit data because the table does not contain a primary key, you can define a temporary key so that you can edit the data.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To edit data in a read-only grid
-
Click the red indicator
in the lower left of the data.
-
Accept the defaults to begin editing data or review the following:
Key Columns
Select the columns on which you want to add a temporary key for editing purposes.
Updatable Columns
Select which columns are affected by updates and inserts.
Tip: You can select the drop-down beside 