Product New info in 4D Maintenance and security center MSC

New info available in MSC dialog

If you are using a huge database with a lot of data, you should be very familiar with the 4D MSC dialog. The Maintenance and Security Center contains all the tools needed for information, verification, analysis, maintenance, backup & compacting of data and structure files.

Based on recent feedback from some of our users, we have enhanced this dialog in three ways:

  • A link to the path of the log file has been added
  • New global information on the data is accessible
  • Information about tables are now available in both maintenance and standard modes
Product 4D Database: Search in array attribute

Search by linking array attribute query arguments

Object fields, introduced with 4D v15, allows to store and index unstructured data. This could be a common set of data, like first name, last name, birthday. It could be different data in each record, such as a shop that will need different attributes for shoes (size, color), computers (CPU, memory), printers (color, ink), a list of values or all in any combination.

Here is a real User Story from a 4D customer :

My badge application manages the access rights for each person to a building and for a time slot. This information is stored in a database as an array of objects ( e.g.: {access right, building, time slot} ). I want to be able to look for people who have access to a building during a time slot.”

4D provides several ways to query for data, using index and so extremely fast.

Product 4D View Pro: cross table

Easily create cross-tables reports with the Quick Report editor

A new step has been reached in 4D v16 R2 with the 64-bit Quick Report editor: the cross-table reports are now available!

As you probably already noticed, the new Quick report for 64-bit versions had been fully redesigned since v15 R3 to provide you and your end-user with a better user experience. After list reports which were available as the very first step, we are now moving forward and delivering cross-table reports.

Product

Listbox : more programming possibilities!

Want to do generic programming using listboxes? So this feature is for you!

With 4D v16 R2, 20+ new listbox properties can be dynamically manipulated by code so 4D Developers now have the full control over the listbox form object! Among a long list: multi-style, wordwrap, single-click edit, truncation mode, column min & max width and much more. The properties apply to the entire list box, its columns, or both.

No more property available only in Design Mode through the Property List: every single property can now be set and get using 2 commands: LISTBOX SET PROPERTY and LISTBOX Get property.

Product 4D Database: Sort records by object attribute

Sort records by object attribute

At each 4D release, object fields become more and more powerful.

A new 4D command for sorting your record selections according to one or more attributes is now available with 4D v16 R2. The new command ORDER BY ATTRIBUTE works the same as the command ORDER BY; you just have to pass an attribute path by which you want to order your selection – easy!

Product refactoring web area

New rendering engine for Web Area

4D is updating its internal component for embedded Web Area objects for the most up-to-date and well-maintained existing rendering engine. As we want to durably support the state of the art in HTML and JavaScript technology, we are changing to Blink (also used in Google Chrome) for the Web Area for all 4D 64-bit versions.

Product

Customize highlight color upon listbox row selection

A new step is reached to provide our developers with a fully customizable listbox object, entirely adaptable to user need. A new option is available in the listboxes that will allow to improve final interfaces: this option is called “Hide selection highlight”.

With just one click this option can be activated. Once activated, the system highlight will be completely invisible.

Product

New Enterprise feature: support of Virtual Machine snapshots

If your users are running your application as a virtualized application, chances are high they use VMWare vSphere (Hypervisor ESXi) and are using snapshots.

4D v16 R2 will automatically install a VSS writer service. VSS stands here for Volume Shadow Copy Service. When the VMWare administrator starts a snapshot, VMWare informs the guest, which informs the VSS writer, which will inform 4D Server to flush the cache and wait for one second. Then it will inform the OS that the .4DD, .4DIndx and .Journal files belong together and must be snapshot at the same time. The OS will handle this and 4D Server can continue to handle client requests. The “freeze” lasts around a second, usually not even noticed by connected users.