Read 4D object fields with SQL Engine

Automatically translated from English

A 4D object field is a persistent database field type, stored as binary content. Previously, reading this type of field by an ODBC driver wasn’t possible. Until today.

Before, an error was returned when trying to read an object field. This prevented the completion of simple Select * from myTable requests, which could be frustrating for users who only wanted to browse the content of a table.

Good news! The SQL engine has been updated to allow 4D object fields to be read.


Introduction to data encryption in 4D

Automatically translated from English

DATA is everywhere. As our lives increasingly move online, the importance of data security also increases. Customer data must be vigilantly guarded against potential threats and breaches. In many cases, using a disk encryption tool (such as Microsoft’s Bitlocker or Apple’s FileVault) provides a sufficient level of protection, but what if your customer or your CSO (Chief Security Officer) requires encryption at the database level – on a per table basis?

During 4D Summit 2018, you asked for a solution to encrypt your data and we’ve delivered. We’re excited to present new data encryption tools for your 4D databases.


4D v17 R5 Beta starts today

Automatically translated from English

We’re pleased to announce the launch of beta testing for 4D v17 R5.

4D v17 R5 is one of the most feature-rich R-releases ever delivered, and we couldn’t be happier to share all the advances we’ve added to the ever-growing list of 4D features:


  • New built-in data encryption for your 4D databases is available, adding another level of security that is completely transparent, safe, and fast. 
  • Actions, incremental data synchronization, and N to one relations are now available for 4D for iOS.
  • The SQL engine has been updated to allow reading 4D objects.
  • More email features: Logging SMTP conversations, custom mail headers, and legacy charset support are ready and waiting for you. 
  • Additional advances in the 4D language and ORDA for better readability, efficient code maintenance, and optimized performance.
  • In addition to commands being extended or renamed, you can also invoke a method from your 4D application, thanks to the power of 4D Write Pro
  • A powerful new ribbon-style toolbar to enhance the 4D View Pro user interface is at your disposal. 
  • And much more (see below).

4D v17 R4 is here!

Automatically translated from English

We’re pleased to announce that 4D v17 R4 is now available! 

Here’s an overview of what this R-release has in store for you:

  • Take full advantage of your multi-core computers with: preemptive processes on the client, and Begin SQL/ End SQL command that is now preemptive-compliant.
  • Exporting your documents in .docx format and graphically managing vertical margins thanks to a vertical ruler are just a part of the new 4D Write Pro features.  
  • Make use of restricted queries, multi-criteria search, and the ability to create custom data formatters in your 4D for iOS application.
  • Discover the new way of sending emails in 4D. You’ll be pleasantly surprised by the simplicity and power.
  • Explore the additional commands we’re shipping to programmatically handle your 4D View Pro documents.

All of this and more awaits you!


New formula: More power behind simplicity

Automatically translated from English

The New formula command is available since 4D v17 R3. So far you might have thought of assigning a formula as a method to an object or building smart objects that can calculate values or do anything you need. That’s really great, and there’s more than meets the eye!

I had a great demonstration from Vincent de Lachaux – Developer and expert 4D – on how he uses this command. For this blog post, I compiled different scenarios from that demo to give you insight on a different dimension of this command.


Go the distance with the best of 4D

Automatically translated from English

Things have been really exciting for us here at 4D, but also in our community. Especially with 4Dv17 and its R-releases containing many groundbreaking features such as ORDA, 4D for iOS, 4D Write Pro, 4D View Pro, dynamic forms, and much more. Now there’s even more good news … we’re hitting the road to share all of these great advances with you in person! We’re hosting events where you can meet the 4D team face to face and gain in-depth knowledge about 4D technologies: 50+ countries and 44 cities around to introduce you to the latest 4D innovations!


4D Write Pro now supports virtual structures!

Automatically translated from English

Understanding end user needs and creating user-friendly interfaces are high priorities for every application developers.

And as you may know, the 4D language lets you alias table and field names in order to make them more readable for end users. This allows easier translating and readability in standard dialogs (query, sort, and formula editors), but also filtering out any table or fields that should be kept away from end users sight. 

During 4D Summit 2018, we had requests to extend this feature to 4D Write Pro. Well, we listened and it’s now available with 4D v17 R4!


Name your ranges and formulas in 4D View Pro

Automatically translated from English

4D v17 R4 is on the way with a cool new 4D View Pro feature: named ranges and formulas. If you need to use formulas with references to cell(s) or constant(s), this feature can be a great help!

With these new commands, your formulas are more readable and easily accessible with 4D View Pro’s automatic completion.