Kexi/Releases/1.1.2 Changes

From KDE Community Wiki
< Kexi‎ | Releases

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

Retrieved from "https://community.kde.org/index.php?title=Kexi/Releases/1.1.2_Changes&oldid=102263"