﻿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.
