Release History

8 new fixes

• AdvancedSearch: Fixed issue where some lookups failed to recovering after refresh.
• Help: Fixed selection of HelpUrls in tabs and reloaded dialogs with nondefault tabs.
• Passwords: Fixed silent password truncation when pasting into password fields.
• Setup: Fixed regression that broke the ability to save Summary Report days.
• SMTP Account Password: Adjusted Max from 61 to 100 to accommodate SendGrid API keys.
• UI: Fixed issue of Database Menu disappearing for admins with one database.
• UI: Fixed issue of Single App instance showing the wrong theme.
• UI: Added Group Count to Login Details screen.

4 new features

• RequestHandling: Added the ability to handle callback requests from OAuth and other services via a Stored Procedure. Q&A
• RequestHandling: Improved help by displaying the expected Request URL in the config dialog.
• RunProcedure: Stored Procedures can now optionally request and process the result of a WebRequest. Q&A
• SQLServer: Verify Executable access to stored procedures when saving preferences.

1 new fix

• Merged 1.2.6.8661 and 1.3.1.1642 fixes into dbFront 1.4.0

7 new features

• Buttons: Directly set a button width. The default width is 120px.
• Buttons: Optionally position buttons below their form.
• Buttons: Optionally group buttons, with group names visible or not.
• Expressions: Added additional expression for the other parts of the Url. {url(domain)}, {url(root)}, {url(path)}, {url(fragment)}
• Layout: Added the ability to rearrange the Table elements. (Table Grid, Custom Search Buttons, and Advanced Search), Q&A
• Procedures: Allow Procedures called by RunProcedure and WebRequest action to automatically refresh their results. Q&A
• Search: Optionally turn a multi-select into a single select.

6 new fixes

• AdvancedSearch: Fixed Layout for AlwaysShow
• Buttons: Fixed inconsistent button width causing overflow.
• Help: Possible fix for stray help icons on integer fields. Issue:1568
• Procedures: Default message on success instead of nothing.
• Refresh: Fixed unexpected refresh when changing tabs.
• Rendering: Additional progress information as reports and exports are rendered.

2 new features

• SQLServer: Ability to DebugLog SQL Server messages to help monitor performance.
• SQLServer: Performance Analyzer for Linked Views to help track down view/column problems.

3 new fixes

• GroupVisibility: Fixed regression that would cause loss of VisibilityCondition when upgrading from 1.3 to 1.4
• URLEncoding: Made the encoding of URL parameters smarter to ensure that only URL parameter values are encoded.
• ExcelExport: Attempted upgrade of Excel components in previous 1.4 beta but reverted to a working functionality.

1 new feature

• Search: Ability to adjust the Search fields to be Single or Range. Q&A

15 new features

• Backups: Enhanced ability to compare configuration backups, including viewing all changes over time.
• Backups: Enhanced backup purge logic to retain at least 120 days of configuration history within 45 backups.
• Buttons: Added the ability to edit any button's properties from the Table Prefs dialog.
• Compare: Added "IfContains" and "IfNotContains", compare types. Q&A
• Core: Updated multiple 3rd-Party components.
• Expressions: Added {url(query)} as an optional value to pass to procedures, visibility expressions, etc... Q&A
• Fields: Added ability to edit any field's properties from the Table Prefs dialog. Q&A
• MySQL: Replaced the MySQL Connector/Net with MySqlConnector to add built-in support for MySQL, MariaDB, +4 more... Q&A
• Relationships: Added dynamic visibility support to relationship tabs, similar to buttons and field groups. Q&A
• Relationships: Extended the Multi-Select functionality to compound relationships. Q&A
• RunProcedure: Updated SimpleTable output format to improve field formatting. (Dates, Blobs...)
• Search: Ability to Specify if the Advanced search is AlwaysOpen, DefaultOpen or DefaultClosed. Q&A
• Table: Display Attachment/Image thumbnails within the grid. Q&A
• Table: Ability to configure a "BeforeFormLoadProcedure" to run a stored procedure that can do extra work to prepare the form data before the actual Select for the FormData. Q&A
• Testing: Opened support for automated client testing using Katalon Recorder (dbFront Site License)

9 new fixes

• Button: Fixed Button visibility when no record data required, e.g. OpenUrl with plain link.
• ClientUI: Updated type handling on visibility expressions. e.g. Boolean values of 'T', '1', 'True' are all equal.
• RunProcedure: Updated SimpleTable output format to improved field formatting. (Dates, Blobs...)
• MySQL: Fixes to MySQL SSH reconnect logic to improve stability.
• OpenURL: Ensure that all values passed to OpenUrl WebRequest are UrlEncoded.
• Oracle: Minor connection error message changes.
• Profile: Fixed Error that occasionally prevented the loading of the Profile dialog.
• Tools: Fixed the generated SQL grants for Lookups and Multi-Selects.
• URL: Replace the Database with the Database Key in URLs once the initial page is loaded.

2 new features

• Lookups: Allow explicit sorting by View Fields.
• OpenURL: Extend OpenURL so that it can correctly load audio and video.

1 new fix

• Merged in all fixes up to 1.3.1.1622.

6 new features

• Import: Added the ability to import PDF forms, very similar to Excel or CSV. Q&A
• WebRequest: Ability to set a RequestMethod [Get, Post, Head, Put, Delete]. Q&A
• WebRequest: Ability to set a Request Header including expressions.
• WebRequest: Ability to set a Request Body including expressions.
• WebRequest: Ability to receive a file (e.g. PDF) and either view or save it.
• WebRequest: Ability to Indent received Json.

2 new fixes

• MySQL: Automatically recreate SSH connections if they error out.
• Core: Update internal lock handling.

2 new fixes

• MySQL: Fixed ability to delete ALL rows.
• Merged: All fixes included in dbFront 1.2.6.8060 and earlier.

4 new features

• CrystalReports: Added output types: Html, Txt, Xml, Xlsx
• CrystalReports: Inline images in Html output
• CrystalReportsHelper: Updated for additional types.
• Security: Added support for separate User and Group containers and LDAP filters

2 new fixes

• Merged: All fixes included in dbFront 1.2.6.7021 and earlier.
• CrystalReports: Fixes to ensure that selected types would download/display correctly.

2 new fixes

• Caching: Ensure that any structure change clears cached lookups.
• Merged: All fixes included in dbFront 1.2.6.6516 and earlier.

4 new fixes

• Attachments: Attempt to enable camera on upload.
• Caching: Reset internal cached values after settings save.
• FileLink: Open access to network-accessible files.
• ZipExport: Ensure that any FileLink attachments are valid.

7 new features

• Core: Updated multiple 3rd-Party components.
• Exports: More meaningful Filenames for Reports and Exports. Q&A
• FileLink: Added read-only support for attachments stored on the file system. Q&A
• Scrolling: Added ability to scroll through table instead of paging. Q&A
• Table: Renamed "Table Fields" to "Table" in config.
• ZipExport: Export a ZIP package containing the PDF report and all referenced attachments. Q&A
• ZipExport: Include FileLink attachments in Zip package.

2 new fixes

• Attachment: Fix "RowHash not set" regression when attempting to upload a file.
• MassUpdate: Fixed ability to clear Non-Nullable field values.

1 new feature

• Procedures: Added full support for stored procedures that return multiple results sets. Q&A

1 new fix

• Oracle: Fixed issue with single-row updates and deletes in Oracle.

2 new fixes

• CSS: Fixed Busy Icon not showing up on Flattened Themes.
• Time: Fixed errors when handling some time fields.

2 new fixes

• Lookups: Fixed ability to Export/Import the Lookup Filter.
• Lookups: ForceServerLookup if either the Lookup Filter or Row Select Security is user-dependent.

3 new fixes

• ReportTemplates: Fixed ability to create blank templates.
• ReportTemplates: Simplified deleting report templates with errors.
• Sessions: Fixed purging of invalid sessions.

1 new fix

• FileLinks/OpenUrl: Fixed access to network files. [file://\\servername\share\]

3 new fixes

• Config: Fixed XML error loading config from cache.
• CustomSearch: Fixed use of Lookup fields as custom search parameters.
• Licensing: Ensure critical License/Version errors are not hidden for SSO users.

1 new feature

• WebRequest: Added option to call Stored Procedure to process the results. Q&A

26 new fixes

• 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.
• Core: Fixed ability to overwrite invalid config..
• Core: Improved Null handling.
• 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.
• 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: Fixed handling and reporting of Support Expiry.
• LogOut: Added a confirmation before logout. Q&A
• 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.
• 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).
• UI: Fixed issues where Form would revert to a New record after update.
• UI: Improved Refresh Handling for both the Form and Table.
• URL: When deep-linking dbFront will use the best connection for the user/database/table.

2 new features

• Layout: Added "TableOnly" layout. Currently requires disabling insert. Q&A
• Table: Added ability to set 'Sticky' table columns that remain on screen. Q&A

3 new fixes

• Report: Extended automatic field rename handling to reports. Q&A
• 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

1 new feature

• SystemMonitor: Rebuilt IP based activity monitoring and layout.

4 new fixes

• ClientErrors: Log client browser type/version.
• Core: Upgraded to jQuery 3.6.2 from 3.4.1.
• LogViewer: Minor layout fixes.
• UI: Fixed FireFox error triggered by the updated jQuery libraries.

3 new features

• CustomSearch: Users can create/edit their own search buttons.
• CustomSearch: Ability to set constant values and ranges or NULL.
• CustomSearch: Optionally, Clear, Overwrite or Merge with Advanced Search.

6 new fixes

• Cookies: Compress and encrypt the Json cookies
• Core: Reject field/object names that are only numeric.
• CustomView: Fixed the issue with the "My Layout" not saving.
• Help: Trimmed Informational Fields.
• Help: Added help text to "My Layout" button.
• UI: Upgraded to jQueryUI 1.13.2 from 1.12.1.

6 new features

• AdvancedSearch: Extended the length of the search field from 50 to 200. Q&A
• 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
• MassUpdate/Delete: Updated to handle search filters based on Filter Buttons.
• MassUpdate/Delete: Updated to handle search filters based on Related Views.

2 new fixes

• Access: Ignore access errors to databases not requested by the current user.
• AdvancedSearch: Fixed oversized search keywords breaking the layout.

7 new features

• Attachments: Added support for Email (.eml) attachments. Q&A
• Backups: Ability to view, compare and restore configuration backups.
• Expressions: Add {%databasekey%} as an expression. Used when creating app URLs.
• Reporting: Moved Reports into regular config to simplify config export/import.
• SSH: SSH support for MySQL. Username/Password and/or PrivateKey/Password. Q&A
• SSH: Automatically reconnect as required + Keepalive.
• Table: Ability to reset all configuration at the table level.

15 new fixes

• Backups: Fixed issue with excess backups.
• Export: Changed export to split out the database attributes for simpler compare.
• Help: Fixed issue with Sidebar help failing if there was another error.
• Home: Fixed config import/export for actions and reports buttons.
• HtmlEdit: Fixed HTML Edit in Popup dialogs.
• HtmlEdit: Increased the minimum size of HtmlEdit widgets.
• Lookups: Fixed issue with MultiSelect fields.
• Oracle: Updates to help track down/log ODP.net errors.
• Profile: Find Profile table even if schema is missing.
• Reporting: Improved detection of template file changes.
• Reporting: Improved handling of invalid/missing templates.
• Reset/Restore: Fixed ability to purge old cached table config.
• SQLServer: Recognize and warn about DB corruption.
• URL: Ignore Hidden Databases when doing a lookup by database name.
• Validation: Skip validation on new records until data is changed.

3 new fixes

• Config: Ensure the ForceServerLookup flag is included in Export/Import.
• Layout: Fixed issue with hidden fields affecting layout.
• Profile: Ensure named db schema is loaded before profile access.

2 new fixes

• HomeScreen: Handle invalid config silently.
• Expressions: Trim expressions before use.

9 new fixes

• Config: Truncate excessively large deserialization error messages
• Layout: Apply style fix to database home page.
• Profile: Fixed profile creation with Audit fields.
• Profile: Fixed profile table lookup.
• Readme: Updated Readme with more Login help.
• URL: Fixed lookup for invalid databases.
• URL: Ignore hidden databases when doing a lookup by database name.
• Views: Fixed view queries to eliminate key errors.
• Views: Fixed handling of field duplicates caused by views.

2 new features

• CrystalReports: Optionally print Crystal Reports to a Server Printer.
• Settings: Optionally block the ability to export/import data from the Admin database screen. Q&A

9 new fixes

• CrystalReports: Fixed ability to allow user report destination selection.
• CrystalReports: Deeper logging.
• FollowMeHelp: Fix the FollowMeHelp in tables.
• GridCSS: Fixed issue accessing empty CSS values.
• HomeScreen: Added FollowMeHelp.
• Layout: Fixed gear-icon positioning. Q&A
• LogViewer: Corrected error classification.
• Lookups: Fixed handling of renamed lookup display and sort columns. Q&A
• OpenURL: Ensure local download errors do not reveal the full file path.

3 new features

• GridEdit: The RowCSS now immediately refreshes with grid data changes.
• Table: TableHeaders will float above the data when the page is scrolled down.
• Themes: Added a clean/flat version of standard themes by clearing background images.

6 new fixes

• CrystalReports: Additional CrystalReportHelper Param Help.
• CrystalReports: Extended Credential Logging and Help.
• CrystalReports: Warn of invalid extensions.
• LogViewer: Fixed issue of Login Screen not appearing after session expiry.
• Settings: Fixed handling of empty LdapFilter.
• Templates: Added main title text-shadow to ensure visibility on some templates.

3 new fixes

• ProfileFields: Fixed issues loading correct profile field values in HomeScreen.
• OpenURL: Fixed write access requirement for download files.
• Settings: Improved LDAP Filter validation.

10 new features

• CrystalReports: Added the ability to run Crystal Reports. See: CrystalReports
• CrystalReports: Able to return multiple types: csv, doc, pdf, rtf, tsv, xls.
• Excel: Updated OpenXml.
• 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: Settings configure Allowed Local FilePaths. e.g. c:\filepath\*.pdf
• OpenURL: Local Download limited to specific "safe" file types.
• Oracle: Updated Oracle.ManagedDataAccess.
• 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

4 new fixes

• Cleanup the error messages by stripping duplication.
• Fixed invalid error when checking RunProcedure arguments.
• MySql: Fixed FullText search when using multiple or non-matching indexes.
• Select: Fixed issues with selecting a required config item.

11 new fixes

• Advanced: Debug Mode now provides advanced Server/Driver details.
• Advanced: Moved Server/Driver information below databases + improved layout.
• Config: Corrected config error messages to provide correct detail.
• Editing: Fixed editing child records where the FK was not contained in the PK and not visible.
• Import: Include SQL for GRANTs with table creation.
• MySQL: Fallback if driver doesn't support .BeginTransaction(IsolationLevel)
• 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.
• 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.
• WebUI: Fixed Heading on Collapsible Groups

1 new feature

• System: The site warning or error can now be discarded. Still visible in the System Monitor.

1 new fix

• System: Fixed layout issues with the site messages.

1 new feature

• GridEditing: Added support for GridEditing on tables with Row Security.

13 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.
• 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.
• Import: Skip creation of relationships for missing objects.
• LayoutGroups: Fixed support for Multi-Select fields.
• LayoutGroups: Fixed layout issue where extra-wide Lookup or Multi-Select fields could mess up the layout.
• MultiSelect: Improved warning about non-defaulted required attribute fields.
• MySql: Fix to correct or discard invalid relationships.
• WebClient: Improved error handling and logging to server.
• WebClient: Better error handling on invalid lookups.

3 new features

• HomeScreen: Improved Default.
• HomeScreen: Now supports {%DatabaseCaption%},{%TableCaption%},{%LogoUri%},{%InspirationalQuote%}
• PageFooter: Now supports {%DatabaseCaption%},{%TableCaption%},{%LogoUri%},{%InspirationalQuote%}

2 new fixes

• Debugging: Improved internal monitoring and logging.
• Html: Fixed Custom Html formatting.

10 new features

• HomeScreen: New database home screen with a menu item and customizable title and content.
• HomeScreen: Expand profile expressions in the content HTML.
• HomeScreen: List selected tables.
• HomeScreen: List selected action buttons that don't require an active record.
• HomeScreen: List selected action buttons as reports.
• HomeScreen: List selected multi-row reports.
• HomeScreen: Sanitize the home screen HTML when saving.
• HomeScreen: Respect visibility expressions on action buttons.
• Menu: Optionally move the Database menu into the home screen.
• WebRequest: Renamed WebGet to WebRequest.

8 new fixes

• Dialogues: Standardize button order on dialogs.
• Dropdowns: Removed ">None<" option from required lookups.
• Html: Updated HTML validation on help and template fields.
• Html: Updated the internal HTML parser/sanitizer/formatter.
• 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.
• MySql: Fix to correct or discard invalid relationships.

3 new features

• WebGet: WebGet is now a firstclass button type. See: WebGet
• WebGet: Optionally parse JSON requests using JsonPath. See: WebGet
• WebGet: Optionally parse XML requests using XPath. See: WebGet

6 new fixes

• Config: Fixed handling of invalid config that could block dbFront access.
• Config: Fixed detection of new columns and placement on Forms (AppendToForm).
• Numeric: Fixed ability to update a null numeric value.
• Oracle: Added lock around loading of defaults.
• SQLServer: Fixed calculated columns detection.
• Update: Fixed ability to update rows on tables without a PK and containing a calculate column.

6 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
• 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

5 new fixes

• CSS/Field: Fixed message returned if invalid characters were entered for the CSS class.
• Expressions: Fixed testing of SQL expressions when the PK can't be compared with "0".
• Layout: Fixed extra space above table when table-beside-detail was collapsed.
• OpenUrl: Fixed ability to open URLs on read-only records.
• PDFForm: Fixed ability to create PDFs on read-only records.

1 new fix

• Layout: Fixed Gear, Lookup, Max positioning. Q&A

8 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.
• 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.

1 new fix

• Config: Fixed handling of invalid config that could block dbFront access.

1 new fix

• Sessions: Fixed a regression that prevented session errors from opening the login dialog.

3 new fixes

• Menu: Improved error handling around Menu issues.
• MySql: Fixed Full-Text search regression.
• Stability: Improved null handling due to code review.

1 new feature

• Licensing: Alternate License codes to accommodate ComponentSource & FastSpring.

1 new fix

• Licensing: Corrected application of FREE license.

9 new features

• Decimals: Improved Decimal handling and ability to set Decimal rounding. Q&A
• 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.

5 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.
• Structure: Fixed regression with some column renames not correctly updating after a structure change.
• SQL: More concise SQL queries by reusing parameters.

4 new fixes

• 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.

2 new fixes

• Performance: Cache filtered rowcounts for 3 minutes or until change.
• Performance: Simplify filtered rowcount queries and remove unnecessary joins.

3 new fixes

• 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.

3 new features

• GridEditing: Optionally allow Grid changes to save immediately to the database. Q&A
• GridEditing: Use db prefs to mark GridEditing as [Disabled, SaveToCache, or SaveToDatabase].
• GridEditing: Optionally mark individual Grid fields as [Default, ReadOnly, or Editable].

2 new fixes

• UI: CSS fixes to cleanup field selection config UI.
• UI: Fixed About dialog so it correctly links to the ReleaseHistory.

1 new feature

• Caching: Ability to disable internal caching for externally updated tables.

2 new fixes

• Editing: Require a saved parent record before allowing child edits.
• Visibility: Ensure that visibility expressions are case insensitive.

2 new features

• StoredProcedure: Updated OpenTable to add Target option [Redirect, NewTab, Dialog].
• StoredProcedure: Added OpenUrl option to ServerRequest. See: Results

11 new fixes

• 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.

5 new features

• Fulltext: Added support for Full-Text indexes to dbFront. See: Fulltext-Search
• 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.

4 new fixes

• 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.

4 new features

• ProfileFields: Use Profile fields in Button or Layout visibility expressions. Q&A
• Reseller: Support reseller integration.
• UrlField: Optionally display Url field as inline iFrame or Image. Q&A
• UrlField: Optionally display Url field as Link. Q&A

3 new fixes

• BarCodeField: Fixed ability to change field layout.
• SQL Server: Fix handling of boolean procedure parameters.
• Visibility: Improved expression error handling.

2 new features

• ConfigBackup: Ability to export selected tables. Q&A
• ConfigBackup: Ability to export obfuscated data. Q&A

1 new fix

• Settings: Reset the Profile cache when saving settings.

4 new features

• 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.
• UI: Any configured database logos will appear in the user menu.

6 new fixes

• ActionButton: Allow Buttons with PassThrough fields on read-only records.
• Menu: Tables are now sorted by Caption instead of by name.
• Reporting: Fixed CSV export bug.
• Security: Log if users without a SAMAccountName are found.
• Settings: Ensure that fresh setting are loaded immediately after setting update.
• UI: Fixed Loading dialog.

6 new features

• Core: Update to DotNet 4.7.2
• 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.

3 new fixes

• Reporting: Fixed issue creating custom fields.
• Session: Gracefully handle browsers that block sessions and cookies.
• Tables/Views: Gracefully handle tables/views without any valid fields.

2 new features

• Import: Optionally skip database identifiers [caption, description, group, logo, css, template].
• Reporting: Optionally supply suitable sample data for the Report Templates.

12 new fixes

• Browser: Force browser to load latest resource versions.
• ChildTables: Ensure that hidden join fields are available for insert and update.
• ConfigBackup: Fix handling of empty databases.
• ExelExport: Fixed ability to access Excel template if other outputs also selected.
• Export: Ensure nulls are exported as nulls.
• Export/Import: Fixed ability to transfer M2M rel config between servers.
• GridEditing: Disable GridEditing in IE due to incompatibilities.
• Import: Force updated table row counts to ensure that import displays correct messages.
• Import: Fixed ability to insert into/set AutoIncrement fields.
• Import: Ensure the user understands that DDL is minimal and not exacting.
• KeyBoard: Ensure that keyboard save (Cntrl S) finds the current form.
• SaveButton: Ensure that the Parent Save button is updated after a child save.

3 new fixes

• CopyRecord: Carry forward lookup display values when copying records.
• GridEdit: Corrected Boolean handling.
• GridEdit: Fixed application of ReadOnly user connection access.

9 new fixes

• ConfigBackup: Fixed handling of databases without tables.
• ConfigBackup: Improved efficiency, reduced memory, and moved to a separate thread.
• Logging: Improved and more consistent SQL debug logging including query timings.
• Oracle: Fixed Oracle 19 compatibility.
• Oracle: Fixed performance while retrieving table structure updates.
• Oracle: Fix to correctly handle function-based indexes.
• Stability: Reworked internal locking to improve performance and stability.
• Stability: Configurable internal locking.
• UI: Added 'Loading' UI when opening any database or settings dialogue.

2 new fixes

• GridEdit: Correctly disable lookups on read-only tables.
• IE11: More fixes to provide backward compatibility to IE.

4 new fixes

• Config: Fixed handling of deleted fields on view changes.
• GridEdit: Fixed row select when GridEditing disabled.
• IE11: Added polyfill to fix IE 11 support.
• IE11: Fixed Syntax issue with function declaration ()=>{} to function (){}

7 new features

• GridEdit: The Field focus marker will turn orange instead of blue if the field is editable.
• Monitor: Additional server stats and alerts if appropriate.
• Security: Support for very large Active Directories (100,000+ members).
• Security: Ability to search for users and groups.
• 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.

15 new fixes

• Databases: Fixed visibility of newly added databases.
• GridEdit: Only allow grid editing of simple lookups with a RowCount <= 2000.
• Guid: Fixed conversion issue passing uniqueidentifiers to stored procedures.
• Install: Include core VirusTotal hashes and link.
• Lookups: Fixed issues with using GUIDs as M-M lookup keys.
• Lookups: Fixed handling of server lookups that keyed on non-PK fields.
• Lookups: Fixed handling of cached empty server lookups.
• Security: Truncate security debug logs to only provide a representative sample.
• System: Improved AD caching and usage.
• System: Moved AD validation tests to an alternate thread.
• System: Fixed memory calculation for Monitor.
• UI: Fixed arrow position on Advanced Search.
• UI: Fixed Splitter bar edge cases.
• Readme: Updated to include Release History.
• SMTP: Recover gracefully if the SMTP password can't be unencrypted.

5 new fixes

• Core: Fixed table.idx & database.idx locking.
• Expressions: Improved error messages with invalid expressions concatenation.
• GridEdit: Recreate Lookup Cache if expired.
• Lookup: Fixed use of child field names instead of parent on cascading lookups.
• Security: Change missing AD Forest to a warning.

1 new feature

• Table: Ability to use a table/view column to specify a Row CSS class. See: Table-Row-Styling

8 new fixes

• Editing: Fixed handing of reverted field changes.
• GridEdit: Retain cell focus after saving a change made via the table grid.
• GridEdit: Fixed Editing speed by removing full table retrieve.
• GridEdit: Fixed prompt to "Save or Discard" on primary records.
• GridEdit: Improved ability to use keyboard only while editing.
• RecordLocking: Fixed 1.1.0.2997 regression that caused a tested lock to be cleared.
• Sessions: Better handling of expired or dropped sessions.
• Settings: Improved error handling.

1 new feature

• Keyboard: CNTRL-Enter or SHIFT-CNTRL-S to save and open a new record. See: Keyboard

6 new fixes

• FIPS: Initial work on FIPS compliance
• GridEditing: Fixes for record locking.
• OnEdit: Fixes to OnEdit record locking.
• Public: Allow public page to be imbedded in an iFrame from another domain.
• RowSecurity: Fixed 1.1 regression that broke editing of RowSecurity expressions.
• TableView: Missing Column Error on table with View and sort.

7 new fixes

• Dates: Fixed "Invalid Date" errors.
• Formatting: Refactor the Field Handling when dealing with formatted data.
• Help: Fixed help on Lookup Fields
• Html: Fixes to HtmlSanitizer to improve cleaning.
• Migration: Fixes to facilitate migrating to 1.1.0
• 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.

2 new features

• GridEditing: Disable grid editing if row or table security prevents updates.
• GridEditing: Replaced 'selected' column class with 'focus' as used by the grid editing.

4 new fixes

• GridEditing: Fix 'Invalid Date' after editing.
• GridEditing: Fixed consistency with Boolean display.
• GridEditing: Handle editable grid fields not found in form.
• GridEditing: Handle grid returning fields that should not be editable.

12 new features

• WARNING: EARLY BETA RELEASE!
• Attachments: Add support for the RTF document type.
• Browser: Now use MomentJS for browser date handling.
• Layout: Added Splitter between Table and Details beside table.
• Layout: Change default layout to TableBesideDetails.
• Locking: Enable OnEdit locking. See: RecordLocking
• 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.
• Widgets: Updated libraries (Select2, MomentJS, DataTables.net, +++)
• Widgets: Replaced jQueryUI Date and Trent Richardson TimePicker widget.
• Widgets: Add TimeZoneEditing to the DataTable.net DateTimePicker.

3 new features

• ExcelExport: Export to an Excel xslx template. See: ExcelTemplates
• ExcelExport: Export around formula fields to allow for calculations and charts.
• ExcelExport: Optionally export to a specific sheet and range.

2 new fixes

• Lookup: Fixed use of child field names instead of parent on cascading lookups.
• TableView: Missing Column Error on table with View and sort.

4 new fixes

• ActiveDirectory: Fixed AD group performance, especially when debugging.
• Logging: Fix cases where an incomplete error stack was logged.
• Logging: Enhanced logging to help debug startup failures.
• Profiles: Correctly handle profile values that are also lookup values.

2 new features

• Attachments: Set FileNameField with name of uploaded file.
• ActionButtons: Allow some ActionButtons without a selected record.

8 new fixes

• Attachments: Fixed issue uploading attachments with non-unique magic numbers.
• CanInsert: Correctly clear unset CanInsert security.
• CreateLookup: Fixed lookup generation to use native data types.
• DeleteRow: Fixed ability to Delete without requiring Update access.
• Insert: Fixed FormCache error on double create new.
• Layout: Fixes for grouped field layout.
• RunProcedure: Run procedures without require a save of new unchanged records.
• SingleSignOn: Fixed page session expiry logic while running SSO.

2 new features

• FileTypes: Added support for the Visio (vsd, vsdx) file types.
• SingleSignOn: Save authentication email on profile creation.

7 new fixes

• ActionButtons: Fixed ability to click on Buttons with an unchanged blank row present.
• AzureSSO: Improved email address retrieval from authentication.
• Changes: Improved change detection.
• FileTypes: Improved FileType detection and usage.
• MySql: Use count(KeyFieldName) where possible to improve count() performance.
• SingleSignOn: Fixed handling of blocked referrer URL on Logout.
• SSL: Fixed HTTP CDN theme URL.

9 new features

• 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.
• 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.
• RunProcedure: Trim procedure name before saving.
• RunProcedure: Suggest checking for SP access if not found.

4 new fixes

• Cascading: Account for cascading lookups when setting default field order.
• Profile: Ensure static data is available for profile lookup fields.
• Schema: Allow using duplicate relationship constraint names between schemas.
• StaticData: M-M relationship changes now also trigger lookup refreshes.

1 new feature

• ActionButton: Allow RunProcedure action to trigger table open.

4 new fixes

• AdvancedSearch: Fix weird refresh on filter save/reload.
• Lookups: Fixed parent updates failing to reset cascading children.
• Relationships: Shorten generated relationship names.
• TablePref: Better error message if duplicate relationship hash on save.

2 new fixes

• Formatting: Fixed formatting of base Date datatypes to exclude time information.
• Setup: Extended Group field names to 64 characters.

2 new features

• Core: Updated to latest jQuery 3.4.1
• Reporting: Moved printing from WebApp to Service.

2 new fixes

• AdvancedSearch: Fixed incorrect empty selections.
• Reporting: Fixed incorrect printing label.

2 new features

• Settings: Migrated settings out of web.config, now editable via the settings UI. See: ConfigMigrate
• Settings: Site and Database logo settings apply to Login, Page Header and Reports.

3 new fixes

• ConfigXML: Better handling of invalid XML config files.
• Lookups: Fixed prompt on cascading dropdowns.
• Theme: Fixes to handle an invalid theme.

1 new fix

• FormLayout: Fixed group containers breaking across columns.

1 new feature

• CommandTimeout: Ability to configure a separate command timeout for each database connection. Q&A

3 new fixes

• MassUpdate: Fixed handing of dropped fields.
• SQLServer: Fixed len() issue with depreciated datatype 'IMAGE'.
• SQLServer: Fixed compare issue with depreciated datatype 'NTEXT'.

4 new features

• Backups: Warn if dbFront configuration files have not been backed up.
• PenetrationTesting: Changes to facilitate Penetration Testing.
• SingleSignOn: Ability for an SSO Admin to edit non-SSO connections.
• SysLog: Ability to set a SysLog Logging Level to reduce SysLog output.

12 new fixes

• Boolean: Show 'X' in the table for false boolean values.
• Dates: Fixed InvalidDate bug with tables that don't contain a key.
• Email: Allow testing with email address up to 59 characters.
• FormLayout: Fix Column Layout in Chrome and "New Edge"
• jQuery: Library Update
• Logging: Cleanup some unnecessary logging.
• PenetrationTest: Renamed SessionExpiry cookie to avoid invalid test results.
• RemberMe: Fixed regression that broke RememberMe
• Setup: Fixed ability to remotely edit settings if Server Admin and Setup not locked.
• SQLServer: Fixed ability to insert into key fields requiring a defined length.
• TableViews: Fixed Tooltips on TableViews.
• TimeSpan: Fixed handling of native TimeSpan columns.

1 new feature

• SingleSignOn: Add ability to set a logout redirect URL.

7 new features

• Admin: Monitor screen now includes summary statistics.
• 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.

5 new fixes

• Dropdowns: Fixed broken type ahead for dropdowns within dialogs.
• MySQL: Recognize and alert for missing SELECT permission on [mysql.proc]
• PasswordFields: Permit changing record contents without having to reenter password fields.
• Tables: Recognize when a filter change causes the table page to become invalid.
• Tables: Improve handing when all table columns are renamed or removed.

1 new feature

• Dropdowns: Lookup items that are filtered but used will be marked as deleted.

1 new feature

• Dropdowns: Add ability to filter dropdown values.

4 new fixes

• Dropdowns: Fixed ability to set dropdown sort order.
• MySQL: Revert SSL mode as it broke existing Non-SSL sites.
• SingleSignOn: Cosmetic fixes.
• SQLServer: Pass Null stored procedure params as DBNull.

5 new features

• SingleSignOn: Added SAML 2 based SSO functionality.
• SingleSignOn: Enabling SSO disables Windows and Database authentication.
• SingleSignOn: Request full login after logoff. (Not all SSO vendors support)
• SingleSignOn: Can setup a SSO Group to grant full Admin privileges.
• SingleSignOn: Can use SSO Groups to manage connection Update / Read access.

2 new fixes

• Layout: Fix issues with CSS classnames being dropped during render.
• MySQL: Set Connection SSL-Mode to Required for testing.

2 new features

• Reporting: Ability to set template margins in inches.
• Reporting: Include 4 report templates with install.

5 new fixes

• Reporting: Fixed page size entry at report time.
• Reporting: Fixed missing or invalid templates handling.
• Reporting: Fixed duplicate template custom fields handling.
• Reporting: Quote suggested attachment filename.
• Reporting: Ensure generated PDFs are only cached if identical.

1 new feature

• Reporting: Create and supply a default caption for quick reports.

2 new fixes

• Reporting: Move Template Images to Template folder.
• Reporting: Fix Template issue of default values returning after a null is saved.

8 new features

• Reporting: Print directly to any server attached printer by name.
• Reporting: Lock PrinterName and PageSize for Single-Click report printing.
• Reporting: Set orientation and size on all PDF or printed outputs.
• Reporting: Report Header and Footer support updated.
• Reporting: Print tab added to settings to manage available printers.
• Reporting: Template Preview in Editor is now 100% accurate.
• Reporting: Template Preview at template selection.
• Reporting: Updated HTML rendering engine.

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.

3 new fixes

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

13 new features

• 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: Layout groups now have conditional visibility.
• LayoutGroups: Conditional visibility can be Server based or Browser based.
• LayoutGroups: Create collapsible Layout Groups. Either Start Open or Start Closed.
• LayoutGroups: Add, remove, and rearrange fields in Layout Group editor.
• LayoutGroups: Easily reposition Layout Groups relative to existing fields.
• LayoutGroups: Hidden layout groups are still partially visible for Admins.
• 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.

8 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
• 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.

6 new fixes

• 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: Fix for Internet Explorer to allow Dialogs to properly overlay iFrame contents.
• 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.

2 new features

• MassUpdate: Delete or Update multiple records in a single transaction. See: MassUpdate
• MassUpdate: Advanced Filter is used to select the records to update or delete. See: MassUpdate

7 new features

• Buttons: Group Action buttons, Report buttons and Advanced Tool buttons separately.
• ButtonVisibility: Ability to manage button visibility based on security and data access.
• ButtonVisibility: Optionally override the data access to trigger locking for ReadOnly users.
• 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: Show relationship detail details in config dialog.
• RowCount: High speed rowcounts for large tables in Oracle, MySql and SQL Server.

1 new fix

• Profile: Ensure that the Profile menu items shows correctly.

3 new features

• Lookups: Improved support for deeper cascading lookups, See: CascadingLookups
• Lookups: Extra help and feedback when configuring lookups.
• SQLServer: Improved support for using a unique index if no PK present.

1 new fix

• Lookups: Fixed multilevel field dependencies.

3 new features

• Automatically drop locks if a user navigates away or closes a browser tab, See: RecordLocking
• Automatically attempts to recover locks on return navigation.
• Automatically purge expired locks.

4 new features

• RecordLocking: New Record Locking functionality. (On Enter), See: RecordLocking
• RecordLocking: Child records automatically locked if parent is locked.
• RecordLocking: [Help]/[Monitor] Page lists active record locks with details.
• RecordLocking: "On Enter" record locking is now used by default, See: RecordLocking

2 new fixes

• SQLServer: Fixed support for SQL Server 2000.
• QuickSearch: Clearing filter will now automatically reload full data set.

3 new features

• AdvancedSearch: Allow specifying NULL values for the advanced search.
• CustomButtons: Ensure help text is valid, safe and balanced HTML. Allow formatting.
• CustomButtons: Ensure Refresh Level works correctly for both RunProcedure and OpenURL buttons.

2 new fixes

• CustomButtons: Ensure attributes are correctly quoted.
• Menu: Profile Menu layout corrected.

4 new features

• CustomButtons: Set Help Text that displays as a tool-tip.
• CustomButtons: Set Css Classes that will enable extra styling options.
• Passwords: Warn if the Caps-Lock key is on.
• Settings: Added [SiteFooterHtml] to allow setting a site footer. See: Layout

1 new fix

• Connections: Hide disabled connections from non-admin users.

7 new features

• AdvancedSearch: Ability to save and reload Default Filter to Cookie or Profile.
• Icons: Replaced the jQuery Icons with jquery-ui-iconfont, for clarity and extra options.
• 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.

2 new fixes

• Errors: Correctly highlight invalid dropdowns.
• Refresh: Cleaned up button refresh options

4 new features

• Quotes: Optionally display helpful quotes.
• Settings: Added [SiteHeaderHtml] to allow setting a site header. See: Layout
• Settings: Added [SiteTheme] to allow setting a default site theme. See: Layout
• Settings: Added [SiteCssFile] to allow loading a site custom css file. See: Layout

7 new fixes

• Advanced Search: Show all fields when expanded.
• Expressions: Make it easier to insert expression keywords.
• Field: Added special "Guid" / "uniqueidentifier" handling.
• Views: Better handling of invalid views.
• Views: Fixed handling mixed case views names on Oracle.
• Oracle: Fix problems Deserializing Oracle errors.
• URLParams: Updated URL param encoding.

2 new fixes

• Culture: Correct Min value formatting.
• Oracle: Default numeric fields with undefined precision/scale to Number(16,4)

10 new features

• Culture: Added [CultureName] setting to manage the global culture. See: Culture
• Culture: WebSite culture will automatically follow the Service Culture.
• Culture: Web page culture will automatically follow the Service Culture.
• Culture: Added support for Numbers formats that use a comma as the decimal place holder.
• Culture: Optionally use a Html input[type='text'] for numbers. See: Layout
• Links: Help indicating that you can Right-Click on links to open in a new Tab or Window.
• Settings: Added [NewDatabaseVisibility] to manage new database visibility. See: DatabaseDefaults
• Settings: Added [NewTableType] to manage the default table type. See: DatabaseDefaults
• Settings: Added [NewFieldVisibility] to manage new field visibility. See: DatabaseDefaults
• Settings: Expanded Setting dialog to show most available settings. Editing to follow.

5 new fixes

• Culture: Fixed numeric validation in text fields.
• Numeric: Fixed MaxValue formatting.
• Table: Fixed config related 'Object Not Found' errors.
• Table: Handle sort order issues during table rendering.
• Table: Clearer error messages.