News

Check the latest development news here

Forum upgrade

the forum has been upgraded to Yabb 2.5.

Note: the forum link was changed so you might need to refresh the main page or clear browser cache.

 

2011.10.03

Downloads

SQLTools 1.5 RC1 build 22 - urgent bug fix release - pls update

SQLTools 1.5 RC1 build 21 & OpenEditor 1.0 RC1 build 1

SQLTools 1.5 build 14 Beta

• SQLTools has been released under GNU GPL v3 (updated from v2 to v3).
• "Find Object" <F12> and "Load DDL script" <Ctrl>+<F12> use an updated object name resolver that can handle ALTER SESSION SET CURREN_SCHEMA = <Schema>

• Improvements in DDL reverse engineering:
  • implemented PARALLEL clause for tables, indexes and clusters
  • implemented event triggers

   

• Improvements in "Object List (Alt+3)":
  • Schema list control got new addition to the context menu. It allows quick switch between previously selected schemas (session live scope)
  • Changed a default action for the table list. <DblClick> will load DDL instead of switching to "Object Viewer". <Alt>+<DblClick> will show the current selection in "Object Viewer"
  • <Del> accelerator is not linked with "Drop" action anymore for safety reason. You should use <Ctrl>+<Del> as a short cut for "Drop"

   

• A minor bug fix for Drag&Drop from Grid component

I've started fixing some things after years of neglect... Not sure yet if it is serious enough...

SQLTools 1.5 build 10 Beta

• bug fix - execution of a part line selection does not support bind variables
• bug fix - dbms_output line limit increased from 255 to 4000 chars
• bug fix - "SQL Quick Reference guide" search/index tabs miss some keywords (sqlqkref.chm)
• some improvements taken from sqltools++ by Randolf Geist (2007 version)
• some small fixes in "Find Match" Ctrl+]

OpenEditor 0.99 Beta build 2

• improvement, added "smart" end key behavior
• improvement, redesigned PL/SQL syntax analyzer ("Find Match" Ctrl+] works better)
• improvement, the program settings are stored as XML in %APPDATA%/GNU/SQLTools (private) or /SharedData (shared) depending on user choice
• Some minor bugs have been fixed.

SQLTools 1.5 bald 9 Beta

Improvements (some taken from sqltools++ by Randolf Geist):

• redesigned PL/SQL syntax analyzer ("Find Match" Ctrl+] works better)
• redesigned Connect Dialog, connection information is stored encrypted in XML file
• the program settings are stored as XML in %APPDATA%/GNU/SQLTools (private) or /SharedData (shared) depending on user choice
• implemented Filter for "Object List"
• improved keyboard navigation in "Object List"
• added Recyclebin to "Object List"
• improved error handling for "Extract Schema DDL"
• implemented DDL reverse engineering for partitioned tables and indexes
  

Some minor bugs have been fixed.

SQLTools 1.4.2 stable RC3

Following bugs have been fixed:

• invalid path in tooltip after tab reorganization
• pls/sql match searching has been disabled because it might generate stack overflow and cause program termination
• cannot get DDL for db link if its name is longer than 30 chars
• handling NULLs for PCTUSED, FREELISTS, and FREELIST GROUPS storage parameters
• compatibily issue with Oracle 7 and 8.0.X
• poor fetch performance because prefetch rows disabled
• confusing message if password is empty
• sqltools cannot find tnsnames.ora in 10g client installation
• EXEC does not support bind variables
• Data grid has an issue with resizing the first row
  

Updated version of a new help (BT & MT).

SQLTools 1.4.2 stable RC2

This is a second candidate release. Thanks to Benjamin Tellier and Michel Traisnel we have a new help. Anybody please review it and report mistakes. If there are ANY critical bugs - also report it.

Thanks for your contribution
Tomko

2006.03.07

SQLTools 1.4.1 build 72

Changes mainly in an installer. Thanks to Oswaldo Enriquez and Alexandre Tarquino for translations.
Fixed also some memory associated bugs and improved drag&paste from ObjectViewer (try to drag items with an ALT key).

2006.03.01

Spanish tutorial

Thanks to Oswaldo Enriques we have Spanish translation of tutorial.

2006.02.28

SQLTools 1.4.1 build 71

In this release I'm proud of our small multilangual installer script (currently: English, Polish, French and Hungarian localizations). Thanks goes to: Michel Traisnel, Tamas Gati and Manu. Try also to drag'n'drop a table name from ObjectViewer.

We are searching brave people to finish our new help for SQLTools!
Contact with me through the SF.net or the Sqltools.net forum.

Tomko

2006.02.16

Forum upgrade

We've upgraded Yabb to 2.1 version of this forum.
And TreeMenu to 4.3:)

Please refresh main page in your browser!

2006.01.31

SQLTools 1.4.1 build 70

This is the first release after a long time and (un?)fortunately my first release. We've lost the NSIS (installer) script, so exceptionally this version is released as a ZIP archive.

Improvements:

• 1108078 - Dockable 'Objects list'.
• 1078900 - 'Find object' (F12) and focus of editor cursor.

• 1407225 - 10g 'Load all in one' problem.
• 1404162 - Trigger with CALL - unsupported syntax.
• 1373859 - Unserved exception after cancelling Drop.
• 1221764 - DROP DATABASE LINK error.
• 1191426 - Invalid COMPRESS index generation.
• 1119107 - Lack of SYS. prefix in Queries.
• 1111222 - Better diagnostic for investigate this bug.
• 1078885 - Doubled GRANT when extracting Columns Privilages.

OpenEditor 0.98 Beta build 3

Bug fix 1185035, "Show message on EOF" doesn't work

OpenEditor 0.98 Beta build 2

Major Improvements contributed by Tomasz Drzewiecki:

• 1081930 - First implementation of request "Open file under cursor".
• 1092510 - Drag and drop for woorkbook tabs.
• New Netscape-like property sheet interface & new tabs.

Most serios bugs:

• 1165795 - Hanging on trying to replace 'a' with 'aa' in the current selection.
• If file are locked, an unrecoverable error occurs on "Reload"

You can find more details about features and fixed bugs in history.txt.

SQLTools 1.4.1 build 66

Improvements:

• See OE 98 build 2

Following bugs have been fixed:

• See OE 98 build 2
• B#1181324, trigger reverse-engineering fails if description contains comments (again)

SQLTools 1.4.1 build 64

Improvements:

• Bind variables (SQL*Plus syntax for VARCHAR2, NUMBER, CLOB), contributed by Ken Clubok. This feature will be improved soon.

Following bugs have been fixed:

• unhandled exception "invalid string position"
• unnecessary bug report on statement, like this "select * from dual;;"
• an exception on "Find Object", if some name component is null

SQLTools 1.4.1 build 63

1.4.1 build 63 Improvements:

• SQL*Plus CONNECT/DISCONNECT commands
• CSV prefix option (for Excel)
• added support for BINARY_FLOAT and BINARY_DOUBLE

Branches 58X and 59-60 have been finally merged, but XMLTYPE is still disabled.

• TIMESTAMP, INTERVAL support
• grid format for number columns

Following bugs have been fixed:

• empty bug report on disconnect if connection was already lost
• trigger reverse-engineering fails if description contains comments
• substitution "&var." does not work
• cannot execute "exec null" w/o ending ';'

NOTE: If you use 1.4.1 build 59-60, please choose "Replace settings" on page "Upgrade options"

SQLTools 1.4.1 build 589 Beta is the first build under GPL.

Improvements:

• An input field for Find/Describe object window has been added

Following bugs have been fixed:

• '/' might be recognized as a statement separator at any position

I promised to do more but that's it today :(

 

2004.12.13

SQLTools sources are available on SourceForge.net. Probably the next build will be available tomorrow.

 

2004.12.02

SQLTools 1.4.1 build 588 Beta

The latest OpenEditor code has been included.
Following bugs have been fixed:

• all compilation errors are ignored after "alter session set current schema"
• all compilation errors are ignored for Oracle7
• some servers may return very long strings due to oracle bug
• external authentication does not work
• trigger reverse-engineering fails in OF clause if column name contains "ON_"/"_ON"/"_ON_"

I've completely rewritten all code which parses scripts end executes sql statements and sql*plus commands. It makes possible to expand the list of supported sql*plus command easily.

I still have 2 branches 58 and 59. Probably I'll merge them this month.

I've been reviewing my emails and forums. You can see ToDo. I expect that it'll be twice bigger when I've done.

I also created 2 projects on SourceForge: OpenEditor & SQLTools. The second one is just created so it's empty. It'll be setup during this month.

2004.10.27

OpenEditor 0.97 Beta build 78 , sources

Bug fix: Infinite cycle on Count/Mark/Replace All if "Search All Windows" is on.

 

2004.10.24

OpenEditor 0.97 Beta build 76 , sources

Small fixes and improvements:

• Columnar indent and undent mode has been added (if columnar mode is on)
• Indent and undent align each line individually to the nearest indent level

OpenEditor 0.97 Beta build 75 , sources

Improvements:

• Ruler for columns has been added
• Columnar markers has been added (can be defined on class property page)
• "Datetime stamp" command has been implemented
• Basic import/export command line tools for languages/settings (oe-tools)
• Columnar edit mode has been added (indent/undent not implemented yet)

I updated build 58 again now is 583. The cause is my mistake, a source file from build 59 was included in build 582. The result is compatibility problem with client 8.0.5 and untested support for TIMESTAMP/INTERVAL. Sorry, I reverted the file to the pervious state - there is no TIMESTAMP/INTERVAL.

I've mostly completed XMLTYPE support but it'll be available for Oracle client 10g only. And it's slow as hell :(. I'm going to test it for 2-3 days and build 60 will be available.

 

2004.07.16

Builds 58 and 59 have been updated (same files but builds numbers are 582 and 592). A serious bug has been fixed: SQTools crashes if a connection was broken.

 

2004.07.13

It seems that build 58 is not bad. It has been added to downloads and I highly recommend to upgrade sqltools to this build (especially if you work with BLOBs).

Regarding build 59, I found the following issues

• It's not compatible with Oracle client v 8.0.X
• DataGrid always uses English for date/timestamp columns

This week's plan: I'm going to resolve these issues and several bugs which I was told about recently. I'm also thinking about XMLTYPE support but probably it'll be available for Oracle client 10g only.

SQLTools 1.4.1 build 59 Beta and SQLTools 1.4.1 build 59 Beta RAR

Recomended for testing. If you need to downgrade to the previous build, you have either to reinstall sqltools with "replace settings" or to restore sqltools/data/sqltools.dat from backup folder.

Improvements:

• TIMESTAMP, INTERVAL support
• grid format for number columns

SQLTools 1.4.1 build 58 Beta and SQLTools 1.4.1 build 58 Beta RAR

Highly recommended because a serious bug has been fixed:

• Memory corruption on a query with blob columns (since 1.4.1).

Improvements:

• Action on disconnect: rollback, commit or user choice

SQLTools 1.4.1 build 57 Beta

Improvements:

• sort in editor

Following bugs have been fixed:

• Autocommit (since 1.4.1)
• Plan cost (introduced in 1.4.1 build 55)
• Unknown exception on "save as", if a user doesn't have permissions to rewrite the destination
• Exception "FixedString is too long (>=64K)" on undo after save

OpenEditor 0.97 Beta build 70 , sources (VC7.01 only).

Bug fixes for "FixedString is too long (>=64K)" on undo after save. I guess, it's one of the oldest bugs in OpenEditor and SqlTools 1.4.1.

OpenEditor 0.97 Beta build 69 , sources (VC7.01 only).

Bug fixes for "save as" and search/replace. Hopefully it'll be a stable build.

OpenEditor 0.97 Beta build 68 , sources (VC7.01 only).

some small fixes.

OpenEditor 0.97 Beta build 67 , sources (VC7.01 only).

Changes:

• text has been sort implemented (currently only 1 sort key);
• the program asks to continue w/o locking if it cannot lock a file
• some regexp search/replace problems have been fixed (like search for "^$")
• dignostics/exception handling has been taken from sqltools code

SQLTools 1.4.1 build 55 Beta is compatible with Oracle 7.3.X.

Sorry, I did not fix any reported problem and did not add any feature last month.

Build 53 was added to downloads - it seems it does not have new bugs :).

SQLTools 1.4.1 build 54 Beta - I'm redesigning EXPLAIN PLAN - the EXPLAIN PLAN window has been moved into SQLWorksheet and export in html has been implemented. Take a look on this picture. But it's the first step only.

I've got ftp space.

Thanks all,
Alex

REQUEST: i need 100M ftp resouce as temporary storage (for 1-2 days) for getting a gift - Oracle7 archive. If you can help me - pls email.

Thanks,
Alex

SQLTools 1.4.1 build 53 Beta - bug fix build. There is a couple of bugs but I don't have enough time to fix them right now.

Improvements:

• Bug-report memory consumption has been decreased

Following bugs have been fixed:

• DDL reengineering: domain index bug (introduced in 141b46)
• CreareAs file property is ignored for "Open In Editor", "Query", etc. (always in Unix format)
• Output: only the first line of multiline error/message is visible (introduced in 141b50)

SQLTools 1.4.1 build 53 Beta - If you need a little faster and smaller executable (compiler optimization is on).

SQLTools 1.4.1 build 52 Beta

Improvements:

• global sql history is done
• history files are merged if concurrent sqltools instances save history for same files
• setting and history can be moved to another location. You can do it only manually, see example:

      REGEDIT4 [HKEY_CURRENT_USER\Software\KochWare\SQL Tools\Roots]
      "History"="e:\\_TEST\\SQLTools.settings\\sql-history"
      "Settings"="e:\\_TEST\\SQLTools.settings\\data"

Following bugs have been fixed:

• export DDL fails if an object name contains on of \/:*?"<>|
• command line parser fails on sysdba/sysoper
• sql history memory limit

SQLTools 1.4.1 build 52 Beta - If you need a little faster and smaller executable (compiler optimization is on).

If something is wrong and you would like to return the previous build - you must copy data files from backup folder before reinstallation. Hopefully you will not need to do that.

SQLTools 1.4.1 build 50 Beta If you are interested in global/shared sql history - you can try it. I changed the grid control significantly - its a reason why I don't recommend it for all.

If something is wrong and you would like to return the previous build - you must copy data files from backup folder before reinstallation. Hopefully you will not need to do that.

Improvements:

• global sql history (shared between all sql worksheet)
• displaying current record# and number of records in the status bar

Build 49 was added to downloads.

Hopefully it's a more stable build than builds 47/48. I fixed a number of bugs and made small improvements. Simultaneously I'm making the next 50th build, which should support global history. Unfortunately it requires some changes in grid component (one source for multiple grids) and a lot of testing.

Bug fixes:

• exception on scrolling if grid contains more then 32K rows
• temporary tables reengineering fails on 8.1.X (since build 47)
• editor: exception on PgDn if "Cursor beyond end of file" is unchecked
• a connection info might not be displayed properly after changing an existing connection profile
• slow application startup on Win98
• a couple of typos in GUI

Small improvements:

• a connection info in the main window title (pls let me know if it looks ugly)
• a server version in the connection toolbar and in the status bar

SQLTools 1.4.1 build 49 Beta - If you need a little faster and smaller executable (compiler optimization is on).

Archives 2001.11.21-2004.02.10