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

Archive