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

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.

Product

4D Write Pro – Continuous Section Breaks

Automatically translated from English

Starting with 4D v19 R3, 4D Write Pro supports continuous section breaks.

A continuous section break creates a section in its own right but without causing a page break.
This allows, among other things, to have different numbers of columns on the same page!

Product

4D Write Pro – New image formats

Automatically translated from English

Starting with 4D v19 R2, inline as well as anchored images inside 4D Write Pro documents will benefit from new formatting types.

We’ve also made it much easier to format the images used as background of documents, sections, paragraphs, etc.

Let’s find out more about these enhancements.

Product

4D Write Pro – Find and Replace

Automatically translated from English

For many years now, 4D Write Pro has made it possible to create simple or complex documents, either via programming using templates or by simply creating new documents from scratch. Starting with 4D v19, both developers and end users will be happy to use the new find (and replace) capabilities of 4D Write Pro. Using not just the interface… but also the code!

Let’s delve into the details!

Product

4D Write Pro: Easily locate all the breaks

Automatically translated from English

4D Write Pro documents support five types of breaks:

  • line breaks
  • paragraph breaks
  • page breaks
  • section breaks
  • column breaks

 

Sometimes, you need to locate a certain type of break to replace it with another, or simply delete all its occurrences in the document. To make this possible, we developed a new function: WP Get breaks.

Product

List Boxes: Time Columns and Footer Calculation!

Automatically translated from English

List boxes are great, powerful tools to display data in the interface. They can display fields from records, items from arrays, and since recently, entity selections and collections

While the new list boxes using collections or entity selections are more powerful in many ways, they did not allow time display and automatic calculations in their footers, unlike list boxes displaying arrays or records.

From now on, and as long as you use project mode, all types of list boxes can display hours in their columns, but also have the possibility to display calculations on their footers.