I decided to give a single number to versions of sd- packages, since sdsql strongly depends on sdtcl and I don't want people have unpaired versions. Nevertheless sdsql and sdtcl have their own versioning system that I will occasionally update! ;-) Legend: tksql: refers to the application (GUI) sdsql: refers to the library around which tksql is built sdtcl: refers to the base (not sql) library 0.8.28 jun 14, 03 * tksql/sdsql: fixed mistakes in handling of dates shortcuts (eg.: @m, 15/%m-2/%y-1 in filter statement) 0.8.27 Apr 29, 03 * tksql/sdsql: correctly handles new-lines instead of spaces in sql statements * tksql/sdsql: fixed a couple of minor bugs related to SubTotals: now tksql correctly formats Subtotals when calld from column menu 0.8.26 Apr 22, 03 * tksql/sdsql: fixed an error that prevented to delete a cell 0.8.25 Mar 20, 03 * tksql/sdsql: now when using completion of a field in tables (using tksql_attinfo mechanism) it correctly set the value (fix) * improved the widget that allows to choose between alternatives now a tktable is used instead of a listbox * tksql: improved _tksql function for bash_completion 0.8.24 Mar 17, 03 * tksql: changed behaviour of changeDB: more intuitive * sdsql: fixed handlink of inet/cidr types w/ postgreSQL 0.8.23 Mar 11, 03 * sdsql/tksql: fixed a minor but annoying problem: tksql complainig OLD(oid) not existent * sdtcl: modification in layout package (not relevant for tksql) * sdsql: fix in debugging and documentation 0.8.22 Jan 22, 03 * tksql: minor fix in creation of tksql_query table. Restarting TkSQL will anyhow fix the error. 0.8.21 Jan 18, 03 * yet improved tksql installation * minor fixes in creation of nicks 0.8.20 Jan 14, 03 * tksql: installation process fixed for tcl 8.4 0.8.19 Jan 11, 03 * tksql: added possibility to add a comment and to set pop attributes when creating a table. Comment is not system one. * tksql: a preference panel to set some usefull options * tksql: a procedure to catch up w/ modifications of tksql_query structure 0.8.18 Jan 9, 03 * sdsql: Fixed a minor bug in foreign keys * tksql: added possibility to create tksql_log 0.8.17 Jan 8, 03 * Improved backword compatibility w/ postgreSQL version < 7.1 0.8.16 Jan 3, 03 * ALL fixed installation script * tksql/sdsql: added backward compatibility with postgreSQL 6.5 * tksql: added one field to tksql_attinfo 0.8.15 Dec 29, 02 * tksql/sdsql: now we cope with mysql autoincrement, both when creating a table and when updating values (inserting was already ok) 0.8.13 Dec 27, 02 * sdsql: Fixes on handling of "tksql foregn keys" 0.8.12 Dec 26, 02 * tksql: Added creation of tksql_attinfo if needed * tksql/sdsql: loging with tksql_log is now disabled if tksql_log missing 0.8.11 Dec 24, 02 * tksql: Added possibility to create/drop tables/databases * tksql: fixed error tksql did not aknoledge query request in "known connections" * sdsql: Added accelerator in filter panel to choose operators * added handling of 'numeric' type (with fixed precision/n. decimals) 0.8.9 Dec 23, 02 * sdsql: Added possibility to filter w/ field not known to SELECT statement * tksql: Added possibility to drop a table * tksql: Added 'NOT IN' amongue possible operators * sdsql: added handling of 'numeric' type 0.8.7 Dec 16, 02 * tksql: added a handy menu to choose among known connections * sdsql/tksql: fixed a wrong default on DateStyle (Error: "parse error near sql") 0.8.5 Dec 15, 02 * tksql: completely rewritten. Added -nick opt. Now reads .tksqldb to know how to connect to different databases, and which query to serve. 0.8.4 Dec 10, 02 * sdsql: recognizes default/default-t|f as default queries (form|table) * sdsql: uses default queries when cloning a table|form * sdsql: all children toplevel are destroyed when destroying a query * sdsql: added "SELECT DISTINCT" (using group by really) on single columns. It can also use filter conditions. * Fixed check on input that ignored decimals 0.8.0-2 Nov 25, 02 * support for mysql 0.7.18 nov 20, 02 * Added menu for select disting on a column * Added support for mysql: experimental * tksql: added option -p to pass password 0.7.17 nov 15, 02 * tksql: Added meny entry for quick DESC sort on fields * tksql: Fixed problem with sorting on fields with ASC|DESC 0.7.16 nov 14, 02 * fix so that 'today|now|yesterday'can be used again in filtering dates * fix in the parser to understand uppercase also * fix to work with tcl8.0.5 (reload worked just once) 0.7.15 oct 13, 02 * fixed reference to inexistant variable 0.7.14 oct 12, 02 * tksql: added manual page * improved look (popSql window doesn't change position at any query) * introduced query as detached/not detached view of a table (need more refining, when fields are not the same) 0.7.13 oct 11, 02 * sdtcl/tksql: added shortcut for dates in filter and queries, so that a query can now store information like @m that wil be expanded by tksql to date >= '1/10/02' and date <= '31/10/02'. The possibilities are many more that this, see in the manuals. * sdsql/tksql: added parsing of some error (es.: empty non null attr), to give a simpler error message * minor bug in creation of list for queries (wad added as attr_name) 0.7.12 Sep 4, 02 * sdtcl/tksql: minor bug fix that didn't transform correctly Number notation * sdsql/tksql: minor bug that didn't respect default of -mask 0 * sdsql/tksql: more intuitive behaviour og OK button while choosing fields * sdsql: other minor fix bugs * tksql: fix a typo that gave problems setting DateStyle * sdsql/tksql: now configuration files are only samples and do not overwrite previous files 0.7.11 Aug 7, 02 ** A lot of changes in the code ** * sdtcl: created a binding to move text around the widget (used by tksql, so arrange position of attributes in the layout) * sdsql/tksql: now you can use variable in layout * sdsql/tksql: improved graphics helps understand which action are available (hand cursor and color hilighting) * sdsql/tksql: much better handling of join of attributes, now everithing works as expected * sdsql/tksql: working with tables _and_ forms in the meantime uses the table to represent records from a filter operation instead of separate window * sdsql/tksql: now tries to fit width of columns * other minor bug fixes * some look staff has been segregated in a separate file look.tcl * more fixes to work also w/ older version of tcl/tk or postgresq 0.7.10 Aug 5, 02 * sdtcl: fixed a minor esthetical problem * sdsql/tksql: fixed a Check on input that prevented from writing into text fields * sdsql/tksql: default view set readable by 'all' * sdsql/tksql: no longer assuming default behaviour -mask 0 for queries 0.7.9 Aug 4, 02 * sdtcl: corrected pkg_mkIndex. Function where not found properly. 0.7.8 Aug 3, 02 * sdsql/tksql: fixed a bug trying to save queries (trying no longer existing 'order' clause) 0.7.7 Aug 3, 02 * sdtcl: look improvement (layout version 0.5) * sdsql/tksql: cleaner code (should be more robust eather) 0.7.6 Aug 3, 02 * sdsql/tksql: Fixed minor bugs and cleaner code * tksql: updated manual page 0.7.5 Aug 3, 02 * mainly internal changes to fix error while opening menus on query 0.7.4 Aug 2, 02 * sdtcl: restructured sd::Init so that defining defaults is cleaner * sdsql/tksql: fixed problems of variables not defined (qID and NumFmt) * sdsql/tksql: fixed a minor bug w/ queries and find * sdsql/tksql: fixed a missing order by in the stored select 0.7.3 Aug 1, 02 * sdsql/tksql: fixed a wrong referenc to a variable "mask" * tksql/sdsql: NumFmt: fixed a situation in which nummbers where not correctly converted * tksql/sdsql: CreateSqlStatement: fixed a situation in which I(NumFmt) was not used and repetition occurred * tksql/sdsql: fixed OK button of query layout * tksql/sdsql: fixed missing test on var existance 0.7.2 July 31, 02 * fixed edit sql query * fixed quote of where condition statement * menu w/ possibility to add a query in better position 0.7.1 July 30, 02 * sdsql queries: current_user() -> current_user (compatibility w/ versions of postgresql up to 7.1) 0.7.0 July 30, 02 * tksql/sdsql: queries have been added * number notation has been rationalized * tksql now can save defaults from a menu entry 0.6.0 June 1, 02 * tksql/sdsql: fix for postgreSQL 7.2 (pg_attributes table no longer has oid associated with them). Clearing of messages on Reload. * tksql: fixed handling of read-only option (-ro). 0.5.27 Oct 11, 01 * tksql/sdsql: no longer protecting names of columns when ordering or selecting: this was a bad implementation that had problems if in combination with functions. Now columns that have reserved keywords cannot be used in 'ORDER BY' or 'SELECT' (I had "dec"). 0.5.26 Oct 10, 01 * sdsql: Fixed a little bug while destroying the subtotal window * tksql: Set a default for the retrieved N. of rows * tksql: fixed a bug in sorting via the menu entry of the column 0.5.25 Oct 8, 01 * Really added the demo promised two hours ago... 0.5.24 Oct 8, 01 * sdsql: fixed a big mistake on error notification procedure * sdsql: added syntax TT=attr:40.5 to spec of an attribute. This forces the attribute to be shown in a textfield when in mask mode. (See demo) * sdsql: eliminated need to set setUp(USER) while using pg::exec 0.5.23 Oct 5, 01 * Added conf file that i forgot * tkspy: now it is possible to click on names of procs and see them on a separate window when browsing the code 0.5.22 Sep 30, 01 * tksql: fixed bug that prevented to add DESC to "order by" clause * tksql/sdtcl: sensitive to file setup w/ opt for European/US date convention * tksql: fixed a bug while grouping on column w/o values at first line 0.5.21 Sep 28, 01 * Added possibility to display subtotals in a different window (grately increases speed when there are a lot of lines/breaks) * Added possibility to subgroup using user-defined function, on type or name of attribute (functions on data already supplied), * Added Array to hold width of cols so that changing order of columns retains look properties * Fixed annoying bug w/ columns w/ forbidden names (es. "dec" w/ 7.1) 0.5.20 Sept 26, 01 * tksql: added possibility to compute subtotals. Slow if you have some 3-5000 lines on the screen w/ a lot of subtotal. * tksql: added easy way to sort query on one column * tksql: (fix) colum colors are refreshed at any reload of the database this forces resizing of columns, so it is questionable if it is correct 0.5.19 Sept 25, 01 * tksql: added possibility to sum values of one column (if int or float). The sum is placed at the bottom of the column. The sum is recalculated at any "reload". Using filter capabilities of tksql and sum toghether is really powerfull. * tksql: fixed info menu line (that did nothing) * tksql: added possibility to use defaults while filling in a line. Defaults can be written in the filter widget and get pasted automatically in the cell of the table when you pass trhought it w/ the cursor. * sdtcl: added more bindings to write german umlaut in entries (Ctrl-", followed by vowel) * demo: fixed example in validation procedures 0.5.18 July 9, 01 * tksql/sdsql: added search capability on the table. This is different from filtering since it does not issue any new query. Closer to the search you would do on a spreadsheet. You can limit the search to one column or to the entire table. A list of the matches will pop up to allow easy browsing throught them. * a man page in the unix style has been added 0.5.17 July 7, 01 * layout: fixed a wrong reference to an inexisten var. Only if you called sd::Table (error: can't read "t") * proc to change colors adapted to work also w/ 8.0+ 0.5.16 July 6, 01 * tksql/sdsql: fixed nasty color bug w/ tkTable 2.6 (active cell problem) * sdtcl: added possibility to interactively change color both in tktable tags and canvas objects/tags 0.5.15 July 2, 01 * tksql: added an option to send me bug reports * tksql/sdsql: improved handling of resizing of the widget (tktable) * install: now correctly installs also the scripts (not just the libraries...;-) 0.5.14 June 24, 01 * Sdsql: Fixed a bug introduced yesterday so that new fields could not be added w/ mask view 0.5.13 June 23, 01 * Sdsql: Improved handling of PRIMARY KEYS, now they are not mixed w/ unique not null keys * Sdsql: Cleaned up the code so that now you can cope w/ several connection to different databases in one application * install: removed useless reference to BLT package 0.5.12 June 6, 01. * Improved handling of PRIMARY KEYS when it is a combination of attributes: now uses that combination instead of oid, if possible. * Renaming of procs * Improved handling of two views in the meantime. Now you can change one attribute in the form and another in the table and updating is correct. 0.5.11 separated layout package (but still ships toghether) 0.5.10 sdsql/tksql: fixed a minor problem on invocation of validation from table view sdsql: improved use of validation commands 0.5.9 sdsql (tksql): fixed a problem when the unique attr is a composition of more that one attr. Now works turning to use oid instead. 0.5.8 sdsql: reload fixed problem introduced w/ 0.5.7. same for Update & delete 0.5.7 sdsql: fixed visualisation of data while editing a join w/o primary key (editing a join is anyhow partial, read docs) 0.5.6 tksql: added defaults and explanation, now reads .tksqlrc tksql: added menu to choose DateStyle 0.5.5 sdsql: fixed 'save as New' that did nothing 0.5.4 sdtcl: added feature in layout to refer to radiobuttons w/ same string and different variable sdtcl: fixed a problem with some fonts (padx message) 0.5.3 sdsql: improved Attribute Validation, now works correctly from both type of views. Added a doc on use of Validation Commands sdtcl: cleaned up the code a bit as far as return codes and _W array Added a doc on Variables in sdtcl 0.5.2 sdsql: Fixed contemporary use of TkTable and Mask improved use of arrays OLD/NEW so that all validationCommands work in the same way added Attribute Validation command also from mask (still under test) 0.5.1 Added documentation and examples sdsql: more colors in the tags of columns sdsql: added some info on attributes via (TkTable) tksql: added menu on <1> of table names 0.5 first public release