File Release Notes and Changelog
Release Name: 1.4.3
Notes:
-------------------------------------------------------------------------------
DaFT Database Fishing Tool February 6, 2006
-------------------------------------------------------------------------------
Version 1.4
-------------------------------------------------------------------------------
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.4 ?
---------------------------
* SQL Editor margin and statement indicator.
The indicator in the SQL editor margin shows the user the SQL statement
scope as perceived by DaFT at the location of the cursor. The indictor shows
if the statement will fetch records, or not. If the interpretation is not
correct the indicator can be changed. This is useful when you write a
procedure or cursor statement that will retrieve records from the database.
It also lets you change the scope of the statement. By default any empty
lines are regarded as end of statement, this can be changed by
highlighting/selecting the full statement, and click on "set to selection".
* Tables and views tree view.
Different types of tables and views are now separated in a explorer type of
view. The old object type combobox has been removed.
* Tables and views filter with a combobox for remebering previous filter
statements.
* Include the database table or view owner.
The owner can be included in all generated SQL statements. This can be
turned or off per driver type.
* Colums and index tree views.
The old columns listbox is changed by a tree view that indicates the indexes
per column, and for some driver types the primary key too. The primary keys
can be found on tables for Oracle, SQL Server, MySQL, FireBird, Interbase,
Ms Access.
* Driver types for databases that do not support indexes will not show in the
index tab. This can be set in the Driver Type Settings
* Inclusion of the table/view owner in all generated SQL statements.
This feature can be set on or off at connection level (menu Connections) or
at the driver type settings.
* White space indicators.
A button on each table view is available that starts a function which will
scan all fields in the table for values containing white spaces at the begin
or and of the string. These will be indicated in orange. If the full string
contains blanks only, this will be indicated in green.
* Ascending and descending sorting of columns.
* Added right mouse click menus on several text entry fields.
* DaFT uses the Tile library version 0.7.2
* Handle Tables, Views, and colums with names (partly) in capitals with
surrounding quotes.
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.4.2
-----------------------------
* ------- Multi word column names gave error message when selected
* ------- New version indicator should work now
BUG FIXES since version 1.4.1
-----------------------------
* ------- Export of data to MS XLS file with integer or real type
of string, resulted in random number in first xls cell
BUG FIXES since version 1.4.1
-----------------------------
* ------- Changing width of the table treeview causes an error
when there is no database connected yet.
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:
BUG FIXES since version 1.4.2
-----------------------------
* ------- Multi word column names gave error
message when selected
* ------- New version indicator should work now
New functionality snice version 1.4.2
-------------------------------------
* Handle Tables, Views, and colums with names (partly) in
capitals with surrounding quotes.
About SourceForge
Develop Software
Community
Copyright © 2010 Geeknet, Inc. All rights reserved. Terms of Use
