Viewing data in a spreadsheet

Editing spreadsheet values

Not every spreadsheet is editable. The following factors determine if a spreadsheet is editable:

• Results must be from a single table and not include calculated values.
• There must a unique way to identify each row, either via a database specific method (such as an IDENTITY column) or a primary key. (The primary key/identity columns must be selected in the original query.)

Saving changes

To save changes you've made in a spreadsheet, select Commit from the Spreadsheet menu (or click the commit button in the toolbar). MacSQL will generate the appropriate UPDATE, INSERT, and DELETE statements and send them to the remote server. The queries will be wrapped in a transaction for all supported databases except MySQL. Any errors will be reported in the error log (available from the Window menu).