your database front-end

Server Outage Notice: dbFront.com will be transfering to a new Server on Friday 25th @ 7pm MST

Release History

This detailed Release History shows every intermediate Beta release.  For a summary showing only Feature and Stable releases, see: Release Summary.

The latest version of dbFront version is always available from the download page.

dbFront   Version: 1.2.2

2022-09-22 - dbFront   Version: 1.2.2.5613,  Beta,  Supported

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.

2022-09-19 - dbFront   Version: 1.2.2.5557,  Beta,  Supported

2 new fixes

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

2022-09-15 - dbFront   Version: 1.2.2.5463,  Beta,  Supported

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.

2022-07-19 - dbFront   Version: 1.2.2.4062,  Feature,  Supported

5 new fixes

  • Button: Fixed expression based (e.g. %username%) button visibility.
  • Debug: Extra error detail when rendering table properties.
  • Debug: Include ServerKey in connection dialog.
  • Layout: Fixed lookup button sizing.
  • PromptFields: Fixed issue saving non-passthrough prompt fields.

2022-05-27 - dbFront   Version: 1.2.2.2792,  Beta,  Supported

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.

2022-04-13 - dbFront   Version: 1.2.2.1744,  Beta,  Supported

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.

2022-03-24 - dbFront   Version: 1.2.2.1247,  Beta,  Supported

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.

2022-03-15 - dbFront   Version: 1.2.2.1045,  Beta,  Supported

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.

dbFront   Version: 1.2.1

2022-02-04 - dbFront   Version: 1.2.1.1145,  Feature,  Supported

1 new fix

  • MySql: Fixed FullText search when using multiple or non-matching indexes.

2022-01-28 - dbFront   Version: 1.2.1.1094,  Beta,  Supported

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 "@[email protected]" 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

2022-01-18 - dbFront   Version: 1.2.1.0737,  Beta,  Supported

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.

2022-01-15 - dbFront   Version: 1.2.1.0685,  Beta,  Supported

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.
  • FieldGroup: Fixed support for Multi-Select fields.
  • FieldGroup: Fixed layout issue where extra-wide Lookup or Multi-Select fields could mess up the layout.
  • 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.
  • 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.

2022-01-07 - dbFront   Version: 1.2.1.0488,  Beta,  Supported

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.

2021-12-21 - dbFront   Version: 1.2.1.0088,  Beta,  Supported

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.

dbFront   Version: 1.2.0

2021-11-22 - dbFront   Version: 1.2.0.0730,  Beta,  Supported

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.

2021-11-06 - dbFront   Version: 1.2.0.0343,  Beta,  Supported

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.

dbFront   Version: 1.1.5

2022-07-14 - dbFront   Version: 1.1.5.6912,  Stable,  Supported

1 new fix

  • Button: Fixed expression based (e.g. %username%) button visibility.

2022-07-04 - dbFront   Version: 1.1.5.6687,  Beta,  Supported

1 new fix

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

2022-01-26 - dbFront   Version: 1.1.5.2865,  Stable,  Supported

1 new fix

  • MySQL: Fallback if driver doesn't support .BeginTransaction(IsolationLevel)

2022-01-15 - dbFront   Version: 1.1.5.2601,  Beta,  Supported

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.

2021-11-19 - dbFront   Version: 1.1.5.1237,  Beta,  Supported

1 new fix

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

2021-11-11 - dbFront   Version: 1.1.5.1042,  Feature,  Supported

1 new fix

  • Numeric: Fixed a regression that broke the ability to update a null numeric value.

2021-11-01 - dbFront   Version: 1.1.5.0805,  Beta,  Supported

1 new fix

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

2021-10-27 - dbFront   Version: 1.1.5.0689,  Beta,  Supported

3 new fixes

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

2021-10-06 - dbFront   Version: 1.1.5.0183,  Beta,  Supported

1 new feature

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

1 new fix

  • Licensing: Corrected application of FREE license.

2021-09-29 - dbFront   Version: 1.1.5.0013,  Beta,  Supported

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.

dbFront   Version: 1.1.4

2021-08-24 - dbFront   Version: 1.1.4.1116,  Feature,  Supported

2 new fixes

  • Excel: Fixed server formatted numeric columns in Excel exports.
  • Reporting: Fixed child column data in both Multiline and SingleRow reports.

2021-08-18 - dbFront   Version: 1.1.4.0951,  Beta,  Expired

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.

2021-07-29 - dbFront   Version: 1.1.4.0477,  Beta,  Expired

2 new fixes

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

2021-07-27 - dbFront   Version: 1.1.4.0452,  Beta,  Expired

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.

2021-07-21 - dbFront   Version: 1.1.4.0298,  Beta,  Expired

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.

dbFront   Version: 1.1.3

2021-07-07 - dbFront   Version: 1.1.3.0880,  Beta,  Expired

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.

2021-06-22 - dbFront   Version: 1.1.3.0521,  Beta,  Expired

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.

2021-06-04 - dbFront   Version: 1.1.3.0091,  Beta,  Expired

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.

dbFront   Version: 1.1.2

2021-05-10 - dbFront   Version: 1.1.2.1304,  Beta,  Expired

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.

2021-04-08 - dbFront   Version: 1.1.2.0596,  Feature,  Supported

3 new features

  • RunProcedure: Optionally print/download a Quick Report from Stored Procedures. Q&A
  • RunProcedure: Optionally create a Export (csv, xlsx) from Stored Procedures.
  • LogViewer: Oversized logfiles now truncated to the last 5000 lines.

8 new fixes

  • MassUpdate: Fixed layout issue.
  • MimeType: Fixed detection of tiny inputs.
  • Reporting: Fixed PrinterName selection on multiple output types.
  • Report/Export: Improved handling of Blob objects that are not images.
  • Search: Search performance improvements on large tables
  • Themes: Fixed incorrect (CDN) marker on local themes.
  • Template: Ignore split template fields in scripts.
  • UI: Faster Reload of Dialog Tabs

2021-03-26 - dbFront   Version: 1.1.2.0273,  Beta,  Expired

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.

2021-03-24 - dbFront   Version: 1.1.2.0214,  Beta,  Expired

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.

dbFront   Version: 1.1.1

2021-03-27 - dbFront   Version: 1.1.1.3430,  Stable,  Supported

1 new fix

  • Reporting: Fixed CSV export bug

2021-03-15 - dbFront   Version: 1.1.1.3232,  Feature,  Supported

2 new features

  • Security: Can now request a immediate refresh of users, groups and SIDs.
  • Visibility: Enhanced Expression options for Field and Button visibility

12 new fixes

  • Config: Detect invalid ServicePort values (80, 443).
  • Import: Improved relationship matching logic.
  • Import: Optionally strip references to missing views.
  • Import: Better at reusing original relationship names.
  • 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.
  • SqlServer: Improved default support.

2021-02-25 - dbFront   Version: 1.1.1.2804,  Beta,  Expired

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.

2021-02-11 - dbFront   Version: 1.1.1.2464,  Beta,  Expired

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.

2021-01-08 - dbFront   Version: 1.1.1.1644,  Beta,  Expired

3 new fixes

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

2020-12-29 - dbFront   Version: 1.1.1.1398,  Beta,  Expired

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.

2020-12-12 - dbFront   Version: 1.1.1.0997,  Beta,  Expired

2 new fixes

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

2020-12-02 - dbFront   Version: 1.1.1.0758,  Beta,  Expired

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 (){}

2020-12-01 - dbFront   Version: 1.1.1.0731,  Beta,  Expired

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.

dbFront   Version: 1.1.0

2020-10-28 - dbFront   Version: 1.1.0.3587,  Feature,  Supported

6 new fixes

  • GridEdit: Reject invalid cache changes.
  • GridEdit: Fixed capture of primary record changes.
  • GridEdit: Fixed confusion caused by excess mouse clicks.
  • Logging: Updates to startup logging.
  • Settings: Fixed enabling/disabling alerts.
  • SplitterBar: Cleanup errors due to older browsers.

2020-10-17 - dbFront   Version: 1.1.0.3319,  Beta,  Expired

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.

2020-10-13 - dbFront   Version: 1.1.0.3232,  Beta,  Expired

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.

2020-10-03 - dbFront   Version: 1.1.0.2997,  Beta,  Expired

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.

2020-09-25 - dbFront   Version: 1.1.0.2818,  Beta,  Expired

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.

2020-09-09 - dbFront   Version: 1.1.0.2416,  Beta,  Expired

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.

2020-08-20 - dbFront   Version: 1.1.0.1978,  Beta,  Expired

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.

2020-06-18 - dbFront   Version: 1.1.0.0418,  Beta,  Expired

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.

dbFront   Version: 1.0.15

2021-03-16 - dbFront   Version: 1.0.15.9130,  Stable,  Supported

1 new fix

  • Reporting: Fixed issue creating custom fields.

2020-12-18 - dbFront   Version: 1.0.15.7020,  Stable,  Supported

1 new fix

  • Oracle: Fixed bug obtaining Oracle 19 server details.

2020-10-30 - dbFront   Version: 1.0.15.5851,  Stable,  Supported

1 new fix

  • Release packages now include VirusTotal hashes and Updated readme

2020-10-16 - dbFront   Version: 1.0.15.5510,  Beta,  Expired

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.

2020-09-25 - dbFront   Version: 1.0.15.5006,  Feature,  Supported

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.

2020-06-10 - dbFront   Version: 1.0.15.2420,  Feature,  Supported

2 new fixes

  • Expressions: Fixed handling of missing expression values.
  • RowSecurity: Update the CanDelete and CanUpdate config UI to require a PK.

2020-06-01 - dbFront   Version: 1.0.15.2218,  Beta,  Expired

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.

2020-05-24 - dbFront   Version: 1.0.15.2015,  Beta,  Expired

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.

2020-05-14 - dbFront   Version: 1.0.15.1796,  Beta,  Expired

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.

2020-05-04 - dbFront   Version: 1.0.15.1551,  Feature,  Supported

1 new feature

  • SQL: To help debug performance issue, SQL logging now includes duration.

5 new fixes

  • Expressions: Fixed regression caused by updated field quoting.
  • HTML: Removed invalid closing tags.
  • RecordLocking: Improved record hash uniqueness to correct number of records locked.
  • SingleSignOn: Corrected AzureAD group retrieval, also works for the Free AzureAD.
  • SingleSignOn: Fixed application of privileges to SSO users.

2020-04-28 - dbFront   Version: 1.0.15.1405,  Beta,  Expired

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.

2020-04-16 - dbFront   Version: 1.0.15.1119,  Beta,  Expired

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.

2020-04-01 - dbFront   Version: 1.0.15.0736,  Beta,  Expired

2 new fixes

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

2020-03-20 - dbFront   Version: 1.0.15.0470,  Beta,  Expired

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.

dbFront   Version: 1.0.14

2020-03-19 - dbFront   Version: 1.0.14.3540,  Stable,  Supported

3 new fixes

  • Layout: Fixed oversized table caption breaking layout.
  • Layout: Fixed truncated content in short fields due to wide characters.
  • Settings: Improved error handling when loading service settings.

2020-03-12 - dbFront   Version: 1.0.14.3353,  Beta,  Expired

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.

2020-03-05 - dbFront   Version: 1.0.14.3201,  Beta,  Expired

1 new fix

  • FormLayout: Fixed group containers breaking across columns.

2020-02-25 - dbFront   Version: 1.0.14.2990,  Beta,  Expired

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

2020-02-17 - dbFront   Version: 1.0.14.2801,  Beta,  Expired

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.

2020-01-24 - dbFront   Version: 1.0.14.2216,  Feature,  Supported

8 new fixes

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

2020-01-08 - dbFront   Version: 1.0.14.1844,  Feature,  Supported

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

2019-12-20 - dbFront   Version: 1.0.14.1386,  Feature,  Expired

3 new fixes

  • Setting: Fix fields that were not disabled in read-only view.
  • SingleSignOn: Improved logging and help.
  • Table: Fixed invalid "No data on page 1, please select a previous page"

2019-12-19 - dbFront   Version: 1.0.14.1360,  Beta,  Expired

1 new feature

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

2019-12-18 - dbFront   Version: 1.0.14.1337,  Beta,  Expired

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.

2019-11-15 - dbFront   Version: 1.0.14.0541,  Beta,  Expired

1 new feature

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

2019-11-12 - dbFront   Version: 1.0.14.0475,  Beta,  Expired

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.

2019-11-08 - dbFront   Version: 1.0.14.0369,  Beta,  Expired

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.

dbFront   Version: 1.0.13

2019-10-21 - dbFront   Version: 1.0.13.1221,  Feature,  Expired

4 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: Preload default Papersizes even if no printer drivers available or accessible.

5 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: Fixed ability to manage Report child field details.
  • Reporting: Clear Template selection when not need to avoid errors.

2019-10-11 - dbFront   Version: 1.0.13.0977,  Beta,  Expired

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.

2019-09-27 - dbFront   Version: 1.0.13.0645,  Beta,  Expired

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.

2019-09-20 - dbFront   Version: 1.0.13.0437,  Beta,  Expired

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.

dbFront   Version: 1.0.12

2019-11-20 - dbFront   Version: 1.0.12.1940,  Stable,  Supported

1 new fix

  • Oracle: Pass True/False as 1/0 to avoid boolean conversion issues.

2019-10-31 - dbFront   Version: 1.0.12.1455,  Stable,  Supported

1 new fix

  • Importing: Continue import even if a forward/reverse lookup can't be created.

2019-10-21 - dbFront   Version: 1.0.12.1220,  Feature,  Expired

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.

2019-09-26 - dbFront   Version: 1.0.12.0612,  Feature,  Expired

5 new features

  • MySQL: Tested with new 8.xx connectors
  • QuickImport: Allow for "Import Only", "Update Only", and "Update or Import"
  • QuickImport: Ignore casing on field names.
  • QuickImport: Allow lookup handing on text and other field types.
  • 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.

2019-09-07 - dbFront   Version: 1.0.12.0161,  Feature,  Expired

1 new fix

  • QuickPrint: Fixed template selection.

2019-09-06 - dbFront   Version: 1.0.12.0139,  Beta,  Expired

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.

dbFront   Version: 1.0.11

2019-08-28 - dbFront   Version: 1.0.11.0653,  Feature,  Expired

3 new fixes

  • 1-1: Fixed issue configuring preferences on 1-1 rels.
  • IE 11: Fixed access to config options.
  • MySQL: Fixed ability to use non-standard ports.

2019-08-17 - dbFront   Version: 1.0.11.0389,  Beta,  Expired

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.

2019-08-03 - dbFront   Version: 1.0.11.0052,  Beta,  Expired

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.

dbFront   Version: 1.0.10

2019-07-09 - dbFront   Version: 1.0.10.1332,  Stable,  Expired

1 new fix

  • Oracle: Correctly retrieve string Unique/PK values after insert.

2019-06-15 - dbFront   Version: 1.0.10.0764,  Feature,  Expired

4 new features

  • Buttons: Disable Save & Discard buttons when there is nothing to save.
  • CreateCopy: Append " (copy)" or " (copy N)" to Unique text columns instead of clearing.
  • MassUpdate: Added a confirmation page to the Edit Wizard.
  • MassUpdate: Now checks for unsaved changes.

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

2019-06-11 - dbFront   Version: 1.0.10.0665,  Beta,  Expired

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

2019-06-05 - dbFront   Version: 1.0.10.0508,  Beta,  Expired

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.

2019-05-24 - dbFront   Version: 1.0.10.0235,  Beta,  Expired

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.

2019-05-18 - dbFront   Version: 1.0.10.0075,  Beta,  Expired

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.

2019-05-16 - dbFront   Version: 1.0.10.0046,  Beta,  Expired

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.

dbFront   Version: 1.0.9

2019-05-07 - dbFront   Version: 1.0.9.1628,  Feature,  Expired

10 new fixes

  • Attachments: Fixed error after upload rejected due to size.
  • Dropdowns: Reset/Clear child cascading dropdown if parent changed.
  • Dropdowns: Fixed error when typeahead cancels a resultset to request an update.
  • FormCache: Fixed saving cache with missing attachment data.
  • FormCache: Fixed reloading after a custom update.
  • Passwords: Detect browsers without Caps-Lock detection and disable.
  • PDFForms: Default Field.Flatten to "Assigned" to cover PDF Viewers that can't show form fields.
  • PDFForms: Fixed flattening too many fields.
  • Profile: Remove invalid fields from Database Profiles settings.
  • SQL: Automatically replace NULL parameter values with NULL on insert.

2019-04-10 - dbFront   Version: 1.0.9.0973,  Beta,  Expired

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.

2019-04-01 - dbFront   Version: 1.0.9.0768,  Beta,  Expired

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.

2019-03-29 - dbFront   Version: 1.0.9.0688,  Beta,  Expired

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

dbFront   Version: 1.0.8

2019-03-11 - dbFront   Version: 1.0.8.4605,  Stable,  Expired

2 new features

  • Insert: Enable use of uniquely indexed single fields to find inserted record.
  • URL: Allow SchemaName.TableName on url. See: DeepLinking

16 new fixes

  • Dates: Fixed read-only dates triggering changes.
  • Goto: Corrected Goto Button visibility on new records.
  • Guid: Correctly handle Guid fields for compare.
  • Index: Ensure that Unique Fields are recognized.
  • LogViewer: Fixed menu item.
  • Oracle: Correctly quote Output Field on Insert.
  • Oracle: Updated ability to retrieve Inserted Sequence, Guid or other values.
  • Oracle: Skip calling Oracle %sequence%.NextVal expressions to avoid gaps.
  • Page: Fixed page load artifacts.
  • Schema: Fix Index check that was not schema aware.
  • Schema: Fix Relationship check that was not schema aware.
  • SetValue: Fix 'RowHash not set' error saving a value.
  • SqlServer: Correctly quote Output Field on Insert.
  • Table: Cleaner errors when saving table properties.
  • Table: Reset existing errors when saving table properties.
  • Update: Fix Keyless record update.

2019-02-28 - dbFront   Version: 1.0.8.4343,  Beta,  Expired

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.

2019-02-16 - dbFront   Version: 1.0.8.4057,  Beta,  Expired

2 new fixes

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

2019-02-12 - dbFront   Version: 1.0.8.3957,  Beta,  Expired

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.

2019-01-19 - dbFront   Version: 1.0.8.3374,  Feature,  Expired

1 new feature

  • Fields: More details for 'Autoincrement' fields.

6 new fixes

  • Editing: Handle "User" reversed changes correctly.
  • Editing: Fixed 'RowHash not set' when creating new records in some specific cases.
  • Schema: Fix Object Not found when looking for a table name.
  • Schema: Turn of Schema/Owner if MySQL or if not multiple schemas
  • Table Rendering: Handle sort order issues during table rendering.
  • UI: Fixed hiding of all close icons on UI confirmations.

2018-12-24 - dbFront   Version: 1.0.8.2763,  Beta,  Expired

7 new features

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

3 new fixes

  • Attachment: Fix "Can't load attachment" errors.
  • Attachment: Ensure attachments are saved on new or copied records correctly.
  • Schema: Make the Database Preferences schema aware.

2018-11-18 - dbFront   Version: 1.0.8.1877,  Beta,  Expired

10 new features

  • AuditFields: Update Audit Fields for MultiSelect changes.
  • AuditFields: Update Audit Fields for child record updates.
  • ConfigBackup: Automated Database Config backups on change + cleanup.
  • Connection: Allow users with Setup Access to enable / disable connections.
  • PDFForms: Enable basic expressions [%username%, {date()}, {datetime()}]
  • PDFForms: Use database DateFormat for expressions.
  • Relationships: Ignore redundant relationships to self.
  • ReportTemplate: Make UI clearer.
  • Security: Ensure that CRITICAL notices are visible to all authenticated users.
  • Security: Hide Connection / Database items instead of raising security warnings.

8 new fixes

  • 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.
  • Startup: Detect invalid Service / UI combinations.
  • Saving: Fixed repeated save notice.
  • Themes: Fix Table Beside Details Display with Dark Background Themes

2018-10-23 - dbFront   Version: 1.0.8.1268,  Beta,  Expired

12 new features

  • 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.
  • Export/Import: Add explicit schema information.
  • Expressions: Shortcut certain expressions to save on server roundtrips.
  • PDF Forms: Support for filling in PDF Forms, optionally flatten fields.
  • Reporting: Selecting Report or PDF templates automatically reloads custom field list.
  • Reset Changes: Ability to reset form changes.
  • 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.
  • SaveButton: Save buttons now include change counts that also reflect child rows.

7 new fixes

  • Schema: Various fixes to make dbFront more Schema aware.
  • Expressions: Improved Expression Testing.
  • Reporting: Correctly evaluate formatted custom field values.
  • Filters: Enable Filters on M-M and MultiKey relationships.
  • SQL Script: Improved Formatting.
  • Errors: Made Error Logging more extensive.
  • FormFields: Detect if MultiKey lookup fields are out of order.

dbFront   Version: 1.0.7

2018-12-10 - dbFront   Version: 1.0.7.3902,  Feature,  Expired

1 new fix

  • StoredProcedure: Fix Table Results view returning incorrect data.

2018-12-03 - dbFront   Version: 1.0.7.3737,  Feature,  Expired

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

2018-11-03 - dbFront   Version: 1.0.7.3005,  Feature,  Expired

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.

2018-09-26 - dbFront   Version: 1.0.7.2092,  Feature,  Expired

2 new features

  • DateTimeOffset: Added support for the SQL Server DateTimeOffset datatype.
  • CSV Import: Add support for multiline CSV values.

2 new fixes

  • CSV Import: Identity Insert Fixes.
  • DateTime Widget: DateTime widget to only show the hours/minutes/seconds and TimeZone only if required.

2018-09-07 - dbFront   Version: 1.0.7.1646,  Beta,  Expired

3 new features

  • CSV Import: Handle importing into child tables. (Requires matching or empty Parent Key)
  • SQL Server Database Import: Automatically handle identity insert on Database Imports
  • Save Prompt: Automatically prompt to save when switching to new row. Include child rows.

3 new fixes

  • CSV Import: Fixed importing empty values.
  • Long Integers: Correctly handle 64 Integers.
  • Field Sizes: Fixed calculation for Numeric Field sizes.

2018-09-01 - dbFront   Version: 1.0.7.1502,  Beta,  Expired

5 new fixes

  • M-M: Fixed Param error on delete when key value hidden.
  • Lookup Captions: Fixed truncation of Lookup display values.
  • CSV Import: Fixed importing when last column contains empty values.
  • CSV Import: Import Nulls correctly.
  • Table Sort: Correctly sort initial table data if sort columns are not in table.

2018-08-22 - dbFront   Version: 1.0.7.1263,  Beta,  Expired

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

1 new fix

  • Lookup: Fixed 404 error when retrieving Lookup data for complex forms.

2018-08-14 - dbFront   Version: 1.0.7.1082,  Beta,  Expired

2 new features

  • SQL Server: Return the Check Constraint's Description as part of Constraint Failure errors.
  • Update/Insert: Improved formatting of Update / Insert errors.

4 new fixes

  • CacheErrors: Prompt to reload when the cache is dropped by a Refresh.
  • Defaults: Don't evaluate/save defaults for read-only fields.
  • History: Ensure history (back button) is not served from cache.
  • Logging: Log correct SQL Params for errors in multipart updates.

2018-08-07 - dbFront   Version: 1.0.7.0901,  Beta,  Expired

3 new features

  • 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.
  • UsageAgreement: Default to false instead of unchecked to make it easier to notice.

7 new fixes

  • Export: Skip M-M pseudo fields on export.
  • iFrame: Fixed invalid XSS error when running in iFrame.
  • Logging: Log correct SQL for errors in multipart updates.
  • M-M rels: Fixed "Single Row Expected" error for M-M rels.
  • M-M Widgets: Fixed the saving of field Caption.
  • Schema Names: Properly quote unsafe schema names, e.g. [top.gun]
  • Warnings: Hide warnings the user can't do anything about. They will still be in the logs.

2018-07-26 - dbFront   Version: 1.0.7.0605,  Beta,  Expired

5 new features

  • One-To-One: Display 1-1 relationships as a form in a tab that automatically follows the main record.
  • Many-To-Many: Ability to create and drop M-M relationships via a Multiselect.
  • Search & Reporting: Ability to select multiple options for searching and reporting.
  • Core: Ability to detect associate tables.
  • Config: Extend Relationship dialog to show the relationship type details.

3 new fixes

  • Unknown Types: Mark unsupported field types as TextRaw to avoid issues.
  • One-To-One: Fixed the ability to view/edit One To One relationships.
  • Select: The arrows on disabled Select widgets now hidden.

dbFront   Version: 1.0.6

2018-11-01 - dbFront   Version: 1.0.6.5901,  Stable,  Expired

1 new feature

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

1 new fix

  • Profile: Fixed "Can't check Profile" errors.

2018-07-04 - dbFront   Version: 1.0.6.3018,  Stable,  Expired

2 new features

  • SQLServer: Include Microsoft.SqlServer.Types for greater type support.
  • MySQL: Added support for the 8.0 MySQL Connectors.

2 new fixes

  • Help: Updated all Help URLs to HTTPS to avoid mixed security errors.
  • SQLServer: Fixed length error with GUID columns.

2018-07-02 - dbFront   Version: 1.0.6.2854,  Beta,  Expired

2 new features

  • AD: Ability to specify AD User Container.
  • AD: More detailed error logging to help debug issues.

2 new fixes

  • Lookup: Force refresh of static data with new dbFront version.
  • URL: Fixed d=%database% url parameter.

2018-06-22 - dbFront   Version: 1.0.6.2716,  Beta,  Expired

2 new features

  • URL: Added a URL parameter to permit opening a specific table and triggering a search.
  • Database: Added an option to Reset all Database settings and reload.

1 new fix

  • ActionButton: Fixed visibility logic.

2018-06-19 - dbFront   Version: 1.0.6.2644,  Beta,  Expired

14 new features

  • ActionButtons: RunProcedure buttons can now display procedure results as a Message, HTML Dialog or Table.
  • ActionButtons: Visibility of all buttons can now be controlled dynamically.
  • Boolean: Allow any Integer or Text field to be treated as a boolean.
  • Login: Display Authentication Domain similar to Windows Logon. Disable with "ShowDomainName".
  • Oracle/Number: Better Precision/Scale default for Oracle numbers without Precision/Scale.
  • Reporting: Allow setting of a Logo File.
  • Reporting: Add Custom Field support to Report Templates e.g. {%CustomField%}
  • Reporting: Wrap field values with type information. (To allow formatting via CSS)
  • Setup: Ability to setup Authentication via UI before Login. Only available on hosting WebServer. Disabled with "SetupLocked".
  • Setup: Ability to test Authentication changes before applying. Immediate detailed feedback.
  • UI: Validate the Logo and Css file type and existence.
  • UI: Allow setup of Redirect to a Table when opening a database.
  • Update Notice: The Update notice is now hidden from non-admin users.
  • Use Impersonation to save the config settings as a Server Admin.

19 new fixes

  • Config: Better error messages for missing or invalid views.
  • Config: Automatic config recovery in the event that only a few elements are invalid.
  • Config: Backup invalid config for debug purposes.
  • Config: Sort the contents of Config dropdowns.
  • CSS: Minor tweaks to improve the UI.
  • DatabaseExport: Skip full table scan if no data is exported.
  • Export/Import: Better UI defaults.
  • Export/Import: Don't export View Fields.
  • Help: Updated Help Links.
  • Joins: Better error handling if Joins are invalid.
  • Login: Fix "Can't get SID" errors on reload.
  • Lookups: Fixed lookup creation with complex sorts.
  • Refresh: Triggering a refresh will also purge the cache.
  • MySQL: Fixed support for Boolean types.
  • Oracle: Corrected Relationship handing on MultiKey relationships.
  • QuickExport: Fixed Excel file type error.
  • Security: Hide Connection buttons (Access, Refresh) if security does not allow access.
  • Validation: Fix issue with a corrected select blocking a save.
  • UI: Minor UI Fixes.

2018-03-24 - dbFront   Version: 1.0.6.0569,  Beta,  Expired

3 new features

  • Help: Sidebar Help.
  • Help: Custom Table Help.
  • Setup: Lightly Highlight all setup widgets when hovering over any.

5 new fixes

  • Databases: Cleaner messages when a database is off-line.
  • Dialogs: Set a more reasonable minimum width.
  • Help: More relevant in app help links.
  • Menu: Renamed 'Simple View' to 'User View'.
  • UI: Minor cleanup tweaks.

dbFront   Version: 1.0.5

2018-04-25 - dbFront   Version: 1.0.5.1492,  Stable,  Expired

1 new feature

  • Export: Export extra flags (nullable, autoincrement).

3 new fixes

  • Connection: Correct initial connection creation bug.
  • MySQL: Fixed ability to recognize Auto Increment fields.
  • Version: Updated to use latest protocols for version check + smart fallback.

2018-03-29 - dbFront   Version: 1.0.5.0864,  Stable,  Expired

3 new fixes

  • Security: Fix 'Can't get SID' errors on service reload.
  • DatabasePrefsUI: Fix "An item with the same key has already been added" error due to invalid config.
  • TableUI: Better handling of data errors at client side.

2018-03-23 - dbFront   Version: 1.0.5.0713,  Beta,  Expired

5 new fixes

  • Defaults: Fixed errors retrieving some default defaults.
  • Numbers: Fixed ability to enter negative numeric values.
  • Oracle: Fixed "ORA-01008: not all variables bound", Default to name based binding.
  • RememberMe: Default to false instead of unknown.
  • RowSecurity: Hide child rows when a main row becomes hidden due to row security.

2018-03-15 - dbFront   Version: 1.0.5.0531,  Beta,  Expired

2 new fixes

  • Main: Fixed incomplete structure loads which could prevent application load.
  • Import: Fixed import error where relationships were missing.

2018-03-11 - dbFront   Version: 1.0.5.0413,  Stable,  Expired

1 new fix

  • Reporting: Fixed error with missing where conditions.

2018-03-05 - dbFront   Version: 1.0.5.0282,  Beta,  Expired

1 new fix

  • SQL Server: Fixed invalid SQL when doing a Table Sort on Sorted Lookups.

2018-03-02 - dbFront   Version: 1.0.5.0211,  Beta,  Expired

2 new features

  • Licensing: Added support for site licenses based on an Email address and dbFront version.
  • Default: Updated default handling to pre-evaluate constant expressions.

2018-02-28 - dbFront   Version: 1.0.5.0158,  Beta,  Expired

7 new features

  • CheckBox: Tri-State (Yes / No / Null) check boxes. Note: Oracle does not understand the concept of a Null Boolean.
  • CheckBox: Larger via CSS.
  • Defaults: Evaluate and display database defaults on new records.
  • Config: Alert user when field is required on the database.
  • Filtering: Allow Numeric and Date ranges. If only the second value is specified then Nulls are permitted. If the second date excludes a time portion then it will be treated as End of Day.
  • Reporting: Add selected parameters to report header.
  • Reporting: Add options: %ReportParameterRows%, %ReportDate%, %ReportTime%

6 new fixes

  • Layout: Ensure Titles and other elements are encoded.
  • ObjectNames: Improved handling of unusual [schema, table, view or column] names. Skip objects that use text or schema quote characters as part of their name.
  • Reports: Better handling of invalid user options.
  • RowSecurity: Fixed missing SQL security parameters on related tables.
  • Security: Extra logging to help identify authentication source.
  • Themes: Fixed us of old jQueryUI style sheet link.

dbFront   Version: 1.0.4

2018-02-23 - dbFront   Version: 1.0.4.1031,  Stable,  Expired

2 new fixes

  • RowSecurity: Fixed missing SQL security parameters on related tables.
  • Themes: Fixed use of old jQueryUI style sheet link.

2018-02-20 - dbFront   Version: 1.0.4.0952,  Stable,  Expired

2 new fixes

  • MySQL: Fixed View Retrieval on MYSQL.
  • UI: Small fixes to Field Layout.

2018-02-15 - dbFront   Version: 1.0.4.0835,  Beta,  Expired

8 new fixes

  • Views: Adding views no longer corrupts other config.
  • Views: Catch more instances of View Fields in use before dropping.
  • UserList: Better handling of overly large user lists.
  • DateFormats: Fixed US dates to use slashes instead of dashes.
  • Value Formatting: Improved Formatting support.
  • Session: Cleaner Session Failed handling.
  • WebUI: Better feedback when reloading.
  • QuickImport: Corrected handling of Byte Order Marker.

2018-01-27 - dbFront   Version: 1.0.4.0378,  Beta,  Expired

5 new features

  • Views: Ability to join views to tables. Added fields can be used anywhere.
  • Expression Editor: Easily add properly formatted fields by clicking on a list.
  • Reports: Improved handling for dropped fields in reports.
  • CSV Import: Improved validation for CSV imports.
  • MySQL Connector: Now support all 6.xx.xx versions

4 new fixes

  • Web.Config: Fixed error that prevented load.
  • Admin UI: Fixes to selection lists for extra long items.
  • Logging: Improved Error messages.
  • Group Security: Improved Error messages.

2018-01-16 - dbFront   Version: 1.0.4.0124,  Beta,  Expired

4 new features

  • Relationships: Added ability to Rename, Reorder or Hide relationships.
  • Quick Import: Added the ability to import CVS formatted data directly to a table.
  • Table Views: Added config support for selecting a View for a Table.
  • Upload Config: Extra Webserver checks when setting up Max upload sizes.

6 new fixes

  • Editing: Fixed so that Action buttons don't trigger a save on new untouched rows.
  • Exporting: Improved Config transfer when moving data.
  • Upload: Fixed Upload UI for non-image attachment types.
  • Upload Config: Fixed incorrect config size checks.
  • UI: Minor UI style fixes.
  • CSV Export: Corrected CSV quoting.

dbFront   Version: 1.0.3

2018-01-10 - dbFront   Version: 1.0.3.2418,  Stable,  Expired

1 new feature

  • SysLog: Added support for a SysLog Server.

4 new fixes

  • Data: Fixed occasional incorrect rowcount and missing top row.
  • Config: Fixed some settings that required a restart to apply.
  • Logging: Properly flag Debug rows for SysLog.
  • Reporting: Fixed error reporting on empty table.

2018-01-05 - dbFront   Version: 1.0.3.2301,  Beta,  Expired

9 new features

  • Readme: Updated with extra trouble shooting instructions.
  • Connection: Added ability to temporarily Disable/Reenable.
  • SupportUrl: Now Optional (Disabled by Default).
  • Feedback: Disabled when non-default HelpURL.
  • Attachments: Improved attachment support (detection and uploading).
  • Login: Add ability to disable "RememberMe".
  • Login: Add optional "Notice" above UserName.
  • Free License: Easier access to Free License.
  • LogViewer: Integrated Log Viewer to simplify debugging.

11 new fixes

  • Session Count: Updated logic so the session count is more accurate.
  • Profile: Fixed loading errors when dbFront is restarted.
  • DatabaseList: Refreshed status with each load.
  • ActionButtons: Allow actions when no record is selected.
  • Large Userlist: If the userlist is > 5000 then require management by group.
  • Keyring Error: Automatically prompt with 'Reload' instead of 'Ok'
  • Upload Dialog: Hide DragN'Drop if no image attachment types selected.
  • Oracle: Fixed duplicate index error while inserting.
  • Oracle: Fixed rowcount retrieval.
  • Logging: Improved Logging on insert/update failures.
  • Import/Export: Various fixes to improve compatibility.

1 new security update

  • Groups: Fixed incorrect Group SID which expanded access to all group users.

2017-12-07 - dbFront   Version: 1.0.3.1607,  Beta,  Expired

5 new features

  • DatabaseList: Increased the Default Max Databases per connection to 64
  • DatabaseList: Sort when retrieving to ensure consistent results
  • Config: New option "MaxDatabasesPerConnection" defaults to 64
  • Config: Debug flags can now be updated without restarting the Service
  • Date Handling: Better handling of user entered dates

2 new fixes

  • Oracle: Off by one error when paging resulted in hidden records.
  • DatabaseList: Improved Error reporting.

2017-12-01 - dbFront   Version: 1.0.3.1466,  Beta,  Expired

8 new features

  • Install: Generates IIS Install Script for Self Install of IIS.
  • Indexes: Improved index use when joining to related data.
  • Indexes: Show warnings when updating table or lookup field preferences if the supporting indexes are missing.
  • DateFormats: Added MM/DD/YY and MM/DD/YYYY
  • Security: Separate Admin accounts vs Promoted Admin accounts.
    See: ConnectionAccess
  • Warnings: Add a "Missing Primary Key" warning when editing table preferences if no PK.
  • Mobile: Updates to Menu, Form Layout and Field Layout for Small Screens.
  • Mobile: Updates to improve Touch based navigation.

6 new fixes

  • Memory Use: Regular garbage collection.
  • Server Info: Fixed duplicating server info.
  • Upgrade Issues: Ensure that browser clients load fresh versions of updated files.
  • Menus: The Advanced and Simple database menus are now sorted alphabetically.
  • Duplicate Groups: Ignore duplicate AD group names instead of erroring. Duplicates are logged.
  • Config: Setting the Debug flag no longer requires a restart.

2017-11-01 - dbFront   Version: 1.0.3.0737,  Beta,  Expired

1 new feature

  • Allows managing active databases from Access Preferences.

6 new fixes

  • AZURE: HAS_DBACCESS() won't return correctly unless called within that databases context.
  • Cache: Ensure that cache key is unique between connections even if all db attributes are identical.
  • Install: Ensure that ASP.net 4.5 is required when possible.
  • Advanced: Reload correct tab on refresh.
  • Browser Memory: Properly cleanup after closing dialogs.
  • Browser Cookies: Ensure cookies correctly written.

dbFront   Version: 1.0.2

2017-10-12 - dbFront   Version: 1.0.2.9740,  Beta,  Expired

14 new features

  • Security: Ability to select connection specific AD security groups for Update and Readonly access.
  • Security: Deny access to specific users.
  • Security: NonAdmin users with no connection access will be rejected at login.
  • Dropdowns: Updated to support more then a million records.
  • Dropdowns: Dropdowns with more then 2000 rows will now be handled via AJAX.
  • Reporting: Ability to create million row reports and exports with minimal memory usage.
  • Reporting: Progress Meter and Details when Printing or Exporting.
  • Reporting: If PDF creation fails then automatically return QuickView.
  • Memory: Faster and more efficient Server to Server communication.
  • Memory: Faster and more efficient Server to Client communication.
  • Memory: Actively purge memory after large requests.
  • Rowcount: Return true rowcount where possible.
  • License: Extra License details on About screen.
  • License: Ability to update license on About screen.

7 new fixes

  • Dropdown: Update to Select2 4.04
  • RichText Editor: Minor layout fixes.
  • Field Admin: Properly refresh the UI when making field changes.
  • Numeric Formatting: Fixed Decimal formatting.
  • MS Edge: Layout fixes.
  • Database Admin: Hide inaccessable SQL Server databases for the connection user.
  • Null DataType: A null datatype will no longer block usage.

1 new security update

  • MyAdmin: Block MyAdmin users from viewing other users connection details.

2017-10-11 - dbFront   Version: 1.0.2.9695,  Beta,  Expired

14 new features

  • Security: Ability to select connection specific AD security groups for Update and Readonly access.
  • Security: Permit explicitly rejecting specific users.
  • Security: NonAdmin users that don't have any connection access will be rejected at login.
  • Dropdowns: Updated to support more then a million records.
  • Dropdowns: Dropdowns with more then 2000 rows will now be handled via AJAX.
  • Reporting: Ability to create million row reports and exports with minimal memory usage.
  • Reporting: Progress Meter and Details when Printing or Exporting.
  • Reporting: If PDF creation fails then automatically return QuickView.
  • Memory: Faster and more efficient Server to Server communication.
  • Memory: Faster and more efficient Server to Client communication.
  • Memory: Actively purge memory after large requests.
  • Rowcount: Return True rowcount where possible.
  • License: Extra License details on About screen.
  • License: Ability to update license on About screen.

7 new fixes

  • Dropdown: Update to Select2 4.04
  • RichText Editor: Minor layout fixes.
  • Field Admin: Properly refresh the UI when making field changes.
  • Numeric Formatting: Fixed Decimal formatting.
  • MS Edge: Layout fixes.
  • Database Admin: Hide inaccessable SQL Server databases for the connection user.
  • Null DataType: A null datatype will no longer block usage.

1 new security update

  • MyAdmin: Block MyAdmin users from viewing other users connection details.
Content you want the user to see goes here.
close