Author: Roland Lannuzel

Roland Lannuzel

• Product Owner & 4D Expert •

After studying electronics, Roland went into industrial IT as a developer and consultant, building solutions for customers with a variety of databases and technologies. In the late 80’s he fell in love with 4D and has used it in writing business applications that include accounting, billing and email systems.

Eventually joining the company in 1997, Roland’s valuable contributions include designing specifications, testing tools, demos as well as training and speaking to the 4D community at many conferences. He continues to actively shape the future of 4D by defining new features and database development tools.

Product

Form and subform communication made easy!

Automatically translated from English

Starting with 4D v19 R5, the ability to associate a variable with a subform has enriched the possibilities of interfaces and communication between forms and subforms. The means of communication are now simplified by two new commands: Say hello to OBJECT Get subform container value and OBJECT SET SUBFORM CONTAINER VALUE.

Product

4D Write Pro: Say hello to table headers

Automatically translated from English

Tables are an essential part of 4D Write Pro. They evolve regularly by offering new presentation options. For example, a table can be displayed on several columns or pages. The table headers are repeated at the top of each column or page to make it easier for the user to read.

Starting with 4D v19 R5, the table can be enhanced with headers.

Product

ORDA and 4D Write Pro : The power couple!

Automatically translated from English

4D Write Pro documents often contain formulas returning data or calculations depending on the database. Thanks to the use of contexts, associating that data with documents is now child’s play!

In this blog post, we’ll see how the combination of 4D Write Pro documents with data retrieved using ORDA makes the code clear and easy to maintain.

Product

4D Write Pro – More control on page layout

Automatically translated from English

4D Write Pro makes it easy to create complex documents. Display and layout attributes can be applied to different parts of the documents, whether they are text, images, or tables. Speaking of tables, they benefit from a new property to better define the layout! Let’s see what 4D v19 R4 has in store for you. 

Product

4D Write Pro: Where are my formulas?

Automatically translated from English

When a 4D Write Pro document contains external elements resulting from expressions or formulas, they are visible when the “Display expressions” mode is used. Still, they are blended into the text when the values are displayed. This is what you want for a final document, but it is sometimes useful to easily view these calculated values while writing the document. Well, 4D v19 R3 is giving you new display options for this purpose!

Product

Export 4D Write Pro documents to SVG format

Automatically translated from English

4D Write Pro documents can be exported into different formats: PDF, Plain text, Microsoft Word, 4D Write Pro, HTML… To this list is now added the SVG format!

SVG is an image format. Thanks to that, you will be able to create previews of any page, integrate them in your interface, visualize them in browsers, on mobile devices, etc.

Product

Need a magic wand? Here are computed class properties!

Automatically translated from English
The apparition of classes in the 4D development environment has made programming more modern and easier to scale. Classes allow the definition of properties, functions and also support inheritance.
In your application, you probably have a class to manage scientific or financial data. Let’s take the example of financial data. Say you have created functions to calculate taxes. If you also manage several countries, you may have used inheritance to manage the different rules. Then, you display these results in a list box, but if the user changes one of the attributes used in the formula, you have to manage this event to update the result.
With 4D v19 R3, 4D allows you to simplify this process thanks to computed properties: You can define a get and set function for your computed property, and when you add your property to a list box, everything is handled automatically by 4D. No more business logic in your UI.

Product

A magic show awaits you with ORDA’s computed attributes!

Automatically translated from English

It is often helpful or even essential that databases be adapted in a flexible and evolving way to users and their businesses in the computer world. The control of accessible data is also a recurrent and sensitive subject. From this point of view, developers use methods and formulas that are sometimes complex to give or restrict access to information, depending on the context or the access rights of the users.

Let’s take a simple example. In your application, you sometimes need to display a list of people. One of the columns displays their full names, but in your database, you have a first name field and a last name field. Currently, you write a formula in the list box column, and you have to manage the sorting on the column yourself. Wouldn’t it be great to have a computed field where you can define its calculation formula and sorting method, and have all the business logic inside the class and not in each interface?

Well, starting with 4D v19 R3, 4D provides a solution to this, with computed attributes.