![]() When you update or delete rows, DbVisualizer ensures that only one row in the table will be affected. Updates and Deletes Must Match Only One Table Row The block is pasted into a non equal number of target cells Binary files may also be copied in an external application and pasted in a cell in DbVisualizer (target cell must be a binary type). Copy/paste of binary data is transparent between grids or in the same grid. The grid editor supports pasting single data as well as block of data. The grid editor supports pasting data from the major spreadsheet applications, such as Excel and OpenOffice. The default setting are sufficient for most uses. The column and newline delimiter used for copy and paste operations in the grid editor are defined by the Copy Grid Cells in CSV Format settings in the Grid category in the Tool Properties dialog, under the General tab. The data on the clipboard may then be pasted either into DbVisualizer or any external application. You can copy selected cell values with the Copy Selection right-click menu choice or the corresponding key binding ( Ctrl-C or Command-C by default). Undoing updated cells simply reverts the changes to the original values. Reverting all cells in a row that are marked as Insert or Duplicate removes the complete row from the grid while a Delete marked row is cleared from its delete state. If you change your mind, you easily can undo edits: Edit at least the key column(s) value(s),.Click the Duplicate Row toolbar button,.Select the row above where you want to insert the new row,. ![]() You can also use the Set Selected Cells drop down menu to set a number of column values to things like null or the current date or time. Click the Save toolbar button to update the database. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |