Kexi/Releases/1.1.2 Changes
KEXI is a visual database apps builder, developed since 2002.
< Back to 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