your database front-end

Release History

The latest version is always available from the download page.

dbFront   Version: 1.0.13

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

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

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

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-09-26 - dbFront   Version: 1.0.12.0612,   Feature

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

1 new fix

  • QuickPrint: Fixed template selection.

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

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

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

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

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

1 new fix

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 automaticaly 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

1 new fix

  • StoredProcedure: Fix Table Results view returning incorrect data.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1 new fix

  • Reporting: Fixed error with missing where conditions.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

2017-09-02 - dbFront   Version: 1.0.2.8773,   Beta

6 new features

  • SQLServer: Report SQL Compatibility
  • Oracle: Respect Table Permissions
  • Reporting: PDF Library Update
  • StaticData: Reduced inpage cached data
  • Logging: Log Client Errors
  • Rowcounts: Use real rowcounts where safe

13 new fixes

  • UserAccess: Better Error Handling
  • UserAccess: Profile Validation / Autocorrect
  • Rowcounts: Update as adding/deleting
  • SQLServer: Catch Invalid Servername
  • Oracle: Correct invalid Scale and Precision Defaults
  • Layout: Fixes to responsive calculations
  • ServerKey: Update to be unique across cloned VMs
  • Public: Fixed redirect to Default
  • Menu: Fixes for large menus on Ultra Displays
  • XHTML: Fixes to rendered HTML.
  • LoadTesting: Stub
  • DataTable: Removed "ALL" option (unsafe on large datasets)
  • Port: Change default Port from 8080 to 42057 for new installs.

2017-05-29 - dbFront   Version: 1.0.2.6468,   Beta

1 new feature

  • Added more links to context specific help.

3 new fixes

  • ActionButtons: Updates so that buttons can use hidden fields
  • Oracle: Fixed issues with Parameterized Queries.
  • Oracle: Fixed issues getting key fields.

2017-05-13 - dbFront   Version: 1.0.2.6087,   Beta

6 new fixes

  • Editing: Editing with some or all PK fields hidden.
  • Goto Button: Fixed to cover Non-PK relationships.
  • Layout: Update the Advanced Database window for small screens.
  • Speed: Reduced chatter between WebApp and Service
  • Validation: Highlights the new Dropdown fields on error
  • Validation: Errors on fields with hidden caption will appear correctly

2017-05-03 - dbFront   Version: 1.0.2.5842,   Beta

4 new features

  • Layout: New "Table Beside Detail" layout, great for wide displays
  • Layout: Much better support for small screens and rotation
  • Layout: Ability to select default row count for table
  • Layout: The menu will now collapse the main menu items on small screens

10 new fixes

  • GoTo Record: Moving to another Table/Record now loads all child records as well
  • Dropdown Fields: Fixed Dropdown fields based on a Multicolumn Relationship
  • Dropdown Fields: Refresh dropdown lists if the supporting data has changed
  • HTML Fields: Fixed HTML fields that load up in a hidden tab
  • Session Timeout: Updated Blink Pattern
  • Minimum IE: Moved from IE 9 to IE 10 minimum
  • Copy Record: Clear fields that must be unique to avoid duplicate error on insert
  • Insert/Update: Skip Calculated and similar columns when inserting/updating
  • Relationships: MSSQL: Retrieve the keys in the correct order.
  • Export/Import: Include the Relationship Sort Order

2017-04-14 - dbFront   Version: 1.0.2.5387,   Beta

1 new feature

  • Layout: The Top Menu order can now be adjusted by the Table Order when managing the tables

3 new fixes

  • Stability: Improved error handling so that minor errors don't cause major issues
  • RegEx: Now works properly with Null fields
  • RegEx: Fixed evaluation issues

2017-02-21 - dbFront   Version: 1.0.2.4134,   Stable

1 new feature

  • Installer: Now provides access to the Logfile if the install fails

3 new fixes

  • Installer: Fixed ability to create website
  • Security: Fixed ability to assign ReadOnly to specific users when the default security is Update
  • Menu: Minor menu cleanup

2017-02-01 - dbFront   Version: 1.0.2.3653,   Beta

1 new feature

  • Extra System usage metrics for Admin Users.

6 new fixes

  • Fix Date Handling/Formatting in IE
  • Ensure that PK fields are always required.
  • Ensure correct key fields used when PK fields not together.
  • Trim logging of security data.
  • Sort users optional list.
  • Fix usage of Default Access.

2017-01-21 - dbFront   Version: 1.0.2.3411,   Beta

1 new feature

  • Now use Select2 to make large dropdowns searchable.

6 new fixes

  • Added KeepAlive logic to fix session expiry issues.
  • Updates no longer risk overwriting an older web.config
  • Fixes to improve handling of tables without keys.
  • Fixed handling of non-null blank fields.
  • Better error handling when a database is offline.
  • Better error handling bookmarks are invalid.

2016-11-19 - dbFront   Version: 1.0.2.1901,   Stable

6 new fixes

  • Significant improvements to AD integration.
  • Fix: Can't add security to a user with a space in name.
  • Fix: Lookup Sort order is properly reloaded.
  • Fix: Clearly mark deleted users.
  • Performance: Update and Delete expressions only called on Form Load.
  • Security: Warning if 'Windows Authorization Access' is missing on service account.

2016-10-22 - dbFront   Version: 1.0.2.1217,   Beta

5 new features

  • Field: Added ability to set expressions for Audit Fields
  • Lookups: Added ability to set an alternative Sort Order for Lookups
  • Row Security: Add ability to calculate a Row Level Delete permission.
  • Installer: Now checks for missing IIS features
  • License: Updated to show Open Source Content

9 new fixes

  • Import: Better feedback when importing data and applying database settings.
  • MsSQL-2000: Repaired MS SQL 2000 support.
  • Keyless Tables: Improved help when dealing with Keyless tables.
  • MsSQL Import: Fixed Field creation instructions.
  • Goto: Fixed issues jumping to unselected lookup entry.
  • Sorting: Fixed child table default sorting.
  • Advanced Search: Now uses correct Date type (Date, DateTime, Time)
  • Form: Treat ColumnSpace as Min-Width.
  • PDF Generation: Improved Error handling on failure.

1 new security update

  • SQL Injection: Improved handling of user input to eliminate a SQL injection vector.

2016-09-17 - dbFront   Version: 1.0.2.0373,   Beta

6 new features

  • Report/Export: Open Reports in a Separate Tab
  • Report/Export: Sorting Direction
  • Report/Export: Optionally Require user Filter Fields
  • ActionButtons: Allow %username% as a special parameter.
  • TableView: Set Default Sort Order
  • Security: Simplify Update/Readonly User Management

3 new fixes

  • Fix Browser Popup Issues
  • Minor fixes to default Report Template
  • MimeType corrections

dbFront   Version: 1.0.1

2016-09-03 - dbFront   Version: 1.0.1.9892,   Beta

5 new features

  • Field Formatting: Allow format strings to be specified. (Currently only applies to Numeric and Date fields on Reports/Exports)
  • OpenUrl Button: Optionally allow button use without triggering validation.
  • Saved Reports/Exports: Allow users to select output format at runtime.
  • Saved Reports/Exports: Allow user filters.
  • MySQL: now support connector version v6.6 to v6.9.9

7 new fixes

  • IE: Force IE to use Edge mode even in corporate environments.
  • SetValue Button: Fix expression validation.
  • Attachment Upload: Added validation to Drag/Drop from website.
  • Advanced Search: Fixed Read-Only user searching.
  • Logging: Ensure logging issues can't prevent service start.
  • Form Fields: Handle and cleanup duplicate fields.
  • User Session: Fixed error purging old sessions.

2016-08-20 - dbFront   Version: 1.0.1.9555,   Beta

6 new features

  • Table: Added the option to view 1 or 5 rows. (5 is now the default)
  • Connections: Add ability to temporarily enable/disable connections.
  • Quick Reports: Can now export the data in CSV format (excel to follow)
  • Quick Reports: Ability to filter results.
  • Quick Reports: Ability to report/export a single item (e.g Invoice or Recipe) or a listing (e.g. Product Listing, Directory)
  • Automatic Cache cleanup: Automatically purge cache files after 7 days.

4 new fixes

  • Table: Fixed alignment of columns and headings on hidden tables.
  • Advanced Search: Fixed field layout.
  • Form View: Fixed reappearing fields (after they were removed)
  • SQLServer: Fixed incorrect display length.

2016-08-05 - dbFront   Version: 1.0.1.9183,   Beta

7 new features

  • Login: Add "Remember Me" to login page.
  • Exporting: UI changes to allow for Excel and CVS export
  • Reporting: UI changes to allow for multirow reports
  • Reporting: Properly expand lookup fields.
  • Database Export/Import: now transfers dbFront config.
  • Database Export/Import: now optionally export/imports data.
  • Advanced Search: Allow partial matches and wildcards "%"

8 new fixes

  • Fixed error when selecting empty row
  • Fixed many cases where dialog contents were to large for dialog
  • Fixed number formatting in table and reports
  • Various CSS fixes.
  • Detect Service / UI version mismatch and log
  • Connections with excessive generate a warning and only the first 32 are shown.
  • Fixed Database Export/Import creating duplicate object names in for relationships.
  • Fixed random locking errors when updating database lookup table.

2016-07-02 - dbFront   Version: 1.0.1.8379,   Beta

3 new features

  • Added Filtering / Advanced Search
  • Reports and Database menu now remember current tab
  • Default a list of Filter fields

7 new fixes

  • Fixed Tab Specific Context
  • Fixed Default Report for IE
  • Fixed invalid Default Button behaviour
  • Used Cookie to get try and figure out current tab.
  • Fixed MySql security query.
  • Fixed MsSql boolean handling
  • Added Invalid Profile detection

2016-06-27 - dbFront   Version: 1.0.1.8261,   Beta

3 new features

  • Added the ability to delete Report Templates
  • Add Support for Azure version of SQL Server.
  • Now Requires Dotnet 4.5.2

3 new fixes

  • Saving a Template now keeps current Template in focus.
  • Removed request for VIEW ANY DEFINITION for MSSQL.
  • Fixed security hiding MSSQL tables that should be visible.

2016-05-26 - dbFront   Version: 1.0.1.8213,   Beta

6 new features

  • Added About Dialog under Help menu with ability to update License.
  • Added Temporary Link to Template Editor under Help menu. (Move to Reports menu later)
  • Added ability to preview report templates in the editor.
  • Increased size of ReportTemplate body and style to 10k
  • Better support For Database Table Permissions (Select, Insert, Update, Delete).
  • Added ability to set Login Context Type (Domain, Machine) in dbFrontService.config

4 new fixes

  • Delay the Session Expiry Warning by 5 minutes
  • Fix errors around resolving DLLs
  • Improve System Database detection
  • Fixed ability to create new templates

2016-04-02 - dbFront   Version: 1.0.1.8117,   Beta

3 new features

  • Save Database and Table hashes for quick lookup after restart.
  • Cleanup HTML fields for viewing as records.
  • Record Bookmarks now avaible for public and internal users.

11 new fixes

  • Session Expiry Warning (Continue / Logout)
  • Improve session recovery for public users.
  • Detect windows AD config error
  • SQL Server: Warn of possible Trigger Error. Table Triggers must include [set nocount on;] to avoid messing with the returned rowcount.
  • SQL Server: Fixed ability to insert into table with Trigger.
  • + Only "After Insert" triggers supported if the table has an identity column.
  • + Can't support "Instead of Insert" triggers because they prevent capture of the new identity value.
  • Improved driver support
  • Fixed Goto Record
  • Fixed Tab Session separation
  • Fixed Settings display on Group Controls

2016-02-29 - dbFront   Version: 1.0.1.7310,   Beta

10 new features

  • Separate Public and Private Session Expiries
  • Add ability to include a Database specific class
  • Add "Label Position" on DB, Table and Field
  • Add "Hide If Null and Readonly" on Fields
  • Add "Css Class" on Table, Field and Layout Group
  • Add "Layout Group" on Field
  • Add "Column Count" on Table and Layout Group, this replaces the dynamic calculation
  • Add "Column Space" on Table and Layout Group to allow dbFront to dynamically drop the number of columns if space is not available.
  • Add "Remove" button to Layout Group and Custom Button

12 new fixes

  • Remove Border around Buttons
  • Fix Table Lookup for Public users after Restart or session loss.
  • Better Logging for Authentication Issues
  • Ticket #299778, Ensure PK is available even if hidden
  • Ignore attempts to update RowVersion Fields
  • Fix Session Expiry disconnect between Service and IIS
  • Persist Database & Table Index to disk to avoid unnessecary DB scans
  • Improve dbFrontService response to config updates to avoid restarts.
  • Fix Quick Report button security. Only allow admin to Create/Save/Delete reports.
  • Fix overly zealous caching of old core.js
  • Fix caching old static data.
  • Add css classes to specific elements to aid in styling

2016-02-09 - dbFront   Version: 1.0.1.6828,   Beta

4 new features

  • Reworked Authentication to allow for a Public View.
  • Updates to deal with a single user switching between Public and Authenticated pages.
  • Ability to Hide "Quick Print" from non Admin users.
  • Mark public connections in Admin View

5 new fixes

  • Fixed Ghost Domain when machine added and then removed from domain.
  • Fixed sorting for image columns.
  • Fixed ability to manage tables.
  • Fixed occasional empty database list.
  • Fixed AD authentication broken in 1.01.6429

2016-01-30 - dbFront   Version: 1.0.1.6601,   Beta

1 new feature

  • Rework Authentication for Public Authentication

1 new fix

2016-01-23 - dbFront   Version: 1.0.1.6429,   Beta

3 new features

  • Upload attachment sizes are validated against server and db maximums
  • Again rework the authentication to deal with Windows 10 issues.
  • Add ability to trigger Debug level logging.

1 new fix

  • Fix issues getting Active Directory configuration.

2016-01-13 - dbFront   Version: 1.0.1.6195,   Beta

4 new features

  • Store Server Salt, in-case the system signature changes.
  • Better handling for Log Running Processes (e.g. Export/Import)
  • Export/Import, Create scripts for missing structure
  • MySQL: Updated Base Supported Connector Version to 6.7.9

1 new fix

  • Fix ability to correct connection password.

2015-12-24 - dbFront   Version: 1.0.1.5702,   Beta

4 new features

  • Ability to Export and Import databases between different database servers and versions.
  • Cleanup Advanced Database Window
  • Remove Database Window for Non-Admin users with only one database.
  • Hide Database Name in URL. Now use (k=DatabaseKey), can still use d=Databasename if desired.

4 new fixes

  • Allow multiple databases with the same name across servers/connections.
  • Fix to Admin Menu access.
  • Fix performance issue accessing Windows user list
  • Fix SQL Syntax issues caused when using Reserved Words as field names. e.g. 'Delete'

2015-11-19 - dbFront   Version: 1.0.1.4862,   Beta

3 new features

  • Add ability to dynamically use different database DLL versions. (NF)
  • Add drag and drop for images from other webpages directly
  • Allow Html File Type

2 new fixes

  • Don't show the Javascript alert so much..
  • Allow File types with mixed case.

2015-11-10 - dbFront   Version: 1.0.1.4661,   Beta

2 new features

  • Better in-app config help for authentication and database preferences.
  • Changed URL to online help

3 new fixes

  • Only Admin users can upload attachments.
  • Fixed Logging LF
  • Fixed AD Membership detection (Win8/10)

2015-11-07 - dbFront   Version: 1.0.1.4590,   Beta

6 new features

  • Added a Feedback Icon
  • Changed the Help Link to a Dropdown with a help link and a Bug Report Link
  • Added the Connection caption to the Connection Access Dialog
  • Renamed the Readonly Expression to Updateable Expression
  • Added instructions to the Connection Access Dialog
  • Rearranged the Table Preferences

2015-11-02 - dbFront   Version: 1.0.1.4468,   Beta

14 new features

  • Ability to Create and Modify HTML Report Templates
  • Ability to run HTML Reports.
  • Rearranged the Connection Access Dialog
  • Added ability to Setup Database Authentication
  • Made the Multiselect Widget Taller (CSS)
  • Authentication: Adding Database Authentication
  • Authentication: Validation Function
  • Authentication: Config UI
  • Authentication: Reworked the database security in the Database Window as Profiles. ( If a profile table is configured then users must exist and match)
  • Authentication: Enabling Database Authentication triggers a "Directory" select on the Login.
  • Authentication: User Access is now determined by UserName/Directory
  • Authentication: Simplified Access Logic. Either Admin, Update, Readonly or Default...
  • Changed [No Group] to "Select Database..."
  • Added more help links.

2015-08-15 - dbFront   Version: 1.0.1.2562,   Beta

3 new features

  • ReadOnly Expressions
  • Beginings of Printing
  • Updated Themes

1 new fix

  • Fixes around Read-only Records

2015-08-08 - dbFront   Version: 1.0.1.2404,   Stable

1 new fix

  • Minor Fixes

2015-08-04 - dbFront   Version: 1.0.1.2294,   Beta

2 new features

  • Javascript typeCheck
  • Rebuild Expression Engine

2015-07-21 - dbFront   Version: 1.0.1.1899,   Beta

3 new features

  • Update to DataTables.1.10
  • Update to jQuery 1.11.3
  • Update to jQueryUI 1.11.4

3 new fixes

  • Pointer over images
  • Fixed PK-FK case missmatch issues (MySql)
  • ThemeSwitch Refresh

2015-07-11 - dbFront   Version: 1.0.1.1721,   Beta

1 new feature

  • Table view now shows if blob fields contain a value

1 new fix

  • System Test fixes

2015-07-07 - dbFront   Version: 1.0.1.1636,   Stable

2 new fixes

  • Fixed Date Handling
  • MSSQL: Fixed image deletion

2015-06-13 - dbFront   Version: 1.0.1.1053,   Beta

1 new feature

  • Add the ability to 'Goto' the selected lookup value

dbFront   Version: 1.0.0

2015-03-26 - dbFront   Version: 1.0.0.4066,   Beta

1 new feature

  • Working on Custom Buttons

1 new fix

  • Fixing SetValueAction visibility
Content you want the user to see goes here.
close