View source for Kexi/Releases/1.1.2 Changes

KEXI is a visual database apps builder, developed since 2002.

< Back to [[../1|KEXI 1 Releases]]
===Main Window===
* command line option "--show-navigator" added - shows the Project Navigator side pane even if Kexi runs in User Mode
* project manager: double/single clicking on executable objects (macro, script) executes them

===Database Support Library (KexiDB)===
* projects created with older Kexi versions can be now opened in read-only mode too
* fixed possible crash when running a query without primary key included (encountered e.g. when a form contain static images)
* queries are supported as row source for look-up fields
* added support for multiple visible columns in look-up fields
* improved saving table extended schema data for look-up fields
* sort query results by primary key fields if there is no explicit sorting specified (especially useful when there are complex joins)
* install all needed headers
* fixed problem with constructing SQL statements: for multi-table queries "ORDER BY column" prepends "table" only if "column" is not a name of alias

===Widgets, Utilities===
* queries are supported as row source for look-up fields
* fixed crash related to QtCurve widget style (bug 139753)
* use transliteration table generated by a shell script to generate identifiers out of Unicode characters (bug 133170)

===Table Designer===
* fixed altering table schema when look-up column has been changed
* added support for multiple visible columns in the combo box editor (the same for forms)
* on altering table, remove old lookup field schema objects and make sure you do not save empty type/name fields to XML
* fixed updating "lookup column" tab's contents
* fixed crash on saving design with lookup columns defined
* fixed updating default value when field type changes

===Query Designer===
* fixed crash if column being removed has sorting set up
* display "(All Columns)" near the "*"
* SQL editor on Unix: initially, clear undo/redo buffer (otherwise Ctrl+Z clears the contents)

===Forms===
* fixed handling "align" property for image boxes when scaling is off
* align autofield's label to left if it is on the top
* do not show pop-up after clicking on combo box
* fixed popup position of combo boxes inside a container
* fixed saving property values of type "enum" for subwidgets
* "Assign Action" dialog:
** added "create new" and "close view" actions with a given context
** "Current form" actions category added with actions like "go to next record", "go to new record"
** more design actions like "undo" moved to the global category
** the list of menu commands now contains tooltips instead of action texts to improve readability and is displayed with full width
** actions are now categorised, so actions that have no practical use are hidden
** moved "Macros" and "Scriptsv to "category" list, which also supports opening tables/queries/forms, running macros/scripts
** added "Action type" column so it is possible to assign printing and opening in objects design view
** added "Execute form's action" category

===Tools===
* fixes for "Add column" tool
* added "Delete column" tool

===Project Migration===
* fixed copying existing objects to the destination database
* MySQL and PostgreSQL:
** fixed importing Unicode text and static images if present in the source database (BLOBs)
** data types are better handled for import

[https://web.archive.org/web/20070823004439/http://www.koffice.org/announcements/changelog-1.6.2.php#kexi Archive]