SqlEdit

SqlEdit is a Database development tool very similar in purpose to Microsoft’s “Query Analyzer”. However SqlEdit will connect to any database for which you have ODBC or OLEDB drivers. This makes SqlEdit an extremely useful tool in environments where no suitable Query development tool exists or where many different Query development tools are used. In addition, due to it’s nature SqlEdit provides the functionality to execute a database ’script’ on any database with supporting drivers

Downloads

SqlEdit 1.10 Syntax hilight version   Non-Syntax Version SqlEdit Help

SqlEdit 1.9 Syntax hilight version   Non-Syntax Version SqlEdit Help

SqlEdit 1.8 Syntax hilight version   Non-Syntax Version SqlEdit Help

SqlEdit 1.7 Syntax hilight version   Non-Syntax Version SqlEdit Help

-- After 1.6 Only the syntax hilight version is supported as Syntax Hilighting can be disabled in 1.6. The non syntax hilight version will still be maintained as long as it convenient to do so, however no time has been spent in testing it so it should be treated as an unstable product (although it does share most of its code with the syntax hilight version).

SqlEdit 1.6 Syntax hilight version   Non-Syntax Version

Release History

SqlEdit 1.11 : (11/5/2004) SqlEdit 1.11 changes include : (Mostly user interface changes requested by users) Changed document title bar to also display the database connection name. Edit window now maximises by default . Changed the temporary file storage mechanism to use the users temporary directory for storage, while maintaining the install path for display styles. Changed the colours of the icon associated with database functions in text auto-complete. Changed 'Previous Connection' dialog to be re-sizeable, remember it's size, allow you view conections as icons only, remember icon display state (details, large icons, etc.) and allow you delete and rename previous connections. Made Connection dialog resizable. Changed previous dsn dialog so dsn's can be renamed.

SqlEdit 1.10 : SqlEdit 1.10 changes include : auto completion of table names, field names & function names (use hotkeys "ALT + ," "ALT + ." and "ALT + /" respecitvley), ability to view database tables / views available, ability to view current connection details, new 256 colour icons for windows explorer (still uses 16 colour ones by default, but 256 colour icons are available) and a 'save all files' option

SqlEdit 1.9 : SqlEdit 1.9 includes the addition of a "Build String" option to assist in building connection strings. Also included in this release is a fix to allow proper operation with versions of the Postgres ODBC driver later than 7.02.0001, if you use an old PsqlODBC driver, you will need to upgrade to any 7.03 variant or later (the fix for this may also correct some strange behaviour returning multiple recordsets on other platforms). Finally reporting the number of records affected should now have a more consistent behaviour.

SqlEdit 1.8 : SqlEdit 1.8 includes only minor changes in behaviour as requested by users, these include allowing syntax hilighter to force the case of keywords, including bound items in syntax hilighting (e.g. 'text'), and changing the behaviour of the auto-resizing of the edit window.

SqlEdit 1.7 : SqlEdit 1.7 is essentially version 1.6 with online help. The help is distributed separately as it is quite a bit larger than the application, and SqlEdit is fairly easy to use anyway, so many people will not need the help file.

SqlEdit 1.6 : Release 1.6 of SqlEdit has 2 major additions : firstly, threaded query execution (allows the query execute in a separate thread), this allows multiple queries to be executed at a time without tying up the entire application. Secondly, a new feature "command breaks" allows a query string be broken up and sent in separate chunks to the database system. This allows databases such as ccess return multiple recordsets in a single execution. Additionally, there is a new style & syntax management system to allow association of different styles & syntax hilighting schemes to different sql dialects. This is the last release of SqlEdit with a syntax and non-syntax version as from 1.6 onwards, syntax hilighting can be disabled.

SqlEdit 1.5 : Release 1.5 of SqlEdit contains fixes to some minor behaviour irregularities, as well as quite an amount of work on the Syntax hilighting and handlind code. Copy/Paste will now only accept text (no other ole object types), pasted text is now parsed & hilighted, introduced multiple level undo/redo (syntax hilight version only), quite a bit of aesthetic modification for icons etc.There are two versions in this release : a syntax hilight and non syntax hilight version. The codebase for both is the same but the Syntax hilight version still requires some work on speeding up the hilight parser. If you work with large files, the non syntax hilight version is recommended.

SqlEdit 1.4 : Latest version of SqlEdit, this release has Syntax hilighting & one or two other small extras. This is considered an "unstable" release as the undo (CTRL + Z) functionality is inoperable and syntax parsing takes quite a while when you open a file greater than 60 or 70K (work is still in progress). Note that a (stable) non-syntax hilight version of this release is also available.