Table Viewer

     TableViewer is my free utility for querying your databases, flat files, and structured tables:

• SQL Server

• SQL Compact Edition (SQL CE)

• MySQL

• Postgres

• ODBC

• Access (32bit only)

• Excel (32bit only)

• CSV

• XML

• JSON

    It's Smart Code makes writing SQL code faster and more accurate. It keeps a history of your SQL statements, searches your T-SQL code lightning fast, and has many other cool features you'll just have to try out!

    Parse CSV, TSV, or custom delimiters, then bulk load to MS SQL, SQL CE, MySQL, or Postgres.

    The old gang at McKissock  and my new team at GrafTech are fans as well. So give it a try! You just might find your favorite SQL Tool!

    THERE IS NO HELP DESK FOR THIS SOFTWARE! You're pretty much on your own with using it. I use it day in/ day out and, if I find any issues, I'm pretty quick to update a fix. So check in often if you're having issues. From the Help menu just select Check For Updates.

     Some of my utilities that I use in developing and working (giving a shout-out to my faves):

    IrfanView - My hands-down favorite graphic viewing program!

    Greenshot - I love the functionality of this great screen-capturing gizmo. Taking screen shots of my forms for documentation, highlighting and annotating them is a snap.

    Inno Setup - Jordan Russell's Inno Setup is a great packaging and setup utility. It just works! Simple, flexible enough for me, and some great features.

    NotePad++ - The more I use it, the more I love it! When you're working with really large files this is a great text editor.

    KompoZer - For working with Microsoft's HTML Help Compiler, I wanted something that would create basic HTML pages without all the freight train load of tags and bloat that comes with some of the editors I've used. KompoZer fit the bill for me. Too bad it's no loger in development.

Changes found in Build 165:

1/11/2024 (7.24.11.165)

• Fixed issue where selection limits weren't being applied, only the global max records setting

12/11/2023 (345)

• Added Date Format to Workspace form

• Fixed issue where columns that started with a number would show up in the autocomplete list in the Grid Color form's Priority column.

10/30/2023 (303)

• Fixed issue with export to CSV

10/26/2023 (299)

• When doing a Count Distinct Values in the column context menu of the data grid, fixed to only count displayed items

10/19/2023 (293)

• Added Find to SQL History

• Unlocked Window column in the History so you can switch your windows around, allowing you to sort them the way you want.

10/11/2023 (284)

• Fixed issue when restoring variables that are no longer in the variables table

• Renamed MRU files when the connection is renamed to prevent orphan MRU files

10/4/2023 (276)

• Tried to resolve sort issue with data grid when you delete columns

• Log main form's toolbar when sorting to make it cleaner. Also select current tab page after sort.

• When doing restore, suppress main form's toolbar until after restore is done. Should stop flashing buttons doing history restore with a lot of tabs.

• Fixed issue where some pass through keys on main form could cause crash if there were no open tabs.

9/2/2023

• Fixed bug where If there is nothing after the --name tag, you would get a 'length cannot be less than zero' error.

• Added "Paste Text Unformatted" as a sub-menu to the Paste context menu, as some formatted text won't paste (copy/paste data from OneNote to see)

• On File Open for SQL Code Viewer, put filter for *.sql and All Files.

• Fixed issue on SQL History form where selecting the history record didn't always display the correct SQL text

• Add a Highlight List where it will re-highlight after coloring.

• Fixed issue where saving a Server record without the Master Password entered would hose up the passwords.

• Fixed issue where deleting a lot of History records at once would cause TableViewer to be unresponsive.

8/21/2023

• Fixed issue with drag-drop in data grid not working depending if CTRL pressed before ALT. Also added SHIFT+ALT to build WHERE clauses with values selected in data grid.

• To try to solve an issue where the grid events sometimes didn't fire, added new code to look for the event having a handler, and add one if it doesn't. NOTE: Not sure why this still happens sometimes. Only fix seems to be to close the tab and open a new one.

11/23/2022

• Fixed issue where 9's and 0's in field names would cause a short-circuit in the Smart Code, inserting the wrong field followed by the 0 or 9.

• Fixed issue where Paste/Undo functions weren't working like expected on the main form.

11/16/2022

• Fixed bug where Access databases could not be opened.

• Added Search to Flat File.

11/15/2022

• Fixed issue we found with grid search where the value might now be found.

11/2/2022

• Added right-click to History to restore variable values.

• Add Convert item to show/replace hidden characters ({NUL}, {GS}, {SS}, {FS}, etc).

• Double-clicking a work enclosed in single-quotes now selects the whole word (not just the last single-quote).

• Fixed issue where loaded file was compared to saved version and was seen as different as CR/LF gets loaded as LF.

10/31/2022

• Fixed bug where new data tab didn't color properly.

10/28/2022

• Fixed bug on Records where it got estimated records.

• When deleting records in the data grid with Auto Execute on,  commit the changes immediately.

• Added a right-click Distinct Count to display a count and a list of distinct values in the grid.

10/26/2022

• Fixed bug where clicking a cell in the Column List would throw a null exception if there was no row selected in the data grid.

• Added 'No to All' button on linking files on history restore.

• Fixed major bug on grid coloring where coloring a grid with column Autosize turned on was extremely slow, making you believe TableViewer was hung.

• Added default archive database to system settings so Code Viewer form can automatically select a default archive database for servers.

• Added new grid context menu to main form (and right-click Column Autosize button) to capture column widths. When turning off Autosize mode, existing column widths are applied.

• Changed how the removing grid color worked so it should be faster with a lot of records.

• Color Grid now allows moving/inserting items to color.

• Fixed issue where filtering the data grid for an asterisk would fail as it's a special character that needs enclosed in brackets to filter on.