Object fields introduced with v15 allows unstructured data bases, similar to schemaless database (NoSQL). 4D v16 goes a big step further. Get a dynamic structure for unstructured data… Confused?
Imagine you use an object field to allow your customers to store custom data, where they can create their own fields. This works well and is one of the most interesting reasons for using an object field. The problem is, how to allow your customer to query this unstructured data? You don’t know which ‘fields’ they used, you cannot build a query editor on top or offer a drop down with used values.
In 4D v16 the texts for all the form objects (static texts, buttons, check boxes, etc…) will be stored in Unicode, allowing you to use characters from different languages directly in the form editor.
Especially for Asian or Eastern European languages this will ease the development process.
4D v16 is providing you with an enhanced integration of object fields in your database.
If you have already pre-selected sets of an object field, you can now query these sets using only one 4D command: easy and fast!
From 4D v15 R5, you can add an icon in the listbox header by programming. The image can come from a file, a picture variable or the picture library. This icon can be placed on the left or on the right side of the column.
A powerful new syntax is available for 4D tags inside texts and Blobs to be processed.
This new syntax is supported in two cases:
- files with “.shtml” extensions served by 4D Web Server
- Text and Blobs sent as parameters to the PROCESS 4D TAGS command
The new syntax is available for three tags, 4DEVAL, 4DTEXT and 4DHTML, which can now be written prefixed with a $ (dollar sign) rather than as HTML comments.
With 4D v15 R4, a new parameter is introduced for the DISTINCT VALUE command. This parameter must be an array, and it receives the count of each distinct value in a selection of records.
This feature is particularly useful for obtaining statistics on records, or to order records by their most common type.
In 4D applications, the data file is important, so all the activity of the database is stored in the log file. As you all know, the log file is a vital element for the restoration of your database following an unfortunate contingency. However all the information on the database activity may also be useful for analysis. For example, to check the activity on a table, to see the changes made by a user, and to follow a record’s history.
This feature is useful when you need to perform, from within a transaction, certain operations that do not need to be executed under the control of this transaction.
The GRAPH command has been totally refactored to ease the use and customization of your graphs. Moreover it has been enhanced to give you the full control on the various graph properties.
Easily create flexible and powerful UIs, dialogs and widgets with 4D View Pro! To know more about 4D View Pro, check out this blog post.
This feature is a powerful enhancement for the listbox object, providing you with a mean to define very flexible UIs. An array of objects can now be associated with the column of a listbox so that each cell can have different types of widgets according to the type of data to be displayed.