Lianja SQL Server Changelog

What's new in Lianja SQL Server 9.6.3

Apr 29, 2024
  • Performance and stability improvements.
  • Fix various reported tickets.

New in Lianja SQL Server 9.5.19 (Apr 16, 2024)

  • Fix reported bugs.

New in Lianja SQL Server 9.4.25 (Jan 25, 2024)

  • Fix reported bugs.

New in Lianja SQL Server 9.4.22 (Jan 11, 2024)

  • Fix reported bugs.

New in Lianja SQL Server 9.4.19 (Dec 21, 2023)

  • Fix reported bugs.

New in Lianja SQL Server 9.4.14 (Dec 4, 2023)

  • Fix reported bugs.

New in Lianja SQL Server 9.4.10 (Nov 28, 2023)

  • Fix reported bugs.

New in Lianja SQL Server 9.4.9 (Nov 23, 2023)

  • Fix reported bugs.

New in Lianja SQL Server 9.4.6 (Nov 9, 2023)

  • Fix reported bugs.

New in Lianja SQL Server 9.3.3 (Sep 29, 2023)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 9.2.6 (Sep 18, 2023)

  • Performance improvements.
  • Bug fixes.

New in Lianja SQL Server 9.2.5 (Sep 14, 2023)

  • Performance improvements.
  • Bug fixes.

New in Lianja SQL Server 9.2.4 (Sep 11, 2023)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 9.2.3 (Aug 30, 2023)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 9.2.2 (Aug 23, 2023)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 9.1.15 (Aug 11, 2023)

  • Bug fixes

New in Lianja SQL Server 9.1.14 (Aug 10, 2023)

  • Bug fixes

New in Lianja SQL Server 9.1.12 (Aug 9, 2023)

  • New dialogbuttonmenu attribute and delegate in desktop, web and mobile.
  • Minor UI improvements.
  • Bug fixes and performance improvements.

New in Lianja SQL Server 9.1.11 (Aug 4, 2023)

  • Bug fixes.

New in Lianja SQL Server 9.1.10 (Jul 27, 2023)

  • Minor UI improvements.
  • Bug fixes and performance improvements.

New in Lianja SQL Server 9.1.9 (Jul 25, 2023)

  • Bug fixes

New in Lianja SQL Server 9.1.8 (Jul 20, 2023)

  • Improved OLEDB Virtual Table support.
  • Performance and stability improvements.
  • Various bug fixes.

New in Lianja SQL Server 9.1.7 (Jul 17, 2023)

  • Minor UI improvements.
  • Performance and stability improvements.
  • Various bug fixes.

New in Lianja SQL Server 9.1.5 (Jul 11, 2023)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 9.0.27 (May 25, 2023)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 9.0.26 (May 24, 2023)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 9.0.20 (May 11, 2023)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 9.0.19 (May 10, 2023)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 9.0.18 (May 10, 2023)

  • Performance and stability improvements.
  • Fix various reported tickets.

New in Lianja SQL Server 9.0.17 (May 3, 2023)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 8.0 (Nov 17, 2022)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 7.1 (Mar 9, 2022)

  • Report Builder Improvements:
  • New report delegates:
  • Row Renderer
  • Before Row
  • After Row
  • Text Translator
  • Improved report print layout engine.
  • Corrected report chart printing.
  • Added 'Pagebreak After Summary' checkbox to Grouping settings.
  • Added 'Page Left Margin' and 'Page Right Margin' to Page Layout settings.
  • Added 'Page Orientation' combobox to Page Layout settings: Portrait or Landscape.
  • Drag and drop of columns to reorder them.
  • New 'Backup' and 'Restore' Report Builder toolbuttons. Keep versions of your reports as you design them. Roll changes back at any time.
  • New Page Layout Custom Options.
  • Group summary now also supports count to display number of rows in the group.
  • Various bug fixes.
  • New system object methods to simplify report printing and viewing:
  • Lianja.showReportViewer(cReportName [, cOptions])
  • Lianja.printReport(cReportName [, cOptions])
  • Lianja.printHtml(cHtml [, cFilename [, cOptions]])
  • Script Editor Improvements:
  • Improvements to search operations in the Script Editor:
  • Added 'Find Next' keyboard shortcut: Ctrl + . (>).
  • Added 'Find Previous' keyboard shortcut: Ctrl + , (<).
  • Added a Search Bar which searches across all files in the App of Library. Just type text and press return
  • WebView Enhancements:
  • Improved printPreview() method behavior.
  • Added printHtml() method. Use this with WebViews to create custom designed content that you print, e.g. labels with barcodes.
  • ImageStrip Enhancements:
  • New improvements to the functionality of ImageStrip Sections.
  • New example_imagestrip demo App included in the Lianja App Builder distribution.
  • New Image viewer to show a larger version of the selected image.
  • One-click/touch access to the image notes editor.
  • One-click/touch access to add or delete images.
  • Additional Improvements:
  • Added a new system table sysfiles: select * from sysfiles where filename == 'pattern' [into cursor yourfiles]. This fills a cursor with details of all the matching files in the current directory. It is particularly useful if you have tens of thousands of files to process and it is impractical to load their details into an array in memory.
  • Added an additional parameter to keyLookup(). If set to true and the keylookup table was not open, it is left open after the first call to improve performance.
  • Lianja packages can now include huge files greater than 1GB. This provides the ability to deploy huge databases in packages.
  • The section Before Data Update event delegate can now cause the update to be cancelled when its return value is false. It can include custom validation with Lianja.showErrorMessage() used to provide user feedback.
  • Added a new Virtual Table property to handle character mapping between utf-8 and locale specific encoding for use with the VFP OLEDB driver, e.g. codec=windows-1252. See here for supported codepage values.
  • VFP OLEDB Virtual Table performance improvements.
  • Improved memory management.
  • Performance and stability improvements.
  • Various bug fixes.

New in Lianja SQL Server 7.0 (Feb 3, 2022)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 6.3.1 (Dec 13, 2021)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 6.3 (Dec 10, 2021)

  • Performance improvements
  • Bug fixes

New in Lianja SQL Server 6.2.0 (Jul 7, 2021)

  • Significant performance improvements
  • Bug fixes

New in Lianja SQL Server 5.5.1 (Nov 16, 2020)

  • Performance and stability improvements.
  • Fix reported bugs

New in Lianja SQL Server 5.5.0 (Nov 13, 2020)

  • Performance and stability improvements.
  • Fix reported bugs.

New in Lianja SQL Server 5.4.0 (Oct 8, 2020)

  • The Cloud server now handles Progressive Web Apps.
  • The Cloud Server App Center can now be installed as an icon on desktop and mobile home screens.
  • The login page now provides the ability to:
  • Change your password
  • Forgot your password?
  • Forgot your username?
  • Performance and stability improvements.
  • Fixed various reported tickets.

New in Lianja SQL Server 5.3.2 (Aug 20, 2020)

  • Performance and stability improvements.
  • Fix reported bugs.

New in Lianja SQL Server 4.1.0 (Apr 20, 2018)

  • Performance and stability improvements.
  • Fix reported bugs.

New in Lianja SQL Server 4.0.0 (Aug 31, 2017)

  • Available for all operating systems; Windows, Linux and MacOS
  • Performance and stability improvements.
  • Fixed various bugs from reported tickets.

New in Lianja SQL Server 3.4.0 (Apr 26, 2017)

  • The version 3.4 release will include:
  • Performance and stability improvements.
  • Fixed various bugs from reported tickets.

New in Lianja SQL Server 3.3.0 (Feb 16, 2017)

  • Performance and stability improvements.
  • Fixed various bugs from reported tickets.

New in Lianja SQL Server 3.2.0 (Feb 9, 2017)

  • Performance and stability improvements.
  • Fixed various bugs from reported tickets.

New in Lianja SQL Server 3.0 (Aug 15, 2016)

  • Major SQL SELECT performance improvements.
  • Performance and stability improvements.
  • Fix reported bugs.

New in Lianja SQL Server 2.0 (Aug 15, 2016)

  • ODBC Driver improvements
  • Fixed an issue which affected SMARTQUERY caching
  • Performance improvements
  • SQL optimizer improvements
  • JQL/JSON extensions
  • Fix reported bugs.

New in Lianja SQL Server 1.5 (Aug 15, 2016)

  • Performance and stability improvements.
  • Fixed various bugs from reported tickets.

New in Lianja SQL Server 1.1.2 (May 13, 2014)

  • Fixed various bugs from reported tickets.

New in Lianja SQL Server 1.1.1 (May 13, 2014)

  • Fixed various bugs from reported tickets.

New in Lianja SQL Server 1.0.0 RC2 (Feb 22, 2013)

  • Fixed an issue when calling stored procedures not looking in the database container directory.
  • Fixed an issue accessing varchar fields using the Lianja ODBC Driver from third party products.
  • Fix various reported bugs.

New in Lianja SQL Server 1.0.0 RC1 (Feb 22, 2013)

  • Lianja SQL Server for Windows.
  • ODBC driver for the Lianja SQL Server.
  • Ability to write stored procedures in the Lianja/Visual FoxPro scripting language.