Snap DB Copyright (c) 2010-2015 Jody Holmes (Skwire Empire) http://skwire.dcmembers.com/fp/?page=snap-db + added * changed - deleted ! bug fixed v1.5.1 - 2015-09-01 + When printing, added ability to add the header row into the output. (Thanks, M. Chapman) v1.5.0 - 2014-12-12 ! Erroneous selections when adding or editing records. v1.4.9 - 2014-10-01 ! The Delete toolbar button didn't work. v1.4.8 - 2014-09-30 + Added drag-n-drop functionality to rows. + Added Undo/Redo functionality using standard Ctrl+Z and Ctrl+Y hotkeys. + Added Cut/Copy/Paste functionality to rows using the standard Ctrl+X, Ctrl+C, and Ctrl+V hotkeys. * Copy cell data hotkey is now Ctrl+Alt+C. * Copy row data hotkey is now Ctrl+Shift+C. * Paste tab-delimited data hotkey changed to Ctrl+Shift+V. ! Hopefully fixed the freeze-while-resizing bug. v1.4.7 - 2014-01-11 + Added option to confirm deletion of records. (Thanks, W. van Bergen) v1.4.6 - 2013-12-28 ! Worked around a DPI-related bug where the listview columns weren't saved with the proper widths. (Thanks, eNdi) v1.4.5 - 2013-11-13 * Small cosmetic issue fixed. v1.4.4 - 2013-11-13 ! Fixed hotkey bugs introduced in the last version. (Thanks, Erekle) v1.4.3 - 2013-11-09 ! The Add/Edit record box was not appearing properly. (Thanks, Erekle) v1.4.2 - 2013-11-09 * Changed resizing routines to, hopefully, avoid a Windows XP bug. * SnapDB is now DPI aware. v1.4.1 - 2013-06-15 + Added menu icons to the Unicode build. * Non-contiguous listview selections are now movable with the Ctrl+Up and Ctrl+Down hotkeys. v1.4.0 - 2013-04-23 ! The search column drop-down list wasn't populated when loading files from the File > Import menu. (Thanks, Brinda) v1.3.9 - 2012-08-26 * Numbers with commas and/or dollar signs in them can now be summed. (Thanks, timn) v1.3.8 - 2012-04-02 + Added F4 hotkey for adding a new record. * Toolbar is now toggle-able. Use the View menu or Ctrl+T hotkey. * Took out the button icons in the add/edit dialog to speed things up. v1.3.7 - 2012-03-04 + Added calendar buttons to the add/edit record dialogues. + Added functionality to export current data views to external scripts or programs. See Help > Contents for more details. v1.3.6 - 2011-12-30 * Changed the filter mode so a subset of the File menu is available. ! If you're going to hotkey an action, it helps to actually add the code for said hotkey. Ctrl+W now works for the new web search functionality added in the previous version. (Thanks, daddydave) v1.3.5 - 2011-12-30 + Added a new "Web search this cell" option to the context menu. The default is to use Google but you can configure any search engine in the Options dialog. * Changed the filter mode so a subset of the Edit menu is available. v1.3.4 - 2011-12-03 + Added option to disable Ctrl+A within an edit field when adding/editing a record. This helps with some non-English keyboards when entering accented characters. (Thanks, J. Zebrowski) ! Printing didn't maintain the column order. (Thanks, J. Elmes) ! Copying row(s) to the clipboard didn't maintain column order. v1.3.3 - 2011-10-31 + Numeric columns should now sort properly for CSV files. (Thanks, Wayne) v1.3.2 - 2011-05-28 + Added sorting arrows to the listview headers courtesy of Solar's function at http://www.autohotkey.com/forum/topic69642.html. v1.3.1 - 2011-04-18 * Took the Run & Clipboard buttons out of the tab order when adding/updating a record. (Thanks, ApathyS) v1.3.0 - 2011-04-15 ! Minor statusbar change. v1.2.9 - 2011-04-07 ! Duplicate and Edit record functions were erroneously available while in filter mode. v1.2.8 - 2011-03-31 + Snap DB now tries to determine whether a column is numeric so it will sort properly. The logic is as follows: # A column with strictly integers will sort as integer. # A column with strictly floats will sort as float. # A column with both integers and floats will sort as float. # A column with ANY non-numeric text will sort as logical text. + Added the following filter types: # Does NOT contain # Does NOT equal # Greater than # Greater than or equal to # Less than # Less than or equal to # Regular expression (Thanks, timn) * Filter text is re-used when enabling the filter. (Thanks, timn) v1.2.7 - 2011-03-28 + Added basic Print function. Access it via the File menu, the toolbar button or the Ctrl-P hotkey. v1.2.6 - 2011-03-27 + Added whole word matching to the Find/Replace dialog. v1.2.5 - 2011-03-24 + Added simple Find/Replace functionality. Access it via the Edit menu, the toolbar button or the Ctrl-H hotkey. (Thanks, ApathyS) v1.2.4 - 2011-03-16 ! Alt-tab icon was pixelated when using the Unicode build. v1.2.3 - 2011-02-14 ! 'Copy column data' option didn't always copy all the column's data. v1.2.2 - 2011-02-12 ! Add/Update/Insert & Options dialogs should now always come up on top of the main Snap DB interface instead of centered on the main monitor. v1.2.1 - 2011-02-11 + Added 'Run/execute cell contents' to the list context menu. This will attempt to run/execute text of the cell you right-clicked on to bring up the context menu. You can also hover over a cell and use the Ctrl-R hotkey. + To copy a cell's contents, you can now simply hover over a cell and use the Ctrl-Shift-C hotkey. v1.1.9 - 2011-02-11 + Added 'Copy cell contents' to the list context menu. This will copy, to the clipboard, the text of the cell you right-clicked on to bring up the context menu. + Added 'Copy column data' entry to the header context menu. This will copy, to the clipboard, the entire column's contents. v1.1.8 - 2011-02-09 + Passing in a CSV or TSV/TXT file via the commandline is now supported. (Thanks, camerb) v1.1.7 - 2011-02-09 ! Fixed a small graphical glitch with the enable filter checkbox. v1.1.6 - 2011-02-04 * Changed how the clipboard-copy delimiter information is entered. Please use the help button to see how the tokens work. If you had spaces or tabs in your string, you will have to change it. v1.1.5 - 2011-02-02 + Snap DB is now Unicode capable. Notes: # This version is supported by WinXP and up. Older operating systems will need to use the SnapDB_ANSI.exe file instead. # Database files are read and written in UTF-8 format. + Added Ctrl-Shift-O hotkey for opening the Options dialog. * Changed the clipboard-copy delimiter to allow more than just one character. (Thanks, Winkie) ! Fixed GUI glitches with Add/Update/Insert and Options dialogs. (Thanks, Winkie) v1.1.4 - 2011-02-01 * Improved the matching logic when using the 'Run' buttons. (Thanks, Winkie) v1.1.3 - 2011-02-01 + Added 'Run' and 'Clipboard' buttons to the Add/Update/Insert dialog. The 'Run' feature will attempt to execute data that meet the following criteria: # A file or folder e.g.: c:\path\to\my.exe, c:\path\to\image.png # A URI/URL with "://" in it e.g. http://www.site.com # 'mailto:' links e.g. mailto:skwire@dcmembers.com + Added row-copying capabilities. You can set a custom delimiter to use under Options. There are three ways to invoke this feature: # Edit menu. # Ctrl-C hotkey. # Toolbar button. + Added Ctrl-V hotkey to paste in a tab-delimited block. This will allow you to copy rows with Ctrl-C and paste them in directly so long as you have 'Tab' set for the delimiter to use when copying rows (under Options). + Added 'Duplicate record' toolbar button. (Thanks, Winkie) + Added "Sum columns" feature and toolbar button. This feature will attempt to sum any columns containing numbers. It will ADD two extra lines/records at the end of the list with the totals. YOU are responsilble for deleting these lines or keeping them by saving. If present, these new lines/records are considered in the next invocation of the 'Sum columns' feature. In other words, Snap DB has no idea if those records are totals or regular data. (Thanks, Beth UK) * Add/Update/Insert fields will now appear in the same order as the columns. (Thanks, Winkie) * Changed 'Options' toolbar icon. ! Duplicating a record now sets modified state to true. ! If you closed out of an Update window, you could no longer insert records. ! Stale data was kept after closing out of an Add/Update/Insert window. (Thanks, Winkie) ! Filter drop-down list no longer resets when updating records, only when adding or deleting a column. (Thanks, alexsan01) v1.1.2 - 2011-01-28 + Column orders are now saved per database. + "Convert row data to header names" added to the Edit menu. This is useful after importing a CSV file. + Added custom CSV delimiter option under the Options dialog. (Thanks, DeVamp) + Added "Import" toolbar button. + Added "Options" toolbar button. + CSV exports should be more adherent to the CSV standard with regards to double-quotes and commas within the data bits. + The column order for CSV exports didn't match up with the listview column order. (Thanks, bob99) + Closing and saving a Snap DB database while in filter mode, and with a modified database, would result in Snap DB erroneously saving the filtered data view instead of the full, changed database. (Thanks, TalksToPCs) v1.1.1 - 2011-01-14 + Added an "Edit record" menu item. Also, the F2 hotkey will invoke this. (Thanks, Nikita) + Added a "Duplicate record" menu item. Also, the F5 hotkey will invoke this. (Thanks, TalksToPCs) v1.0.9 - 2011-01-12 + Added "Append column" toolbar button. * Due to some screwy listview bugs, I changed the "Insert column before/after" menu items to a single "Append column" item. This will add a column to the end of your current columns. Once added, simply drag the column to the position you want. v1.0.8 - 2011-01-12 + Dropping CSV & TSV/TXT files on the list now works. (Thanks, Stoic Joker) + Double-clicking a "non-row" area in the listview will trigger the "Add Record" dialog. This is the area below the last record in the list. (Thanks, Beth UK) + Added a "Sum column" option to the listview header menu. This will attempt to sum any numbers found in the column, display the total and offer to copy the total to the user's clipboard. (Thanks, Beth UK) * Improved the CSV/TSV/TXT import to automatically add new columns if needed. This applies to the pasting in of tab-delimited data as well. v1.0.7 - 2011-01-12 + Made the add/update/insert button default when adding a record so you can press Enter instead of having to click it. (Thanks, Nikita) v1.0.6 - 2011-01-11 + The listview font face, style and color are now configurable under the 'View > Options' dialog. + Made the "Load last database" feature an option under View > Options. + Option to keep a .bak backup after saving a database. (Thanks, mouser) v1.0.5 - 2011-01-10 * Made Snap DB's save routine more robust and fault-tolerant. (Thanks, mouser) * You can now pass .snp files to the SnapDB.exe and it will load them. * Snap DB now allows multiple instances of the viewer to run. + If the Last_File value is invalid, SnapDB will still automatically load the first .snp file found in the the SnapDB.exe folder. (Thanks alexsan01) v1.0.4 - 2011-01-10 + Added an extra choice in the Filter dropdown called "Any column." This will allow you filter using a string that matches any column. + Added ability to save chosen filter per-database. This means, to make use of this feature, you will need to set the filter and then save the database file on each database you wish to use this on. (Thanks, alexsan01) + Added ctrl-f hotkey to toggle Filter mode. (Thanks, mouser) + Added View > Filter mode menu option. v1.0.3 - 2011-01-07 + Added tab-delimited text file import. + Added CSV file import. + Added ability to paste in tab-delimited data directly from the "Edit" menu. ! Last saved file didn't work from the "Recent" menu. v1.0.2 - 2010-12-28 + Last loaded database is automatically loaded after application startup. + Snap DB will automatically load an .snp file if both of the following are true: 1) No config.ini file is present. 2) There is a .snp file in the same folder as the SnapDB.exe file. + This allows you to bundle the SnapDB.exe file and a .snp database file together for easy viewing. (Thanks, mouser) v1.0.1 - 2010-12-28 ! Fixed toolbar glyph issue under Windows 7. (Thanks, mouser) v1.0.0 - 2010-12-26 + First release.