The 1.1.1 branch of dbFront is now the feature release. This release builds on 1.1.0 by solidifying the Grid Editing, Excel Export, Row Styling and many other features and adding significantly improved support for very large Active Directories. In total there are 26 features and 69 fixes as compared to dbFront 1.0.15.

dbFront 1.1.1 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.

dbFront 1.1.0 features:

• Attachments: Add...

With the start of this new year of 2021, dbFront Works, the company behind dbFront has incorporated as Big Ideas Computing Ltd.

dbFront Works was originally created as a sole proprietorship to simplify administration and minimize costs.  With the continued growth of our main product dbFront, it is time to incorporate. Being incorporated allows us to take advantage of new opportunities, investment options and other funding.

The company name Big Ideas Computing Ltd. was chosen to make it clear that there are more Big Ideas we hope to explore in the computing field.  The name dbFront Works is still registered and usable but we will be migrating fully to Big Ideas Computing Ltd.

To be clear, dbFront is our main product and will continue to be for the foreseeable future. Shortly,...

The 1.0.15 branch has stabilized with 17 new features and 55 fixes and will only be receiving important bug fixes going forward. It contains lots of dependability for your #sqlserver, #mysql and #oracle database applications.

The 1.0.15 branch of dbFront has primarily been about solidifying and finalizing the 1.0 branch of dbFront. As such there are few outstanding features. Instead the focus was on making things dependable with a few new features to help round out the functionality and improve the validation. Even the listed features are primarily targeted at preventing issues rather then adding functionality.

The full list of features for the 1.0.15 branch is:

• ActionButton: Allow RunProcedure action to trigger table open.
• ActionButtons: Allow some ActionButtons without a selected record.
• ActionButton: Don't require row-selection to enable buttons if parameters are...

The latest version of #dbFront now incorporates Conditional Row Color & Styling on #Oracle, #SQLServer and #MySQL databases.

dbFront (1.1.0.3232) allows you to assign a data specific CSS class to table rows. On the Table Fields tab of the Table Preferences, you can choose a specific field and assign it to set the Row CSS Class.

When you select a field to provide the Row CSS Class, then dbFront will take the raw field value and turn it into a safe CSS class name.

The resuling CSS class name will be added to the

tag for that table row. Using custom CSS you can then affect that rows styling in any way you like.

Using CSS to style your table rows is both reasonably safe and very powerful. The CSS can't mess...

What #sql #database structure would most naturally lead to a cascading dropdown?

The answer is a composite (multi-key) relationship with a supporting simpler relationship involving a subset (N-1) of those fields.

A composite (multi-key) relationship is any single relationship that involves multiple fields joining two tables.

e.g.

/* Composite Relationship */
ALTER TABLE Invoice
ADD CONSTRAINT FK_Invoice_to_ProductModel
FOREIGN KEY(ProductID, ModelID)
REFERENCES ProductModel (ProductID, ModelID);

/* Supporting Simple Relationship */
ALTER TABLE ProductModel
ADD CONSTRAINT FK_ProductModel_to_Product
FOREIGN KEY(ProductID)
REFERENCES Product (ProductID);

dbFront automatically creates cascading dropdowns whenever it sees a composite relationship chained to a simpler relationship.

For the full details and implementation see: dbfront.com/cascadinglookups