Table Editor - Aqua Data Studio provides a Table Editor which allows a user to graphically edit a resultset of a executed query. To activate a table editor you must write a single-table SELECT statement and use the "Execute Edit" button. This will execute the query and return the resultset in a new Table Editor window. From this window a user may edit the contents of the resultset and then save the changes.

The editor uses the primary key or any unique constraint to identify the row in the result it will generate UPDATE statements for. If your resultset doesn't have a primary key or unique constraint, you will be prompted to define a primary key in the primary key tab.

The editor allows you to add, edit and delete rows. The changes in the editor or color coded so that you may see your changes before commiting the changes. Before saving you may clear any part of your changes. You may also preview the changes that will be made in the 'Preview SQL' tab window, or save the SQL statements for the changes to a file.

• General
  • " Edit in window" option now has an extra tab that provides an editor which wraps the text so the user may edit in a regular or a wrapped text mode.
  • "Save SQL" now stores the chosen directory path and uses it for subsequent save operations as a default directory for easier navigation
  • Preview panel: The preview panel now creates a cells preview at the bottom split panel to allow the user to preview the currently selected value in the grid, so that the user may easily see the full value, including long string values or CLOB values.
  • Status Bar now has "Total Rows:" information at the bottom right to show the number of rows in the table.
  • After the changes are saved and the table is refreshed (Save and Refresh), the cursor selects the first cell of the selected row before save.
  • Edit->Format: AutoFit Column Width - Cells can now be highlighted and resized automatically using the menu, a key shortcut, or a double-click on the right border of the column header. This option can be cofigured from the dropdown menu.
  • Edit->Next Tab: Move to next tab; Edit->Previous Tab: Move to previous tab; Edito->Focus Max Results: Move focus to the max results.
  • File->Options:General: Moved Table Data Editor options to Table Data Editor section.
  • When closing a modified window the application will now prompt for "Save", "Discard" and "Cancel" instead of "Yes" or "No"


• Visual Editing:
  • Inserted/Modified/Deleted rows now have light blue cell background
  • Modified cells now have a slightly darker color for the text, so it allows to see spaces.
  • Cells in Inserted Rows also have the background color of the text shaded to identify invisible characters
  • Entering a string value with length longer then the datatype can handle will notify the user of a possibility for truncation.
  • "Paste" now pastes the value from the clipboard into all the selected cells.
  • "Delete Row" is now "Delete Selected Rows" which deletes all the selected rows.
  • Editing a cell with a key stroke will clear the cell and start the cell value from the key typed. Editing the cell with a mouse double click will edit the cell but will leave the old value.
  • Edit->Clone Selected Rows - Clones the selected rows. This option can be also accessed from the dropdown menu.
  • Edit->Insert Current Date Only: Inserts the current date, and a time of 12:00pm if the date type is a timestamp.This option can be also accessed from the dropdown menu.
  • DateTime columns: If the user now enters or pastes a date or datetime in a different format then the default locale, then ADS will make a conversion. Example: 8/9/06 will be converted to 08/09/2006 12:00:00 AM
  • Toolbar: Added buttons for Clone Selected Rows and for Insert Date Only
  • Fill Functionality as Edit->Fill Down and Edit->Fill Right: Fills currently selected cells in the choisen direction with the first selected cell content. This option can be also accessed from the dropdown menu.
  • Pasting into a cell from a spreadsheet:
    • Pasting into a cell in edit mode will trim carriage return ("/r")
    • If a user copies one cell from a spreadsheet and pastes it into a single cell of the Table Data Editor it will paste the value without trailing carriage returns and line feeds.
    • If the user copies one cell from a spreadsheet and paste it into a number of selected cells, the Table Data Editor will paste the single cell into each individual cell.
    • If the user copies a block of cells from a spreadsheet then the Table Data Editor will paste the block into the corresponding cells starting from the leading selected cell; whether a single cell or multiple cells are selected does not change the functionality.
  • A user now can copy a row and then paste the row into an empty row. Select row, press CTRL-C, then select another row and press CTRL-V.
  • A user now can copy an x number of rows and paste into the last empty row and the necessary number of rows will be created to complete the paste.
  • Clear Cell Changes is now "Clear Selected Cell Changes".
  • Find/Replace Options:
    • Edit->Find: Find the first occurence of the text in the grid values starting from the current position, using the specified direction for search
    • Edit->Find Next: Find the next occurance of the last find
    • Edit->Find Previous: Find the previous occurance of the last find
    • Edit->Replace: Finds and replace a string occurence(s) by a specified string; if it replaces all of the occurences in the table, show how many have been replaced.
    • Added string matching options for Find and Replace: "match entire cell" and "match while words"
  • Hot Keys:
    • Quick Selection - Ctrl-Shift-R and Ctrl-Shift-K (by default) now selects all the rows or columns respectively that have cells that are currently selected.
    • Default Key Binding for Delete Row is now Ctrl-Delete, for Clear Changes is now Ctrl-Alt-Z, for Clear Cell Changes is now Ctrl-Alt-Y.
    • Key "Edit" will overwrite, F2 will put in edit mode with text highlighted and mouse double click will put in edit without highlight.
    • DELETE Key: Now will "Set to Null" all the selected cells instead of deleting the row.
    • CTRL-D Key: Now will delete the row

Saving Changes:
• If no results are returned then an error message is displayed.
• Now displays warnings when warnings are returned.
• If a statement is executed that doesn't make any modifications then the transaction is still commited. Ex: Deleting a row which has already been deleted by a different user.
• The table data editor is now threaded and there is a status bar at the bottom that displays the status of execution, including the number of statements to be executed and on which execution it is on. The toolbar now has a cancel button so the user may cancel the execution at any given time.
• If Save is cancelled while being executed, the status bar now displays the total number of statements executed before the cancel.
• Transaction Handling:
  File->Options:Table Data Editor: Added section for Table Data Editor Options
  • Transactions: Transaction Type: {Full, Batch, Threshold} :
  • Full: A "Full" transaction type causes all changes to be made in one transaction. This is the default.
  • Batch: A "Batch" transaction type will batch all the statements to be executed into batches with an X number of statements per batch. Each batch will be commited independantly. If a commit fails, the execution will stop and rollback the current transaction batch, but will not be able to rollback the previosly executed transaction batches.
  • Threshold: A "Threshold" transaction batch executes the statements in order and after each executed statement will check the amount of time ellapsed since the beginning of the batch. If the time ellapsed has reached the threshold time then the current transaction will be committed and a new transaction will be started. This will allow the statements to be batched in separate transactions based on a time Threshold.
  • Batch Size: Number of statements per transaction batch [For Transaction Type: Batch]
  • Threshold: Number of milliseconds ellapsed to trigger a transaction batch commit [For Transaction Type: Threshold]
  • Wait Time: Amount of time to wait between transactions [For all Transactions].
  • Transaction Log Monitor [Sybase ASE]: This will allow ADS to queue editor modifications for Sybase ASE if the Transaction Log percent hits a certain Threshold allowing the server to process the current transactions before receiving requests from ADS.
    • Log Used Threshold: Percent of transaction log used that would trigger a transaction to wait
    • Log Used Wait Time: Time to wait if a transaction log used threshold is triggered.