Release Summary

6 new fixes

• BigInteger: Fixed large integer handling.
• CSS: Fixed Busy Icon not showing up on Flattened Themes.
• IE: Fixed IE-11 Logout dialog issue.
• Lookups: Fixed ability to Export/Import the Lookup Filter.
• Lookups: ForceServerLookup if either the Lookup Filter or Row Select Security is user-dependent.
• Time: Fixed errors when handling some time fields.

14 new fixes

• 1-1: Fixed row count on 1-1 tabs when empty.
• 1-1: Load 1-1 child rows from bookmarks and deep links. See: DeepLinking
• Bookmarks: Fix issues loading records from a bookmark.
• Bookmarks: Handle bookmarks that need extra data for child tables.
• Caching: Ensure that a structure change clears cached lookups.
• ChildTables: Fixed join failures when related to a field other than a primary key.
• ChildTables: Fixes to correctly load child tables.
• IE11: Improved support.
• Logging: Corrected resource locking which prevented flushing the logfile.
• Logging: Log warnings when encountering invalid config.
• Lookups: Handle data in lookups with nullable/empty unique keys.
• RowSave: Save empty values as empty strings on non-nullable columns instead of Null.
• Url: Clean up HASH portion of URL
• Views: Fixed ability to save a renamed view.

1 new fix

• Attachment: Fix "RowHash not set" regression when attempting to upload a file.

13 new features

• AdvancedSearch: Extended the length of the search field from 50 to 200. Q&A
• CustomSearch: Ability to set constant values and ranges or NULL.
• CustomSearch: Added "Custom Search" action buttons. Q&A
• CustomSearch: Includes support for Prompt Fields and optional Range Fields. Q&A
• CustomSearch: Includes support for Search SQL Expressions. Q&A
• CustomSearch: Optionally, Clear, Overwrite or Merge with Advanced Search.
• CustomSearch: Users can create/edit their own search buttons.
• Layout: Added "TableOnly" layout. Currently requires disabling insert. Q&A
• MassUpdate/Delete: Updated to handle search filters based on Filter Buttons.
• MassUpdate/Delete: Updated to handle search filters based on Related Views.
• SystemMonitor: Rebuilt IP based activity monitoring and layout.
• Table: Added ability to set 'Sticky' table columns that remain on screen. Q&A
• WebRequest: Added option to call Stored Procedure to process the results. Q&A

48 new fixes

• Access: Ignore access errors to databases not requested by the current user.
• AdvancedSearch: Fixed oversized search keywords breaking the layout.
• Attachments: Automatically handle PDF files migrated from Sharepoint. Q&A
• Buttons: ButtonAccess(visibility) fixed to be more consistent and logical.
• Buttons: ButtonAccess(visibility) fixed to enable on readonly records.
• Buttons: Fixed "Overrides Access" to allow override of row-level security.
• Buttons: Fixed handling of read-only dialog fields where the form was editable.
• Buttons: Fixes to handling of non-default read-only fields.
• Buttons: Improved handling of existing changes when a Action Button is pressed.
• Buttons: Updates to Config UI for WebRequest with Procedure.
• Caching: Removed Cache trimming since it was causing more issues.
• ClientErrors: Log client browser type/version.
• Config: Fixed XML error loading config from cache.
• Cookies: Compress and encrypt the Json cookies
• Core: Fixed ability to overwrite invalid config..
• Core: Improved Null handling.
• Core: Reject field/object names that are only numeric.
• Core: Upgraded to jQuery 3.6.2 from 3.4.1.
• CustomSearch: Fixed use of Lookup fields as custom search parameters.
• CustomView: Fixed the issue with the "My Layout" not saving.
• ExcelExport: Fixed null handling.
• ExcelExport: Improved automatic type handling, including images.
• Focus: Fixes to improve the focus shift to the form on row click.
• Focus: Updated to set the focus to QuickSearch if no active form.
• FormCache: Fixed handling of new records on refresh.
• Help: Added help text to "My Layout" button.
• Help: Trimmed Informational Fields.
• Home: Added classes to HTML to allow for better styling.
• Import: Trim input and lookup values.
• Layout: Added a CSS class and set default styling to mark My Layout. Q&A
• Licensing: Ensure critical License/Version errors are not hidden for SSO users.
• Licensing: Fixed handling and reporting of Support Expiry.
• LogOut: Added a confirmation before logout. Q&A
• LogViewer: Minor layout fixes.
• NoPK: Fixed delete/update row security on tables without a PK.
• NoPK: Optional ability to update duplicate records using RowLimit.
• OpenUrl: Fixed handling of complex URLs that appeared to include parameters.
• Report: Extended automatic field rename handling to reports. Q&A
• SMTP/WebRequest: Support all system available SSL protocols. (e.g. TLS 1.3, +)
• SQLServer: Fixed handling of new rows when PK is generated type of numeric(x).
• Table: Any change to the table config now automatically reloads the screen.
• Table: Updated "No matching row found" to "No single matching row found". Q&A
• TableOnly: Fixed TableOnly layout for child tables.
• UI: Fixed FireFox error triggered by the updated jQuery libraries.
• UI: Fixed issues where Form would revert to a New record after update.
• UI: Improved Refresh Handling for both the Form and Table.
• UI: Upgraded to jQueryUI 1.13.2 from 1.12.1.
• URL: When deep-linking dbFront will use the best connection for the user/database/table.

15 new features

• CrystalReports: Able to return multiple types: csv, doc, pdf, rtf, tsv, xls.
• CrystalReports: Added the ability to run Crystal Reports. See: CrystalReports
• CrystalReports: Optionally print Crystal Reports to a Server Printer.
• Excel: Updated OpenXml.
• GridEdit: The RowCSS now immediately refreshes with grid data changes.
• LDAP: Added ability to set LDAP filter for ADFS. Q&A
• OpenURL: Allow "file://c:\filepath\file.pdf" to resolve to a Local Download. Q&A
• OpenURL: Local Download limited to specific "safe" file types.
• OpenURL: Settings configure Allowed Local FilePaths. e.g. c:\filepath\*.pdf
• Oracle: Updated Oracle.ManagedDataAccess.
• Settings: Optionally block the ability to export/import data from the Admin database screen. Q&A
• Table: TableHeaders will float above the data when the page is scrolled down.
• TableTabs: Child Tabs now show a row count for 1-1 relationships. Q&A
• TableTabs: Child Tabs now show a row count for 1-M relationships. Q&A
• Themes: Added a clean/flat version of standard themes by clearing background images.

27 new fixes

• Button: Fixed expression based (e.g. %username%) button visibility.
• Cleanup the error messages by stripping duplication.
• CrystalReports: Additional CrystalReportHelper Param Help.
• CrystalReports: Deeper logging.
• CrystalReports: Extended Credential Logging and Help.
• CrystalReports: Fixed ability to allow user report destination selection.
• CrystalReports: Warn of invalid extensions.
• Debug: Extra error detail when rendering table properties.
• Debug: Include ServerKey in connection dialog.
• Fixed invalid error when checking RunProcedure arguments.
• FollowMeHelp: Fix the FollowMeHelp in tables.
• GridCSS: Fixed issue accessing empty CSS values.
• HomeScreen: Added FollowMeHelp.
• Layout: Fixed gear-icon positioning. Q&A
• Layout: Fixed lookup button sizing.
• LogViewer: Corrected error classification.
• LogViewer: Fixed issue of Login Screen not appearing after session expiry.
• Lookups: Fixed handling of renamed lookup display and sort columns. Q&A
• MySql: Fixed FullText search when using multiple or non-matching indexes.
• OpenURL: Ensure local download errors do not reveal the full file path.
• OpenURL: Fixed write access requirement for download files.
• ProfileFields: Fixed issues loading correct profile field values in HomeScreen.
• PromptFields: Fixed issue saving non-passthrough prompt fields.
• Select: Fixed issues with selecting a required config item.
• Settings: Fixed handling of empty LdapFilter.
• Settings: Improved LDAP Filter validation.
• Templates: Added main title text-shadow to ensure visibility on some templates.

24 new features

• CSS/Column: Assign a Field's CSS class to its grid column for column-specific layout. Q&A
• CSS/Grid: Support multiple pipe | separated, CSS class names. See: Table-Row-Styling
• GridEditing: Added support for GridEditing on tables with Row Security.
• HomeScreen: Expand profile expressions in the content HTML.
• HomeScreen: Improved Default.
• HomeScreen: List selected action buttons as reports.
• HomeScreen: List selected action buttons that don't require an active record.
• HomeScreen: List selected multi-row reports.
• HomeScreen: List selected tables.
• HomeScreen: New database home screen with a menu item and customizable title and content.
• HomeScreen: Now supports {%DatabaseCaption%},{%TableCaption%},{%LogoUri%},{%InspirationalQuote%}
• HomeScreen: Respect visibility expressions on action buttons.
• HomeScreen: Sanitize the home screen HTML when saving.
• Menu: Optionally move the Database menu into the home screen.
• MyLayout: Add ability to manage Custom Layout access.
• MyLayout: Allow users to create/edit their own version of a table's layout. Q&A
• MyLayout: Users can easily switch between the default and custom layouts.
• OpenURL/WebGet: Added option to load a table field from an external URL. See: WebGet
• PageFooter: Now supports {%DatabaseCaption%},{%TableCaption%},{%LogoUri%},{%InspirationalQuote%}
• System: The site warning or error can now be discarded. Still visible in the System Monitor.
• WebGet: Optionally parse JSON requests using JsonPath. See: WebGet
• WebGet: Optionally parse XML requests using XPath. See: WebGet
• WebGet: WebGet is now a firstclass button type. See: WebGet
• WebRequest: Renamed WebGet to WebRequest.

47 new fixes

• 1-1: Fixed loading 1-1 rel forms on first table row.
• 1-1: Fixed reloading 1-1 rel forms after parent save.
• Advanced: Debug Mode now provides advanced Server/Driver details.
• Advanced: Moved Server/Driver information below databases + improved layout.
• CSS/Field: Fixed message returned if invalid characters were entered for the CSS class.
• Config: Corrected config error messages to provide correct detail.
• Config: Corrected grid config error message to provide correct error source.
• Config: Fixed detection of new columns and placement on Forms (AppendToForm).
• Config: Fixed handling of invalid config that could block dbFront access.
• Debugging: Improved internal monitoring and logging.
• Dialogues: Standardize button order on dialogs.
• Dropdowns: Removed ">None<" option from required lookups.
• Editing: Fixed editing child records where the FK is not contained in the PK and not visible.
• Editing: Fixed editing child records where the FK was not contained in the PK and not visible.
• Expressions: Fixed testing of SQL expressions when the PK can't be compared with "0".
• FieldGroup: Fixed layout issue where extra-wide Lookup or Multi-Select fields could mess up the layout.
• FieldGroup: Fixed support for Multi-Select fields.
• GridEditing: Fixed errors when lookup field in grid but not form.
• Html: Fixed Custom Html formatting.
• Html: Updated HTML validation on help and template fields.
• Html: Updated the internal HTML parser/sanitizer/formatter.
• Import: Fixed ability to apply table views on import.
• Import: Include SQL for GRANTs with table creation.
• Import: Skip creation of relationships for missing objects.
• Layout: Fixed extra space above table when table-beside-detail was collapsed.
• License: Fixed Prompt for the license if invalid or expired.
• Lookup: Remove invalid sort fields and warnings from the multi-select config dialog.
• Menu: Fixed responsive main menu.
• MultiSelect: Improved warning about non-defaulted required attribute fields.
• MySQL: Fallback if driver doesn't support .BeginTransaction(IsolationLevel)
• MySql: Fix to correct or discard invalid relationships.
• MySql: Fix to correct or discard invalid relationships.
• MySql: Fixed FullText search when using multiple or non-matching indexes.
• Numeric: Fixed ability to update a null numeric value.
• OpenUrl: Fixed ability to open URLs on read-only records.
• Oracle: Added lock around loading of defaults.
• PDFForm: Fixed ability to create PDFs on read-only records.
• SQLServer: Fixed calculated columns detection.
• Search: Skip searching columns for numeric values that don't fit.
• SingleSignOn: Update URLs containing "@HASH@" to "#" and redirect to handle URL fragments lost due to SSO redirect.
• System: Fixed layout issues with the site messages.
• TableGrid: Added DIV around Table Grid to enable the configured CSS class name.
• TableGrid: Show a loading dialog if a grid takes longer the 1/2 a second to load, also applies to search.
• Update: Fixed ability to update rows on tables without a PK and containing a calculate column.
• WebClient: Better error handling on invalid lookups.
• WebClient: Improved error handling and logging to server.
• WebUI: Fixed Heading on Collapsible Groups

10 new features

• Decimals: Improved Decimal handling and ability to set Decimal rounding. Q&A
• Licensing: Alternate License codes to accommodate ComponentSource & FastSpring.
• Licensing: FREE license limited to 3 users with referrals to add more. See: Referrals
• Licensing: Removed the Object Limit for FREE licenses.
• Licensing: Removed the View Limit for FREE licenses.
• Licensing: Removed the View Limit for PRO licenses.
• Search: Add admin setting (FullLikeRowLimit) to set max table size for full-like searches. e.g. '%value%'. Q&A
• Search: Improved composite searches covering both regular and fulltext indexes.
• Search: Improved handling of quoted keywords.
• Structure: Prompt for page refresh if structure changes are detected.

11 new 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.
• Licensing: Corrected application of FREE license.
• Menu: Improved error handling around Menu issues.
• MySql: Fixed Full-Text search regression.
• Numeric: Fixed a regression that broke the ability to update a null numeric value.
• SQL: More concise SQL queries by reusing parameters.
• Sessions: Fixed a regression that prevented session errors from opening the login dialog.
• Stability: Improved null handling due to code review.
• Structure: Fixed regression with some column renames not correctly updating after a structure change.

15 new features

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

33 new fixes

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

9 new features

• ConfigBackup: Ability to export obfuscated data. Q&A
• ConfigBackup: Ability to export selected tables. Q&A
• Header: Add profile fields to the Site Header HTML. e.g. {profile[FieldName]}
• Help: Set a HelpURL for each table allowing custom external sidebar help.
• Import: Allow data import from Excel(xlsx) files.
• LogViewer: Oversized logfiles now truncated to the last 5000 lines.
• RunProcedure: Optionally create a Export (csv, xlsx) from Stored Procedures.
• RunProcedure: Optionally print/download a Quick Report from Stored Procedures. Q&A
• UI: Any configured database logos will appear in the user menu.

15 new fixes

• ActionButton: Allow Buttons with PassThrough fields on read-only records.
• MassUpdate: Fixed layout issue.
• Menu: Tables are now sorted by Caption instead of by name.
• MimeType: Fixed detection of tiny inputs.
• Report/Export: Improved handling of Blob objects that are not images.
• Reporting: Fixed CSV export bug.
• Reporting: Fixed PrinterName selection on multiple output types.
• Search: Search performance improvements on large tables
• Security: Log if users without a SAMAccountName are found.
• Settings: Ensure that fresh setting are loaded immediately after setting update.
• Settings: Reset the Profile cache when saving settings.
• Template: Ignore split template fields in scripts.
• Themes: Fixed incorrect (CDN) marker on local themes.
• UI: Faster Reload of Dialog Tabs
• UI: Fixed Loading dialog.

17 new features

• Export: Include DB native types in export.
• Import: Attempt to use native types when generating structures.
• Import: Generate SQL for missing fields.
• LogViewer: Updated layout. Sort reverse chronological order.
• Reporting: Enhanced ability to provide sample data for the report template.
• Core: Update to DotNet 4.7.2
• GridEdit: The Field focus marker will turn orange instead of blue if the field is editable.
• Import: Optionally skip database identifiers [caption, description, group, logo, css, template].
• Monitor: Additional server stats and alerts if appropriate.
• Reporting: Optionally supply suitable sample data for the Report Templates.
• Security: Ability to search for users and groups.
• Security: Can now request a immediate refresh of users, groups and SIDs.
• Security: Support for very large Active Directories (100,000+ members).
• Security: The Denied user access setting automatically drops other access.
• Security: Users and Groups used during configuration are cached for 10 minutes.
• UI: Force browsers to retrieve custom CSS file updates.
• Visibility: Enhanced Expression options for Field and Button visibility

60 new fixes

• Import: Better at reusing original relationship names.
• Import: Improved relationship matching logic.
• Import: Optionally strip references to missing views.
• MySQL: Attempt to reuse Native MySQL types for table creation.
• Oracle: Attempt to reuse Native Oracle types for table creation.
• Schema: Improved Schema name handling.
• Security: Additional help if user list truncated.
• Security: Fix to get correct group member details.
• Security: Rebuilt LDAP method to retrieve group members.
• Security: Updated default AD Timeout to 120 seconds.
• Session: Gracefully handle browsers that block sessions and cookies.
• SqlServer: Improved default support.
• Tables/Views: Gracefully handle tables/views without any valid fields.
• Browser: Force browser to load latest resource versions.
• ChildTables: Ensure that hidden join fields are available for insert and update.
• Config: Detect invalid ServicePort values (80, 443).
• Config: Fixed handling of deleted fields on view changes.
• ConfigBackup: Fix handling of empty databases.
• ConfigBackup: Fixed handling of databases without tables.
• ConfigBackup: Improved efficiency, reduced memory, and moved to a separate thread.
• CopyRecord: Carry forward lookup display values when copying records.
• Databases: Fixed visibility of newly added databases.
• ExelExport: Fixed ability to access Excel template if other outputs also selected.
• Export/Import: Fixed ability to transfer M2M rel config between servers.
• Export: Ensure nulls are exported as nulls.
• GridEdit: Corrected Boolean handling.
• GridEdit: Correctly disable lookups on read-only tables.
• GridEdit: Fixed application of ReadOnly user connection access.
• GridEdit: Fixed row select when GridEditing disabled.
• GridEdit: Only allow grid editing of simple lookups with a RowCount <= 2000.
• GridEditing: Disable GridEditing in IE due to incompatibilities.
• Guid: Fixed conversion issue passing uniqueidentifiers to stored procedures.
• IE11: Added polyfill to fix IE 11 support.
• IE11: Fixed Syntax issue with function declaration ()=>{} to function (){}
• IE11: More fixes to provide backward compatibility to IE.
• Import: Ensure the user understands that DDL is minimal and not exacting.
• Import: Fixed ability to insert into/set AutoIncrement fields.
• Import: Force updated table row counts to ensure that import displays correct messages.
• Install: Include core VirusTotal hashes and link.
• KeyBoard: Ensure that keyboard save (Cntrl S) finds the current form.
• Logging: Improved and more consistent SQL debug logging including query timings.
• Lookups: Fixed handling of cached empty server lookups.
• Lookups: Fixed handling of server lookups that keyed on non-PK fields.
• Lookups: Fixed issues with using GUIDs as M-M lookup keys.
• Oracle: Fix to correctly handle function-based indexes.
• Oracle: Fixed Oracle 19 compatibility.
• Oracle: Fixed performance while retrieving table structure updates.
• Readme: Updated to include Release History.
• Reporting: Fixed issue creating custom fields.
• SMTP: Recover gracefully if the SMTP password can't be unencrypted.
• SaveButton: Ensure that the Parent Save button is updated after a child save.
• Security: Truncate security debug logs to only provide a representative sample.
• Stability: Configurable internal locking.
• Stability: Reworked internal locking to improve performance and stability.
• System: Fixed memory calculation for Monitor.
• System: Improved AD caching and usage.
• System: Moved AD validation tests to an alternate thread.
• UI: Added 'Loading' UI when opening any database or settings dialogue.
• UI: Fixed Splitter bar edge cases.
• UI: Fixed arrow position on Advanced Search.

19 new features

• Attachments: Add support for the RTF document type.
• Browser: Now use MomentJS for browser date handling.
• ExcelExport: Export around formula fields to allow for calculations and charts.
• ExcelExport: Export to an Excel xslx template. See: ExcelTemplates
• ExcelExport: Optionally export to a specific sheet and range.
• GridEditing: Disable grid editing if row or table security prevents updates.
• GridEditing: Replaced 'selected' column class with 'focus' as used by the grid editing.
• Keyboard: CNTRL-Enter or SHIFT-CNTRL-S to save and open a new record. See: Keyboard
• Layout: Added Splitter between Table and Details beside table.
• Layout: Change default layout to TableBesideDetails.
• Locking: Enable OnEdit locking. See: RecordLocking
• Table: Ability to use a table/view column to specify a Row CSS class. See: Table-Row-Styling
• TableGrid: Grid Editing is now supported for most basic types.
• TableGrid: Unsaved changes now better reflected in TableGrid.
• Trial: Removed View limit in Trial version.
• WARNING: EARLY BETA RELEASE!
• Widgets: Add TimeZoneEditing to the DataTable.net DateTimePicker.
• Widgets: Replaced jQueryUI Date and Trent Richardson TimePicker widget.
• Widgets: Updated libraries (Select2, MomentJS, DataTables.net, +++)

36 new fixes

• Core: Fixed table.idx & database.idx locking.
• Dates: Fixed "Invalid Date" errors.
• Editing: Fixed handing of reverted field changes.
• Expressions: Improved error messages with invalid expressions concatenation.
• FIPS: Initial work on FIPS compliance
• Formatting: Refactor the Field Handling when dealing with formatted data.
• GridEdit: Fixed Editing speed by removing full table retrieve.
• GridEdit: Fixed capture of primary record changes.
• GridEdit: Fixed confusion caused by excess mouse clicks.
• GridEdit: Fixed prompt to "Save or Discard" on primary records.
• GridEdit: Improved ability to use keyboard only while editing.
• GridEdit: Recreate Lookup Cache if expired.
• GridEdit: Reject invalid cache changes.
• GridEdit: Retain cell focus after saving a change made via the table grid.
• GridEditing: Fix 'Invalid Date' after editing.
• GridEditing: Fixed consistency with Boolean display.
• GridEditing: Fixes for record locking.
• GridEditing: Handle editable grid fields not found in form.
• GridEditing: Handle grid returning fields that should not be editable.
• Help: Fixed help on Lookup Fields
• Html: Fixes to HtmlSanitizer to improve cleaning.
• Logging: Updates to startup logging.
• Lookup: Fixed use of child field names instead of parent on cascading lookups.
• Migration: Fixes to facilitate migrating to 1.1.0
• OnEdit: Fixes to OnEdit record locking.
• Public: Allow public page to be imbedded in an iFrame from another domain.
• Public: Fixes so that a public user never sees a login screen.
• RecordLocking: Fixed 1.1.0.2997 regression that caused a tested lock to be cleared.
• Relationship: Fixed a 1.0.15.1404 regression that caused the loss of older configuration.
• RowSecurity: Fixed 1.1 regression that broke editing of RowSecurity expressions.
• Security: Change missing AD Forest to a warning.
• Sessions: Better handling of expired or dropped sessions.
• Settings: Fixed enabling/disabling alerts.
• Settings: Improved error handling.
• SplitterBar: Cleanup errors due to older browsers.
• TableView: Missing Column Error on table with View and sort.

6 new fixes

• Dates: Fixed "Invalid Date" errors.
• Help: Fixed help on Lookup Fields
• Html: Fixed the Html sanitizer to improve Html validation.
• Migration: Fixes to help when migrating to 1.1.0 including support for newer license keys.
• Public: Fixes so that a public user never sees a login screen.
• Relationship: Fixed a 1.0.15.1404 regression that caused the loss of older configuration.

4 new features

• ActionButtons: Allow some ActionButtons without a selected record.
• Attachments: Set FileNameField with name of uploaded file.
• FileTypes: Added support for the Visio (vsd, vsdx) file types.
• SingleSignOn: Save authentication email on profile creation.

21 new fixes

• Logging: Enhanced logging to help debug startup failures.
• Logging: Fix cases where an incomplete error stack was logged.
• Profiles: Correctly handle profile values that are also lookup values.
• ActionButtons: Fixed ability to click on Buttons with an unchanged blank row present.
• ActiveDirectory: Fixed AD group performance, especially when debugging.
• Attachments: Fixed issue uploading attachments with non-unique magic numbers.
• AzureSSO: Improved email address retrieval from authentication.
• CanInsert: Correctly clear unset CanInsert security.
• Changes: Improved change detection.
• CreateLookup: Fixed lookup generation to use native data types.
• DeleteRow: Fixed ability to Delete without requiring Update access.
• Expressions: Fixed handling of missing expression values.
• FileTypes: Improved FileType detection and usage.
• Insert: Fixed FormCache error on double create new.
• Layout: Fixes for grouped field layout.
• MySql: Use count(KeyFieldName) where possible to improve count() performance.
• RowSecurity: Update the CanDelete and CanUpdate config UI to require a PK.
• RunProcedure: Run procedures without require a save of new unchanged records.
• SSL: Fixed HTTP CDN theme URL.
• SingleSignOn: Fixed handling of blocked referrer URL on Logout.
• SingleSignOn: Fixed page session expiry logic while running SSO.

13 new features

• ActionButton: Allow RunProcedure action to trigger table open.
• ActionButton: Don't require row-selection to enable buttons if parameters are expressions.
• Authentication: Better feedback if invalid usernames/domains are specified.
• Cascading: Allow cascading lookups against non-lookup fields.
• Core: Updated to latest jQuery 3.4.1
• CssFile: Automatically test and correct CSS filenames.
• LoginDetails: Now always available.
• LogoFile: Automatically test and correct Logo filenames.
• M-M: Ability to single select using a M-M relationship to define the valid options.
• Reporting: Moved printing from WebApp to Service.
• RunProcedure: Suggest checking for SP access if not found.
• RunProcedure: Trim procedure name before saving.
• SQL: To help debug performance issue, SQL logging now includes duration.

17 new fixes

• AdvancedSearch: Fix weird refresh on filter save/reload.
• AdvancedSearch: Fixed incorrect empty selections.
• Cascading: Account for cascading lookups when setting default field order.
• Expressions: Fixed regression caused by updated field quoting.
• Formatting: Fixed formatting of base Date datatypes to exclude time information.
• HTML: Removed invalid closing tags.
• Lookups: Fixed parent updates failing to reset cascading children.
• Profile: Ensure static data is available for profile lookup fields.
• RecordLocking: Improved record hash uniqueness to correct number of records locked.
• Relationships: Shorten generated relationship names.
• Reporting: Fixed incorrect printing label.
• Schema: Allow using duplicate relationship constraint names between schemas.
• Setup: Extended Group field names to 64 characters.
• SingleSignOn: Corrected AzureAD group retrieval, also works for the Free AzureAD.
• SingleSignOn: Fixed application of privileges to SSO users.
• StaticData: M-M relationship changes now also trigger lookup refreshes.
• TablePref: Better error message if duplicate relationship hash on save.

8 new fixes

• Authentication: Require the removal of the "." user domain + Online Help
• PDFForms: Fixed licensing.
• Reporting: Fix "required" filter ranges.
• Reporting: Fix output selection.
• SMTP: Removed requirement for SMTP login password.
• SingleSignOn: More specific error messages.
• SingleSignOn: Show failed SSO authentication attempts + Retry option.
• UpdateCheck: Corrected failure messages.

3 new features

• About: Access version release notes from About screen.
• Attachments: Configure the fieldname that stores the filename.
• SQLServer: Improved FileTable support.

5 new fixes

• Attachments: Enable save button on attachment upload.
• Attachments: Fixed FileType extension handling issue for unknown types.
• SQLServer: Use Native Data Type when retrieving inserted key values.
• SingleSignOn: Updated help.
• Tooltips: Restore tooltips broken by a regression.

15 new features

• Admin: Ability to trigger an email alert to administrators.
• Admin: Weekly/Daily emailed admin report including stats and status information.
• Config: Ensure that procedures are valid and accessible at configuration time.
• Config: Ensure that the database authentication procedure is valid at config time.
• Email: Ability to configure and test SMTP settings within dbFront.
• MassUpdates: Improved logging in case audit information is needed.
• Admin: Monitor screen now includes summary statistics.
• Dropdowns: Add ability to filter dropdown values.
• Dropdowns: Lookup items that are filtered but used will be marked as deleted.
• SingleSignOn: Add ability to set a logout redirect URL.
• SingleSignOn: Added SAML 2 based SSO functionality.
• SingleSignOn: Can setup a SSO Group to grant full Admin privileges.
• SingleSignOn: Can use SSO Groups to manage connection Update / Read access.
• SingleSignOn: Enabling SSO disables Windows and Database authentication.
• SingleSignOn: Request full login after logoff. (Not all SSO vendors support)

14 new fixes

• MySQL: Recognize and alert for missing SELECT permission on [mysql.proc]
• PasswordFields: Permit changing record contents without having to reenter password fields.
• Tables: Improve handing when all table columns are renamed or removed.
• Tables: Recognize when a filter change causes the table page to become invalid.
• Dropdowns: Fixed ability to set dropdown sort order.
• Dropdowns: Fixed broken type ahead for dropdowns within dialogs.
• Layout: Fix issues with CSS classnames being dropped during render.
• MySQL: Revert SSL mode as it broke existing Non-SSL sites.
• MySQL: Set Connection SSL-Mode to Required for testing.
• SQLServer: Pass Null stored procedure params as DBNull.
• Setting: Fix fields that were not disabled in read-only view.
• SingleSignOn: Cosmetic fixes.
• SingleSignOn: Improved logging and help.
• Table: Fixed invalid "No data on page 1, please select a previous page"

15 new features

• Importing: Identify missing keyfields if Update or Import&Update
• Importing: Identify missing required fields if Import or Import&Update
• Login: Trim space from around username at login.
• Reporting: Ability to set template margins in inches.
• Reporting: Create and supply a default caption for quick reports.
• Reporting: Include 4 report templates with install.
• Reporting: Lock PrinterName and PageSize for Single-Click report printing.
• Reporting: Preload default Papersizes even if no printer drivers available or accessible.
• Reporting: Print directly to any server attached printer by name.
• Reporting: Print tab added to settings to manage available printers.
• Reporting: Report Header and Footer support updated.
• Reporting: Set orientation and size on all PDF or printed outputs.
• Reporting: Template Preview at template selection.
• Reporting: Template Preview in Editor is now 100% accurate.
• Reporting: Updated HTML rendering engine.

12 new fixes

• AdvancedSearch: Reverted optimization that broke advanced search.
• Importing: Correctly identify fields based on caseless name or caption part or whole.
• Profile: Trap error if both ProfileID and ProfileCaption use the same field.
• Reporting: Clear Template selection when not need to avoid errors.
• Reporting: Ensure generated PDFs are only cached if identical.
• Reporting: Fix Template issue of default values returning after a null is saved.
• Reporting: Fixed ability to manage Report child field details.
• Reporting: Fixed duplicate template custom fields handling.
• Reporting: Fixed missing or invalid templates handling.
• Reporting: Fixed page size entry at report time.
• Reporting: Move Template Images to Template folder.
• Reporting: Quote suggested attachment filename.

3 new features

• Importing: Identify missing keyfields if Update or Import&Update
• Importing: Identify missing required fields if Import or Import&Update
• Login: Trim space from around username at login.

2 new fixes

• Importing: Correctly identify fields based on caseless name or caption part or whole.
• Reporting: Fixed ability to manage Report child field details.

5 new features

• MySQL: Tested with new 8.xx connectors
• QuickImport: Allow for "Import Only", "Update Only", and "Update or Import"
• QuickImport: Allow lookup handing on text and other field types.
• QuickImport: Ignore casing on field names.
• QuickImport: Trim Inputs to improve matching.

2 new fixes

• CopyRecord: Fixed issue on MySQL where coping a record would clear all lookup fields.
• QuickImport: Fixed lookup handling.

2 new features

• Barcodes: New ability to format fields as barcodes on forms and reports.
• Import: Imported values on lookup fields can now match on lookup key values or display values.

4 new fixes

• Nulls: Fix occasional issue with quoting of null values.
• QuickPrint: Fixed template selection.
• Visibility: Correctly compare numeric values client side.
• Visibility: Fixed visibility issues due to missing fields.

21 new features

• ActionButtons: Buttons can now prompt users for additional information before processing.
• AdvancedSearch: Search for both blanks and nulls when looking for empty values.
• Debug: The debug flags can now be set and cleared from the Settings UI without restarting.
• DeepLinking: Link directly to any record using the primary key. See: DeepLinking
• Fields: User help / Tooltips can now be added to all fields.
• Fields: User help also available for disabled fields.
• Fields: Visibility can now be controlled by adding fields to Layout Groups.
• LayoutGroups: Add, remove, and rearrange fields in Layout Group editor.
• LayoutGroups: Conditional visibility can be Server based or Browser based.
• LayoutGroups: Create collapsible Layout Groups. Either Start Open or Start Closed.
• LayoutGroups: Easily reposition Layout Groups relative to existing fields.
• LayoutGroups: Hidden layout groups are still partially visible for Admins.
• LayoutGroups: Layout groups now have conditional visibility.
• MassUpdate: Now treats blanks and nulls as empty for both searches and updates.
• RecordLocking: Admins can now remove record locks from the System Monitor screen.
• Settings: Can now manage almost all Service settings including the debugging flags.
• Tooltips: Tooltips used to expose the full object names when truncated in dialogs.
• UserHelp: All user help can now be edited in a rich text editor.
• UserHelp: User Help is now found in the root tab of Tables, Fields and Buttons.
• Visibility: Added [If In List] and [If Not In List] as comparison options.
• Visibility: Visibility is now found in the root tab of Groups, Fields and Buttons.

9 new fixes

• 1-1: Fixed issue configuring preferences on 1-1 rels.
• ActionButtons: Fixed handling of Refresh events when an action button brings up a dialog.
• CustomCSS: Fixed changes that caused custom CSS class names to be ignored.
• IE 11: Fixed access to config options.
• IE: Fix for Internet Explorer to allow Dialogs to properly overlay iFrame contents.
• MySQL: Fixed ability to use non-standard ports.
• MySQL: Fixed high speed rowcount calculation.
• RowCounts: Correctly update internal rowcounts if the end of table is prematurely hit.
• Tooltips: Replaced the hover tooltips on fields and select items with a manual click on the help icon.

23 new features

• Automatically attempts to recover locks on return navigation.
• Automatically drop locks if a user navigates away or closes a browser tab, See: RecordLocking
• Automatically purge expired locks.
• ButtonVisibility: Ability to manage button visibility based on security and data access.
• ButtonVisibility: Optionally override the data access to trigger locking for ReadOnly users.
• Buttons: Disable Save & Discard buttons when there is nothing to save.
• Buttons: Group Action buttons, Report buttons and Advanced Tool buttons separately.
• CreateCopy: Append " (copy)" or " (copy N)" to Unique text columns instead of clearing.
• Inserts: Improved ability to manage Inserts with Null Keys values.
• Locking: Cleanup all Tab/Session locks if the user moves to a new main record, See: RecordLocking
• Lookups: Extra help and feedback when configuring lookups.
• Lookups: Improved support for deeper cascading lookups, See: CascadingLookups
• Lookups: Show relationship detail details in config dialog.
• MassUpdate: Added a confirmation page to the Edit Wizard.
• MassUpdate: Advanced Filter is used to select the records to update or delete. See: MassUpdate
• MassUpdate: Delete or Update multiple records in a single transaction. See: MassUpdate
• MassUpdate: Now checks for unsaved changes.
• RecordLocking: "On Enter" record locking is now used by default, See: RecordLocking
• RecordLocking: Child records automatically locked if parent is locked.
• RecordLocking: New Record Locking functionality. (On Enter), See: RecordLocking
• RecordLocking: [Help]/[Monitor] Page lists active record locks with details.
• RowCount: High speed rowcounts for large tables in Oracle, MySql and SQL Server.
• SQLServer: Improved support for using a unique index if no PK present.

7 new fixes

• CreateCopy: Recover unique child fields used for joins to the parent record.
• DateFormat: Fixed formatting of Readonly fields.
• Lookups: Fixed cascading lookups pointing to a Unique index instead of PK.
• Lookups: Fixed multilevel field dependencies.
• Profile: Ensure that the Profile menu items shows correctly.
• QuickSearch: Clearing filter will now automatically reload full data set.
• SQLServer: Fixed support for SQL Server 2000.

14 new features

• AdvancedSearch: Ability to save and reload Default Filter to Cookie or Profile.
• AdvancedSearch: Allow specifying NULL values for the advanced search.
• CustomButtons: Ensure Refresh Level works correctly for both RunProcedure and OpenURL buttons.
• CustomButtons: Ensure help text is valid, safe and balanced HTML. Allow formatting.
• CustomButtons: Set Css Classes that will enable extra styling options.
• CustomButtons: Set Help Text that displays as a tool-tip.
• Icons: Replaced the jQuery Icons with jquery-ui-iconfont, for clarity and extra options.
• Passwords: Warn if the Caps-Lock key is on.
• Profile: Ability to autocreate Profile Records.
• Profile: Ability to store settings on the User Profile.
• Profile: Ability to view the current users profile from the top menu.
• Profile: Profile errors will block regular users. Admin users are allowed to continue so they can fix the issues.
• Refresh: Add ActionButton option to refresh the Form from the Database.
• Settings: Added [SiteFooterHtml] to allow setting a site footer. See: Layout

15 new fixes

• Attachments: Fixed error after upload rejected due to size.
• Connections: Hide disabled connections from non-admin users.
• CustomButtons: Ensure attributes are correctly quoted.
• Dropdowns: Fixed error when typeahead cancels a resultset to request an update.
• Dropdowns: Reset/Clear child cascading dropdown if parent changed.
• Errors: Correctly highlight invalid dropdowns.
• FormCache: Fixed reloading after a custom update.
• FormCache: Fixed saving cache with missing attachment data.
• Menu: Profile Menu layout corrected.
• PDFForms: Default Field.Flatten to "Assigned" to cover PDF Viewers that can't show form fields.
• PDFForms: Fixed flattening too many fields.
• Passwords: Detect browsers without Caps-Lock detection and disable.
• Profile: Remove invalid fields from Database Profiles settings.
• Refresh: Cleaned up button refresh options
• SQL: Automatically replace NULL parameter values with NULL on insert.

30 new features

• AuditFields: Update Audit Fields for MultiSelect changes.
• AuditFields: Update Audit Fields for child record updates.
• Cache Changes: Ability to make multiple changes before saving.
• Cached Inserts: Ability to cache the insert of multiple new child records.
• Config: Add grouping to select dropdowns.
• ConfigBackup: Automated Database Config backups on change + cleanup.
• Connection: Allow users with Setup Access to enable / disable connections.
• Export/Import: Add explicit schema information.
• Expressions: Shortcut certain expressions to save on server roundtrips.
• Fields: More details for 'Autoincrement' fields.
• FormView: Add Maximize Button to Child Forms. Opens that Table/Row as main.
• FormView: Replace "goto" buttons with a more compact "Maximize" icon and hover text.
• Help: Ability to default Sidebar Help to: On, Off or Disable. See: SidebarHelp
• Network: Ensure that the TCP channel between the client and server is secure.
• PDF Forms: Support for filling in PDF Forms, optionally flatten fields.
• PDFForms: Enable basic expressions [%username%, {date()}, {datetime()}]
• PDFForms: Use database DateFormat for expressions.
• Relationships: Ignore redundant relationships to self.
• ReportTemplate: Make UI clearer.
• Reporting: Selecting Report or PDF templates automatically reloads custom field list.
• Reset Changes: Ability to reset form changes.
• SaveButton: Save buttons now include change counts that also reflect child rows.
• Security: Ensure that CRITICAL notices are visible to all authenticated users.
• Security: Hide Connection / Database items instead of raising security warnings.
• Table Security: Ability to disable Insert based on the user or data.
• Table Tools: Ability to script the creation of a 1-M or M-M Lookup.
• Transactions: Ability to save parent record and all children in a single transaction.
• Transactions: Correctly cache and save M-M relationships on child tables.
• Transactions: Correctly cache and save attachments on child tables.
• URL: Avoid use of Table name on URL. (Backwards compatible)

24 new fixes

• Attachment: Ensure attachments are saved on new or copied records correctly.
• Attachment: Fix "Can't load attachment" errors.
• Editing: Fixed 'RowHash not set' when creating new records in some specific cases.
• Editing: Handle "User" reversed changes correctly.
• Errors: Made Error Logging more extensive.
• Expressions: Improved Expression Testing.
• Filters: Enable Filters on M-M and MultiKey relationships.
• FormFields: Detect if MultiKey lookup fields are out of order.
• Menu: Reorder the Help menu
• PDFForms: Correct Button visibility on empty records.
• PDFForms: Handle Forms with duplicate form fields.
• Profile: Fixed "Can't check Profile" errors.
• ReportTemplate: Improved Template Preview.
• Reporting: Correctly evaluate formatted custom field values.
• SQL Script: Improved Formatting.
• Saving: Fixed repeated save notice.
• Schema: Fix Object Not found when looking for a table name.
• Schema: Make the Database Preferences schema aware.
• Schema: Turn of Schema/Owner if MySQL or if not multiple schemas
• Schema: Various fixes to make dbFront more Schema aware.
• Startup: Detect invalid Service / UI combinations.
• Table Rendering: Handle sort order issues during table rendering.
• Themes: Fix Table Beside Details Display with Dark Background Themes
• UI: Fixed hiding of all close icons on UI confirmations.

1 new fix

• StoredProcedure: Fix Table Results view returning incorrect data.

1 new feature

• Network: Ensure that the TCP channel between the client and server is secure.

2 new fixes

• Attachments: Fixed ability to save attachments.
• Themes: Fix "Table Beside Details" display with dark background themes

1 new feature

• ConfigBackup: Automated Database Config backups on change + cleanup.

3 new fixes

• DateTime: Fixed error testing Date Fields on ActionButton click.
• Errors: Made Error Logging more extensive.
• Profile: Fixed "Can't check Profile" errors.

17 new features

• AD: Include Group Type and Scope in logs to help debug AD Security issues.
• AD: Log Error / Warning if a Distribution group is used instead of a Security Group.
• CSV Import: Add support for multiline CSV values.
• CSV Import: Handle importing into child tables. (Requires matching or empty Parent Key)
• Config: Extend Relationship dialog to show the relationship type details.
• Core: Ability to detect associate tables.
• DateTimeOffset: Added support for the SQL Server DateTimeOffset datatype.
• Many-To-Many: Ability to create and drop M-M relationships via a Multiselect.
• One-To-One: Display 1-1 relationships as a form in a tab that automatically follows the main record.
• SQL Server Database Import: Automatically handle identity insert on Database Imports
• SQL Server: Return the Check Constraint's Description as part of Constraint Failure errors.
• Save Prompt: Automatically prompt to save when switching to new row. Include child rows.
• SaveButton: The save button now has a count of the changs to save.
• SaveButton: You can now trigger a save with the keyboard shortcut CNTRL-S.
• Search & Reporting: Ability to select multiple options for searching and reporting.
• Update/Insert: Improved formatting of Update / Insert errors.
• UsageAgreement: Default to false instead of unchecked to make it easier to notice.

25 new fixes

• CSV Import: Fixed importing empty values.
• CSV Import: Fixed importing when last column contains empty values.
• CSV Import: Identity Insert Fixes.
• CSV Import: Import Nulls correctly.
• CacheErrors: Prompt to reload when the cache is dropped by a Refresh.
• DateTime Widget: DateTime widget to only show the hours/minutes/seconds and TimeZone only if required.
• Defaults: Don't evaluate/save defaults for read-only fields.
• Export: Skip M-M pseudo fields on export.
• Field Sizes: Fixed calculation for Numeric Field sizes.
• History: Ensure history (back button) is not served from cache.
• Logging: Log correct SQL Params for errors in multipart updates.
• Logging: Log correct SQL for errors in multipart updates.
• Long Integers: Correctly handle 64 Integers.
• Lookup Captions: Fixed truncation of Lookup display values.
• Lookup: Fixed 404 error when retrieving Lookup data for complex forms.
• M-M Widgets: Fixed the saving of field Caption.
• M-M rels: Fixed "Single Row Expected" error for M-M rels.
• M-M: Fixed Param error on delete when key value hidden.
• One-To-One: Fixed the ability to view/edit One To One relationships.
• Schema Names: Properly quote unsafe schema names, e.g. [top.gun]
• Select: The arrows on disabled Select widgets now hidden.
• Table Sort: Correctly sort initial table data if sort columns are not in table.
• Unknown Types: Mark unsupported field types as TextRaw to avoid issues.
• Warnings: Hide warnings the user can't do anything about. They will still be in the logs.
• iFrame: Fixed invalid XSS error when running in iFrame.