Fixes

• Layout: Fixed Gear, Lookup, Max positioning.
• Button: Fixed expression based (e.g. %username%) button visibility.

Fixes

• Config: Fixed handling of invalid config that could block dbFront access.
• 1-1: Fixed loading 1-1 rel forms on first table row.
• 1-1: Fixed reloading 1-1 rel forms after parent save.
• Config: Corrected grid config error message to provide correct error source.
• Editing: Fixed editing child records where the FK is not contained in the PK and not visible.
• GridEditing: Fixed errors when lookup field in grid but not form.
• Import: Fixed ability to apply table views on import.
• MySql: Fix to correct or discard invalid relationships.
• WebClient: Better error handling on invalid lookups.
• MySQL: Fallback if driver doesn't support .BeginTransaction(IsolationLevel).

Features

• Decimals: Improved Decimal handling and the ability to set Decimal rounding.
• Licensing: Removed the View Limit for PRO licenses.
• Search: Added admin setting (FullLikeRowLimit) to set max table size for full-like searches.
• Search: Improved composite searches covering both regular and full-text indexes.
• Search: Improved handling of quoted keywords.
• Structure: Prompt for page refresh if structure changes are detected.

Fixes

• BigInteger: Fixed handling of very large integer values (database driver limitation).
• IE: Fixed IE-11 error when resizing grid and details.
• Insert: Fixed Insert not finding new record due to a complex key and use of view fields.
• Structure: Fixed regression with some column renames not correctly updating after a structure change.
• SQL: More concise SQL queries by reusing parameters.
• Menu: Improved error handling around Menu issues.
• MySql: Fixed Full-Text search regression.
• Stability: Improved null handling due to code review.
• Sessions: Fixed a regression that prevented session errors from opening the login dialog.
• Numeric: Fixed a regression that broke the ability to update a null numeric value.

Features

• ProfileFields: Use Profile fields in Button or Layout visibility expressions.
• Reseller: Support reseller integration.
• UrlField: Optionally display Url field as inline iFrame or Image.
• UrlField: Optionally display Url field as Link.
• Fulltext: Added support for Full-Text indexes to dbFront.
• Fulltext: Default includes basic Stem searching similar to the LIKE "word%"
• MySQL: Support: "Default", "Boolean", "Natural Language" and "Query Expansion" Full-Text Search.
• Oracle: Support: "Default" and "Contains" Oracle Text Search.
• SQL Server: Support: "Default", "Contains" and "FreeText" Full-Text Search.
• StoredProcedure: Updated OpenTable to add Target option [Redirect, NewTab, Dialog].
• StoredProcedure: Added OpenUrl option to ServerRequest.
• Caching: Ability to disable internal caching for externally updated tables.
• GridEditing: Optionally allow Grid changes to save immediately to the database.
• GridEditing: Use db prefs to mark GridEditing as [Disabled, SaveToCache, or SaveToDatabase].
• GridEditing: Optionally mark individual Grid fields as [Default, ReadOnly, or Editable].

Fixes

• BarCodeField: Fixed ability to change field layout.
• SQL Server: Fix handling of boolean procedure parameters.
• Visibility: Improved expression error handling.
• Config: Prevent usage of localhost as the authentication server name.
• Groups: Fixed so that mixed case search of groups works consistently.
• Locking: Ensure that all empty queries for SQLServer/MySQL structure are run as "ReadUncommitted" to avoid unnecessary locks. Oracle does not support "ReadUncommitted".
• UI: Ensure that the field class is also applied to text editors.
• Attachment: Ensure Attachments are still visible even if not configured.
• Data: Improved handling of excessively long integer values.
• DateTime: Improved DateTime recognition.
• Filtering: Fixed filtering logic when both Advanced and Simple search used together.
• FullText: Correctly Quote and Alias fields.
• Indexes: Error Handling around missing fields.
• Indexes: Fixed handling of non-unique index names (MySQL and Oracle).
• Oracle: Updated Oracle-Text index detection.
• Oracle: Fixed Default Oracle-Text Search logic.
• SQLServer: Correctly display 2019 compatibility mode.
• SQLServer: Fixed formatting of default FullText Search for prefixes.
• Editing: Require a saved parent record before allowing child edits.
• Visibility: Ensure that visibility expressions are case insensitive.
• UI: CSS fixes to cleanup field selection config UI.
• UI: Fixed About dialog so it correctly links to the ReleaseHistory.
• GridEditing: Fix JSON errors on readonly lookup columns.
• QueryCache: Parameterize the paging values to improve QueryCache usage.
• SQLServer: Use fixed parameter sizes to improve QueryCache usage.
• Performance: Cache filtered rowcounts for 3 minutes or until change.
• Performance: Simplify filtered rowcount queries and remove unnecessary joins.
• Caching: Correctly cache both active and unused Profiles.
• Caching: Fix excessive database requests for profile when caching disabled.
• DateField: Set FirstDayOfWeek based on System configuration. Q&A
• Reporting: Fixed child field data selection if a Child PK was used.
• Excel: Fixed server formatted numeric columns in Excel exports.
• Reporting: Fixed child column data in both Multiline and SingleRow reports.