Database Fishing Tool

File Release Notes and Changelog

Release Name: 1.3.2

Notes:
-------------------------------------------------------------------------------
DaFT                       Database Fishing Tool                  July 05, 2005
-------------------------------------------------------------------------------

Welcome to Daft, the Database Fishing Tool, a free ODBC database exploration
tool available for Linux and Windows. 


Daft is written by Jelco Huijser, and licensed under GPL. Any suggestions,
questions or comment can be sent to jelco@users.sourceforge.net. 

The homepage for DaFT can be found at:	
		http:/daft.sourceforge.net/

What is Daft?
-------------
DaFT is a GUI to any database that can be connected via ODBC. It provides list
views of tables and columns, table view of data, SQL editor, CSV , HTML, SyLK,
DIF data format export, a function for copying data between two ODBC databases. 
Written in TCL/Tk.

Additional sources used by Daft (already incorporated in the kit)
-----------------------------------------------------------------
In case you need the sources or documentation for the additional packages used
by DaFt, you can find them at:

TCLODBC:	http://sourceforge.net/projects/tclodbc/
TKTABLE:	http://sourceforge.net/projects/tktable/
MCLISTBOX:	http://www1.clearlight.com/~oakley/tcl/mclistbox/index.html
COMBOBOX:	http://www1.clearlight.com/~oakley/tcl/combobox/index.html
TREE:		http://www.hwaci.com/sw/tk/treepi.html

StarKits:	sdx (the starkit wrapper): http://www.equi4.com/sdx.html
		tclkit (scripting runtime): http://www.equi4.com/tclkit.html


INSTALLATION
------------
	Linux
	-----
		Gzipped StarKit
		---------------
			Copy the file DaFT_x.x.tar.gz to the directory where 
			you want to install DaFT. Than change directory to this
			directory.
			In a command console (i.e. xterm), do a:
				tar xzvf ./DaFT_x.x.tar.gz
			Next, change directory to ./DaFT_x.x and execute the
			configure script. This script will create a daft.sh 
			executable script and make a symbolic link /usr/bin/daft
			to this script.
			Start DaFT by typing daft & in an xterm.
			This step assumes you have tclkit installed its
			location in your $PATH. See above for the website if 
			you want to download tclkit.
			unixODBC version 2.2.8 or higher must be installed.
			
		RPM-ed Starkit
		--------------
			Do a rpm -i daft-x.x.x.i586.rpm as root and daft will 
			be installed. unixODBC 2.2.8 or higher must be installed.

	Windows
	-------
		Setup_DaFT_x.x.EXE
		------------------
			Double click on the file and follow the instructions
			on the screen.

		Zipped StarKit
		--------------
			Unzip the files in a directory. If you installed Tclkit
			you can assiociate the .kit file extension with Tclkit.
			You can also use the DaFT.bat file to start the kit.
			In order to run the DaFT.kit you must have installed
			Tclkit. See above for links to the equi4 website.
			The kit file can be unwrapped with the sdx utility,
			which can be downloaded from the equi4 website too.
			After it is unwrapped main.tcl can be run by the tcl
			or wish interpreter.


PREREQUISITES USING DaFT
------------------------
The current version of the Database fishing tool depends on the tclodbc
library. The tclodbc binary is available for windows, binaries for other 
operating systems must be compiled seperately. The binary included for Linux
is based on a Suse 8.0 Linux installation, unixODBC, and oratcl 4.0. 
	
If you are using DaFT under Linux, you need to set the ODBC administrator
program. You can find it in most distributions as /usr/bin/ODBCConfig.

GETTING STARTED
---------------
After starting DAFT you'll probably want to open an ODBC connection to a
database. A database can be a CSV file, excel, or a scheme in a Oracle, 
Progress, MySQL, PostgreSQL, or any other relational database. Go to the File
menu, click on Open Database, No Role. You can do the same by Ctr-o. If you
don't see any ODBC data sources you must create them with the ODBC 
administrator. You can read more about the roles concept in the DaFT Help page.

UPGRADING FROM DaFT 1.0.X (Windows)
-----------------------------------
Version 1.2 can best be installed in a different directory as version 1.0.
The projects.cfg file (if created), will be converted and copied into to the
profil.dft file. The settings.cfg file can be copied into the installation 
directory, so the user defined layout settings and options will be read into
the new version too.

UPGRADING FROM DaFT 1.1.X (Windows)
-----------------------------------
Version 1.2 can best be installed in a different directory as version 1.1.
The connections and projects saved in the previous profil.dft file can reused 
again; just copy the old profil.dft file to the new installation directory. The
settings.cfg file can be copied into the installation directory, so the user 
defined layout settings and options will be read by the new version. It is 
advised to copy both the settings.cfg and the profil.dft. Version 1.2.1 works
by default with the profil12.dft file name, so the profil.dft will not be used,
unless the old settings.cfg is copied over the new settings.cfg (if already 
created). The old settings.cfg refers the profil.dft and might also contain the
key to read the profil.dft database passwords.

WHAT'S NEW IN VERSION 1.3 ?
---------------------------
   * Themes!
   * Fixed a few bugs in the Creation of projects, reading and writing to the
     project database.
   * (1.3.2) Automatic reloading of the database objects when the database is 
     changed within the same connection. This configurable per type of driver.
   * (1.3.2) Non-standard statements (i.e. not select,insert,update or delete)
     will by default not be handled by a database fetch, unless executed as a
     "single statement" which is necessary when stored procedures are called.

WHAT'S NEW IN VERSION 1.2 ?
---------------------------
   * Execution of selected text, useful for testing a block of T-SQL or PL/SQL 
     code.
   * Colored lines in de log messages, indicating errors, OK messages, or ODBC 
     messages.
   * Undo/Redo (Ctr-z/Ctr-y) for the SQL-Pad and SQL-Statement editor
   * Tip of the day, see [Help Menu]
   * Check for new version [Help Menu]
   * Improved and additional menu's and icons
   * Bypassing of date/time conversion
   * All statement output, except for insert, update, and delete statements,
     are send to the Data table view
   * Automatic creation of profil.dft backup file, locking, and recovery.
   * Progress bars indicating script execution or script creation progress
   * (1.2.1) A user configurable setting indicating the number of records at 
     wich point the user must be asked to stop further retrieving of any
     records.
   * (1.2.1) Clear buttons for tables and Log Messages
   * (1.2.1) A new function on top of the statement history stack for 
     remembering current statement and blanc the SQL Editor.
   * (1.2.1) Improved INSERT script creation dialog, which enables the created
     script to be copied into the SQL Editor at once, ready for execution on
     another database.
   * (1.2.1) Improved Date/Time handling functions when creating INSERT
     scripts. The user now has the possibility to map datetime fields to a 
     predefined format, and define which statement in the INSERT line should be
     used to reformat this date value (a string) to the target database native
     format.

WHAT'S NEW IN VERSION 1.1 ?
---------------------------
   *	Filters on the snapshot data.
   *	Remembering of the last used filter per table.
   *	Indication of unique indexes in the columns listbox
   *	Connection history
   *	Stored encrypted passwords
   *	Difference higlighting when two selection sets are compared
   *	Binary excel format export
   *	Improved help file format
   *	Date time format can be set per database type
   *	Expansion of the snapshot table view
   *	Export of the snapshot data
   *	Variable substituion in multi connection statements

BUG FIXES since version 1.3.2
-----------------------------
	*	1215867 Informix database switching error

BUG FIXES since version 1.3.1
-----------------------------
	*	1214347 error when clicked "show indexes" on a table
	*	1213064 ODBC connection doesn't work in 1.3.0 for NonStop

BUG FIXES since version 1.3
---------------------------
	*	Creating project databases had problems with date fields
		and text fields with some database types like MySQL.
	*	Retrieving queries from a project database resulted in an
		error in version 1.2.X
		
---------------------------
BUG FIXES since version 1.2
---------------------------
	*	Several....

BUG FIXES since version 1.1
---------------------------
	Version 1.1.1
	-------------
	*	Changed the directory structure references for the Linux 
		version
	*	Bug #1086421 No columns with ODBC-RDB
   
BUG FIXES since version 1.0
---------------------------
	Version 1.0.2
	-------------
	*	The maximum attempts to try to connect is made set up variable.
		This way the user can prevent to be locked out in some database
		systems when more then the allowed number of authentication
		failures has been reached; DaFT will stop trying to connect at
		the set maximum.

	Version 1.0.1
	-------------
	*	Fixed a problem reconnecting to a NonStop Database
	*	Added password remembering array, so the user does not need to 
		retype 
		userid and password when a reconnection is necessary
	*	Fixed a problem when trying to view data when another record 
		viewer is already opened. The previous viewer will be closed 
		first, before opening the new viewer.
	*	Fixed a problem with the time format conversion that would fall
		back to %c in some cases. (SQLServer date format)





Changes: