Jump to content

Kexi/Releases/Kexi 2.9.11

From KDE Community Wiki

List of changes

Featured story: A commercially developed upgrade for MS Access (MDB) Import to Kexi has been donated by Jarosław Staniek (wish 277583). This also fixes import of primary keys Bug #336560. Large Access databases such as the Northwind sample now import better than ever.

Main Window:

  • Make Global Search list should wider to fit the names Bug #358203.
  • Make the default "Smallest readable font" used by Kexi in property editor, toolbar, etc.; allow to specify size using points; no longer depend on screen resolution Bug #358662.

Tables:

  • Do not switch to Data View if fetching records failed, and show more clear message. This fixes crash at the attempt to create a table row when table is invalid due to use of a reserved word or failed data fetching Bug #356888 and Bug #357025. The same category of errors are now also fixed for queries, forms, reports, and CSV export.
  • Fix alignment of table view combo boxes when rows or columns are scrolled Bug #357655.
  • Make combo box popups for tabular view fit in the current screen Bug #357682.

Queries:

  • Switching off the visibility of query fields no longer hides data in the last field. This is a fix for SQLite, MySQL, PostreSQL, Sybase/MSSQL Bug #346839.
  • Fix possible crash due to missing removal of cached field information.
  • Support queries having the same field name used in multiple tables Bug #340056.
  • Make "Save button" enabled when going from SQL view to Data and back to SQL Bug #278379.
  • Fix: Changes in query design not retained after changes in SQL view and switching to Data view Bug #358413.
  • Make <SELECT "a" + "b"> SQL queries work; also for convenience if either argument is of text type, operator "+" is now assumed to be identical to operator "||"; also fix <SELECT "a" || "b"> for MySQL using CONCAT() Bug #358636.
  • Better check result of parsing SQL statements.
  • Make query parameters also work in COLUMNS section, e.g. <SELECT [Param]> works now Bug #348473.
  • Fix switching to Data View when using table aliases Bug #278414.

Forms:

  • Add sorting to Forms. Current record is unchanged but its index most likely changes, what can be observed in the record navigator Bug #150372.

Reports:

  • Fix retrieval of aggregate report values for queries: fix possible crash when changing data source, support tables and queries having the same names, better recognize if report was modified (reviews D764 and D765).
  • Fix handling latitude property for scripting in Report Map element.
  • Fix possible memory leaks (review D780).
  • Allow jump to report page Bug #357217.
Retrieved from "https://community.kde.org/index.php?title=Kexi/Releases/Kexi_2.9.11&oldid=102292"