Lianja 9.9.21 pre-release

[barrymavin]

I have uploaded 9.9.21 pre-release into the beta directories for those with premium support and others who have access to this.

• New: Build/Run Linux standalone Apps is now supported in the same way as Windows standalone Apps.
• New: Build/Run standalone App icon added to the workspace header icons.
• Enhanced: The Calendar section to filter by resource/eventtype/week/month/year.
• New: Ability to customize the Calendar section "List" View by specifying a custom HTML renderer delegate (an .rsp file).
• Critical: fixed a bug in intellisense that could cause the App builder to lock up.
• Enhanced: the Assistant to allow editing page and section CSS style files.
• Improved desktop grid editing experience.
  - When editing a split grid "Close editor after editing" causes the grid view to be reinstated after "Double click to edit".
  - Columns can be unchecked "Visible when editing" so that they cannot be edited.
• Enhanced: OLEDB connection strings in a Virtual Table definition can now contain {} macros e.g. {getenv("HOMEDRIVE")+getenv("HOMEDIR")}
• Enhanced Standalone Apps can now include customization of the login screen by specifying an app.conf file in the App directory.
  - See the doc.
• Critical fixed a crash in the Lianja ODBC driver when specifying a directory rather than a database.
• Improved grid section building experience with drag'n drop and column re-ordering improvements. Instant feedback from attribute changes when in split screen editing view.
• Enhanced. Grid section.
  - beforesave delegate (return false causes the changes to be discarded)
  - aftersave delegate
  - Improved validation checks when attempting to navigate off a row in the grid to another while editing.
  - ValidWhen delegate is now called during a grid save operation. Return false to reject the save.
  - Improved split grid editing experience in Web/mobile apps. Input fields are highlighted when validation fails.
  - Much improved data entry.
  - "Mandatory" added to grid column attributes. This is inherited from the data dictionary business rules also.
  - Improved support for right-click context menus in grids.
• New. App settings atribute
  - "Ask to save" (default false). This displays a dialog allowing a user to save/cancel edits when navigating between records and/or pages.
• New. Section attribute and Grid attribute.
  - modified, this returns true if data in the section has been modified interactively by a user.
• Enhanced. Section delegates
  - Activate and deactivate delegates are now called when a section is selected/deselected. Note that these are only called in desktop runtime mode.
• New Lianja/SQL now supports MSSQL SELECT ... OFFSET ... FETCH syntax.
• Improved CSS editing.
• Improved editing of section menus and section footer menus.
• Enhanced. Added more attributes to the Assistant to speed up development.
• Improved. The App Inspector now maintains the scrollbar position when changing attributes to speed up development.
• Improved Imported VFP forms support.
• Improved. CSS selectors in the CSSLibs for an App can now contain .classname and #selectorname to simplify use across desktop and Web/Mobile.
• Improved. The Footer Button CSS can now have handle the CSS for each button in a footer menu. Separate each CSS style for the button with a | (vertical bar) character.
• Improved Further improvements to Csslibs in an App for better CSS customization of the UI.
  See https://www.lianja.com/community/sho...n-without-text
• Improved running of VFP .scx files. If these have not yet been imported (.scp does not exist), they are now auto-imported on-the-fly. Any .vcx files references are also auto-imported.
• Improved VFP importers for scx and vcx files.
• Minor UI improvements.
• Bug fixes and performance improvements