The new Diagram Editor control really stands out among the main new features in version 27 .
This control allows you to include superb diagram creation and editing functionalities in your applications and sites without writing a single line of code: these functionalities have been automated into one control.

A diagram is a "graphic representation of parts of a whole and their position in relation to each other".
A diagram can be used to represent structures, architectures, material infrastructure, plans, processes, mechanisms, unconventional flowcharts, ...

The Diagram Editor control includes rich, essential features:

• preset shapes
• custom shapes and images
• image resizing
• shape style: line, color, etc, ...
• advanced connectors between shapes
• text input
• ...

All these features, accessible to the end users of your applications and sites, are also available through programming.

Control
The Diagram Editor control is equivalent to a full program: it allows you to create diagrams without writing one line of code.
End users of your application or site can create, edit, save and print their own diagrams.
The control takes care of everything.
All types of diagrams are supported: logical diagram, flowchart, workflow, plan, IT infrastructure, process, vector graphics, electronic schematic diagram, mind map, ...

Programming
The Diagram Editor control can also be handled through programming.
Your application or site can create diagrams, and can edit or complement a diagram made by a user.

The Diagram Editor control has 4 main areas.
By default:

• left: library of preset shapes.
• top: toolbar.
• right: modifier, to edit the selected shape.
• center: diagram . The control is very easy to use.

Programmatically, or via the "7 tabs", you can hide one or more areas, customize the toolbar, load preset areas, ...

Preset shapes are the "base" of a diagram editor.
The Diagram Editor control includes a set of preset shapes:

• square,
• rectangle,
• triangle,
• polygon,
• diamond,
• parallelogram,
• circle, ellipse,
• arrow,
• dummy,
• person,
• star,
• leaf,
• window.
• ...

The clipart provided with WINDEV and WEBDEV includes thousands of SVG images that can be used as "shapes" in the Diagram Editor control.
The Diagram Editor also allows you to create your own shapes.

The connectors between shapes are an essential feature of a diagram editor: users should be able to create their own connectors, and these connectors should automatically adapt to any shape in any position.
The Diagram Editor control connectors in version 27 include:

• 2D or 3D aspect,
• line style: thickness, type, color,
• shape on each end,
• straight or elbow connector,
• connector with sharp angles,
• connection point,
• ...

The Diagram Editor control allows entering text directly at the cursor position.
All the standard text formatting functionalities are included: font, size, color, alignment, opacity, in-place editing, ...

The Diagram Editor control allows users to create their own preset shapes and import existing ones.
SVG shapes are supported, as well as PNG or JPEG images and photos.
It is easy to create libraries of shapes related to a professional field, furniture of a given brand, items available in a store, etc....
End users can create these elements or find them in your application.

The Diagram Editor control allows end users to create, edit, export and print their own diagrams.
The Diagram Editor control also allows creating, editing, using and positioning shapes, connectors and text through programming.
The content of a diagram created by an end user can also be manipulated through programming.
This opens a wide range of possibilities.

Diagrams can be exported as SVG or PNG images, using the toolbar.

Diagrams can be printed via the toolbar or through programming.
The selected paper size is represented by a dotted line in the diagram editor, which allows you to position the shapes according to the type of print job.

• WEBDEV and WINDEV use the same diagram format
  
• A diagram can be saved in an HFSQL Memo item, which allows binding the diagram to a data source.

In the code, the diagram is an array of shapes.
This array contains all the shapes and images of the diagram.
Each shape includes its coordinates and properties.
This makes it easy to edit a diagram, add shapes and images through programming.
All the functionalities of the Diagram Editor control are accessible in the code.
To add a shape to a diagram programmatically, simply add it to the array of shapes: the control will automatically display the shapes.
Of course, you can edit or delete a shape.

Version 27 includes the necessary WLanguage types to easily program the processes you want.
The Diagram native type allows you to handle the whole document.
The Diagram has many properties:

• dimension
• background color
• grid
• layout
• zoom
• ...

The native Shape type allows you to handle all the shapes with its numerous properties: X, Y, width, height, text, background color, opacity, shadow, array of links, ...
Other native types derive from the Shape type:

• Rectangle
• Triangle
• Circle
• Polygon
• Image
• Link
• Shape that contains shapes
• ...

All these types inherit the properties of the Shape type and have specific properties: radius, etc, ....

New WLanguage functions now allow you to create and handle diagrams through programming:
DiagramLoad, DiagramSave, DiagramToImage, DiagramToSVG, iPrintDiagram...

New WLanguage properties are also introduced to define and configure diagrams programmatically:
Zoom, Gridlines, Show/Hide library, modifier and ribbon, paper format...

New events are introduced to manipulate diagrams programmatically.
They are added to existing events.

• Click in the diagram
  In this event, you can write the code to create a shape at the click location.
• Create a shape
  This event allows you to be notified when the user creates a shape.
• Select a shape
  This event allows you to be notified when the user selects a shape.
• Change shape
  This event allows you to be notified when the user changes a shape.
• Right button
  This event allows you to be notified when the user presses the right mouse button. It can be used to open a custom context menu, for example.
• Move a shape (Drag and Drop)
  This event allows you to be notified when the user moves a shape.

Developers can programmatically add their own preset shapes and images to the library of preset shapes included in the control: shapes related to a professional field, shapes of a given brand, ...

A "display-only" mode allows you to display diagrams without pane or toolbar.
Shapes can no longer be moved or resized.
However, click events remain enabled, which allows to you program processes according to the user's clicks.

Highly anticipated new feature for the PDF Reader control in version 27: ability to fill out a form.
The completed form can then be printed and/or saved.
End users can directly fill out the form.

In previous versions, it was already possible to insert a watermark on one or more pages of an existing PDF through programming or in the print preview.
In the PDF Reader control in version 27, end users can insert a watermark, choose the text and set the text position, angle, font, size, color and opacity.

Watermarks can also be added programmatically.

PDFSign already allows signing documents programmatically.
In version 27, end users can sign PDF documents in the PDF Reader control.
The signature option can be found in the ribbon. End users must simply select the desired certificate.

In version 27, end users can also add their digital signatures to a PDF document that has been previously signed.
You can also use multiple signatures on PDF documents programmatically.

In version 27, a banner indicates if a PDF file is signed, and also indicates the number of signatures.
By clicking on this banner, end users can view the signature details.

You can also determine if a PDF document is signed, and identify the certificate used, programmatically.

The PDF Reader control in version 27 offers end users numerous options for handwritten signatures:

• draw signature with the mouse,
• keyboard input with a cursive font,
• image from the clipboard,
• image from disk.
• ...

Signatures can be resized and moved with the mouse.
You can set an image and a position for the initials on each page.
The signed document can be saved, printed, sent by email...

Besides the PDF Reader control, the new Grayscale and BlackAndWhite options of the iParameterPDF function allow you to generate a black and white or grayscale PDF documents.

In version 27, you can generate files in PDF 1.7 (ISO 32000).

Version 27 includes 13 new Smart controls:

• Tokenized email address input with autocomplete,
• Form with non-blocking required input,
• Drag & Drop rows in a Looper control,
• WEBDEV PDF reader,
• WEBDEV timeline,
• Editable combo box,
• Popup side panel,
• Tokens as filters, with horizontal scrolling,
• ...

The Word Processing control now allows you to insert links to external images.
This avoids inserting the image itself, thus reducing the size of the document.
The image stored at the corresponding address is displayed in a preview resolution in the Word Processing document, and is printed in its actual resolution.

URLs in a text are automatically converted into clickable links.

XLTS and XLTM files are spreadsheet templates.
When an end user opens this type of file, a new workbook is automatically created.

In an XLSX file, sheets can be protected to prevent users from making changes. These sheets are displayed, but cannot be modified.
A password is required to make any changes. Version 27 supports this type of protection.

• The Excel Index function is available

A new type of chart is introduced in version 27: the Radial Bar chart.
This type of chart is mainly used to compare target values or market shares, or to illustrate a progress percentage (the full circle represents 100%).

The Radial Bar chart control can be populated programmatically, just like any other chart control.
You can manipulate this type of chart using grRBxxx functions.

The Image Editor control allows you to include a full-blown image editor in your applications. End users can edit images and photos directly in your applications, without having to install and use third-party tools.

A new feature in the Image Editor control allows end users to easily blur an area of the image.

In version 27, the Image Editor control allows end users to define an area on an image and run OCR to retrieve the text from that area.
This makes it possible, for example, to automatically retrieve a delivery or billing address, the contents of an order, etc, ...
In version 27, OCR processing requires zero code.

You can blur part of an image or Image control programmatically.
To blur a control, simply use the new dBlur WLanguage function, passing the name of the control and the percentage of blur as parameters.
To blur an area, simply pass the coordinates of the area as parameters.

The tool selected by default when the image is opened can be defined programmatically.
The default size of an image created in the Image Editor can be set programmatically.

Developers have an image editor at their disposal in the environment. You are probably familiar with this tool.
The Image Editor control includes all the features of this image editor.
Developers benefit from all these features.

As you know, it is possible to use WINDEV, WEBDEV and WINDEV Mobile in the same environment.
Project elements are immediately shared between all 3 platforms: analyses, queries, reports, procedures, classes, code, ... Windows, pages and mobile windows are in the same project.
These elements open directly in the WINDEV environment.
This allows for easy maintenance and portability of a WINDEV application to mobile and Web, without having to import or duplicate elements of the project.
Reminder: you need a license of the corresponding software products.

In version 27, you can create cross-platform components for Windows, Linux, Web, iOS and Android.
This makes code sharing even easier.

In version 27, the <Block> and <Compile If> statements can be used in the declaration of a constant.

Developers often need to transform Windows applications (or parts of applications) into dynamic websites or SaaS applications.
WINDEV and WEBDEV 27 are ideal tools for this purpose.

When a standard ".FIC" data file is dragged and dropped into the data model editor, its description is automatically imported without opening the import wizard.

The context menu now includes an option to edit the connections of one or multiple data files: practical feature.

The performance of the environment has improved in version 27 in many areas, such as:

• Template updates.
• Multi-core compilation, which optimizes the number of cores used.
• Compilation after SCM updates.
• Generation of WEBDEV pages.
• ...

Until now, WINDEV, WINDEV Mobile and WEBDEV projects were saved in the My Projects, My Mobile Projects and My Sites directories, respectively.
To improve interoperability, in version 27, projects are stored by default in a single directory: My Projects.
When you install version 27, you will be prompted to store your existing projects in this unique directory.
Duplicate project names are managed by default.

The new style selection window is much more user-friendly.


The new layout makes it easier to find a style, for example.
The size of the style preview adapts to the type of control.
Also, the preview background color adapts to the current window (dark or light theme).
A context menu shows quick actions.
All style sheets are presented in a single window, which makes selection easier.
An icon is shown next to overridden styles.

Version 27 includes a new pane to view all the elements of a window, page or report that contain code.
This allows you to see at a glance where the code is in a given element.
This tree appears in a new pane in the environment.

In version 27, the environment includes a practical help pane: this pane shows a summary of the function, the return value, the parameters, their type and purpose, as well as a link to the full help page and the professional forum.
You no longer need to leave the editor to access this essential information!

The alignment of elements in a window keeps evolving in version 27:

• It is now possible to align controls from a template.
• You can align control using a column of a Table control as a reference.
• Non-movable controls are ignored.

Elements in edit mode can be undocked and positioned outside the environment.
When the element is moved back into the environment, the areas where it can be re-docked are highlighted.
In version 27, holding down the Ctrl key allows you to freely position this element.
Make sure you try this practical feature!

Your favorite environment comes with a rich catalog of images and icons: tens of thousands of elements available at no extra cost!
Many images and icons come in black & white.
In version 27, a new option allows you to apply color to these elements.

Very often, developers need to open a file explorer directly on the project directory or the EXE (or generation) directory of the current configuration.
The "Folder" button in the ribbon allows you to do so with a single click!

You can move a control by a precise number of pixels, using the status bar in the environment: it is now possible to type "+10" or "-5" to move the control along the X or Y-axis.

• Edit Calendar control styles more easily
• Faster zoom (CTRL+ mouse wheel)
• The image catalog is enriched with Windows 11-style icons

Table controls columns have a search Automatic Application Feature.
Starting with version 26, Table controls use a "Contains" search mode by default.
Older tables used a "Starts with" search, which was not as practical.
The static audit in version 27 identifies the old search modes.
It takes only 2 clicks to use the new search mode.

In a multithread process, access to variables must be protected by critical sections.
The dynamic audit identifies accesses to unprotected variables, thus preventing bugs and unexpected behavior.

At runtime, the content of a control may overflow the view area.
It can be data displayed or the text of a control modified programmatically
The dynamic audit in version 27 reports all overflows detected at runtime.

A sprint or iteration is a development cycle.
In agile development, a project is divided into a set of sprints.
The Project Management Hub now integrates this method.
A sprint has a start and end date, and can contain requirements, tasks and incidents.
The different sprints are clearly represented.
A schedule with a Gantt chart layout shows the selected sprints.

New statistic available: the number of tickets fixed by a developer between 2 dates.
A new chart shows the trend of new and fixed issues.
Of course, you can directly open each ticket from this list.

A requirement can be created from a message in the integrated messaging system.
You can now follow and continue the discussion thread related to that requirement/incident.

Tags are used to classify incidents.
One or more tags can be associated with a ticket: "Minor bug", "Regression", "UI", ...
Tickets that don't have any tags are identified as "No tag", which makes it possible to find and classify them.

• New incident management options have been introduced (ability to specify workarounds, multiple screenshots, new incident states, etc.).
  
• The window interface is more intuitive.

The automatically generated technical documentation now allows editing information about the generated REST web services.

In version 27, when the automatic UI audit detects a control or parameter that can be improved, an icon appears next to that element. By clicking the icon, you can view the details of the change to be made.

The lifecycle of some projects span several years: this is quite common
Often, projects use features that date from the time the project was created (technologies that are now outdated or that have been replaced by more secure alternatives), options that have become useless, inefficient. Sometimes, it is necessary to enable more recent options.
Version 27 indicates the deprecated technology or the new features and proposes the technology to be used.
This may include, for example:

• an HTML control still in IE6 mode (which prevents modern content from being displayed correctly)
• a Chart or Shape control for which anti-aliasing has not been enabled
• a Camera control in an old version
• any control for which a new useful option is available but has not been enabled
• a Combo Box control that can be made resizable or set to auto-size
• enable autocomplete for controls with a file path input mask
• ...

• a background image with transparency but without clipping (which consumes resources unnecessarily)
• an Internal Window control that points to an Internal Window not found in the project
• Binding to an non-existent item or variable
• Control not compatible with the current configuration
• Control too small to be touchscreen-friendly
• Conflicting anchors
• Multiple controls with the same logical name.
• 2 OK or Cancel buttons in a window
• ...

Using controls with deprecated features can have a negative impact on the performance of your editors, slow down execution, generation, template updates, etc, ...
It is therefore a good idea to replace these old features with up-to-date alternatives.

Old features slow down execution.
A simple way to increase the speed of your applications is to replace these outdated features.

In WEBDEV in particular, using controls with outdated features or parameters can result in larger and more memory-intensive pages.
Updating your controls will significantly optimize size and memory consumption!

Environment variables have been introduced in the Software Factory.
An environment variable is a value that can be used in the configuration of action plans: a major version number, for example.
This avoids having to modify all action plans that use that value.

It may be necessary to reboot a computer at regular intervals, for example every 2 days: reset Windows memory, ...
In version 27, this can be scheduled in the Software Factory administrator.
The robot will complete the current action plan before restarting the computer.

In Continuous Integration, success notifications can quickly clutter up your messaging system...
In version 27, you can select the type of messages you want to receive, for example only error messages.

In version 27, a new action has been added to the action plan editor: Automatic deployment on the PCSCloud.net server.
You can define multiple PCSCloud deployment profiles.

In version 27, the User Groupware allows you to create profiles where all actions are blocked by default.
The administrator will have to authorize each action manually...
No more risk of unblocking a sensitive functionality by accident.

gpwGetUserInfo, a new WLanguage function, gets all the accessible information about the current user in a single line of code.

You can open a Git project directly from the environment.
No need to use a different tool!

You can view the Git history of an element directly in the environment.
No need to use a different tool!

A WINDEV "Control" is a remarkably powerful and useful object.
In version 27, the internal format of the control has segmented properties, which reduces conflicts resulting from concurrent modifications of different elements: it is less likely that multiple developers try to modify the same segment.

You can view the Git history and compare changes of an element directly in the environment.
No need to use a different tool!

The image editor integrated in the environment benefits from all the new features of the Image Editor control introduced in version 27.

WDMSG now allows you to perform searches in files to be extracted.

WDTRAD boasts a new UI and new practical features:

• Find/replace in the dictionary with regular expressions
• Improved translation search: Regular expression search before full-text search
• Dictionary window: floating tab panes
• New translation propagation option: to the whole document or to the elements currently displayed
• Filters on search results are saved,
• Multi-selection in search results: useful for bulk editing, ...

In version 27, the SCM includes a new pane that shows which elements have been checked out by the team, and which developer has checked out each element, all in real time.
This provides an overview of the work in progress at any given time...
This pane also allows you to send a message to the developer who checked out the element.

The history window of an element displays the revisions.
In version 27, this window also displays the details of this revision: all the elements involved in the revision.
3 actions are available by clicking on an element:

• view the history
• view the changes in this revision
• save the element to disk.

In version 27, check-in requests sent to a developer appear directly in their environment!
If the environment is closed, the message is kept on hold and will be displayed when it is opened again.

In version 27, when you open an element, a notification appears immediately if another developer has already checked out that element.
You won't have to find out later on when you try to make changes...

You can view the history of an element without blocking the environment.

The methods for renaming project elements and managing relations between controls during a merge operation have been reviewed and improved.
In earlier versions, some changes had to be propagated manually between branches. Version 27 automatically propagates changes made to the following elements:

• Radio Button and Check Box options
• Table control columns
• Looper attributes
• Tab panes
• order changes
• relations between controls (controls contained in other controls)
• ...
  You will be notified if a manual action is required.

• Easier access to multiple SCM repositories
• Branch creation: the error report (if any) is displayed only after the branch has been created. Minor errors no longer interrupt the branch creation process
• Branch creation: shared files between projects are always managed

The current technology for managing multilingual strings is kept for compatibility.
A new technology has been implemented in version 27 in order to make things easier.
It gets rid of the numbering used for multilingual strings, along with its constraints.

Code completion evolves in version 27.
The three most relevant suggestions appear at the top of the list.
These suggestions are the result of an AI learning process fed by a large number of projects.
The input history is also used to select these suggestions.
For example, if an int variable is declared, it will appear as a suggestion in the following call to a function that uses an integer.
Another example.: after a line of code containing the HReadFirst function, HReadNext will appear in the suggestions as soon as you type "h"...
You will certainly enjoy this new code completion feature.

The code editor offers code completion for all the arrays in advanced types.

Code wizards ask questions to generate the code or set the appropriate parameters.
3 new code wizards are introduced in version 27:

• define the parameters of HTTPSend and RESTSend
• httpRequest type initialization
• using AuthIdentify

A new option in version 27 allows you to change the code of an existing project to prefix syntax.

• The procedure documentation completion feature becomes more user-friendly
• Code completion now also includes WLanguage keywords.

In version 27, you will never forget that you are in debug mode!
The status bar of the environment changes color to orange during a debug session.
Simple, yet useful!

WINDEV, WEBDEV and WINDEV Mobile version 27 form an increasingly cohesive DevOps environment.
You benefit from all the necessary functionalities to implement the DevOps approach: no more scattered, barely-compatible tools.
You have all the integrated tools to manage the DevOps methodology: lifecycle management, sprints, testing, continuous integration, deployment, continuous delivery, production, user feedback, ...

The new feature that allows you to identify controls that contain code is essential in the report editor!
The code can be in different processes of the report.
Version 27 makes it easy to resume development on a report created years before or created by another developer.

Many users print Gantt charts.
Version 27 provides additional settings:

• you can display week numbers
• you can display an indication of the current day.

The blur option has been added to the report viewer (report print preview).
The end user can blur or redact one or more areas, usually containing sensitive information, before distributing or printing the report.

The new Hidden property and the Blur and Redaction constants can be used to specify the name of the area or controls to be blurred or redacted when printing a report.
The level of blur can be adjusted.

Version 27 features an artificial intelligence engine to detect objects in images.
The new AIDetect and AIDetectModel, functions, as well as the aiImageResult, and aiNeuralNetworkModel, WLanguage types, allow for easy programming.

Note: we are not objects, sure, but the concept of "object" also includes living beings.
82 objects are included as standard: face, human being, dog, cat, table, car, license plate, ...
You can define other objects to be detected. In this case, you will need to provide the object recognition model.

There are 3 common uses for the standard list of objects:

• detect all objects in the image
• detect a given object in the image: all dogs, all cars, all license plates...
• detect a given list of objects.

AIDetect returns an array of aiImageResult containing the type of object, the coordinates of the polygon that contains the object and the confidence level.
On the other hand, code that uses custom models returns a matrix that depends on the provided model.

There are many examples of the use of automatic object detection:

• Blur an object automatically: face, license plate...
• Detect a face in a profile picture
• Crop a face
• Count vegetables automatically
• Classify images
• Count
• ...

The multithreaded compilation mode introduced in the previous version significantly improved compilation times.
Version 27 is even faster, as it uses all available cores by default.

As presented above, in version 27, multithreaded compilation uses all available processor cores by default.
You can specify the number of cores to be used, which allows you to tune performance, handle special cases, and allow other processes to continue to run at reasonable speed.

The Open WLanguage function uses a variable number of parameters.
To avoid entering all the parameters, it is now possible to name the parameters and enter only those that are used.

The /= and *= operators are introduced in this version.
Just like the += and -= operators, they simplify source code.

A new way to comment code is now available.
/* indicates the beginning of the comment, and */ indicates the end of the comment, which can span over multiple lines.
This syntax also allows you to comment out a section of code in the middle of a line!
Example:

Version 27 supports the " (quote) syntax, to make entering multiline strings easier.

In version 27, lambda calls, property getters and setters are faster.

You already know the difference between the ++ operators placed before or after the variable.
N++ increments the value after evaluating the expression, whereas ++N does it before.
That changes everything!
In version 27, both syntaxes are available: ++ and --

Regular expressions are a very powerful concept, and allow for very concise code.
In version 27, regular expressions are even more powerful.
You can search for and even replace a string in another string, using a regular expression!
All in one line of code.
Two new WLanguage functions are also introduced: RegexSearch and RegexReplace.

The Luhn algorithm is used to calculate the check digit of a credit card number, and to detect false numbers.
Two WLanguage functions are introduced in version 27 to calculate and verify this check digit: LuhnCalculate and LuhnCheck.

PBKDF2 is a very powerful hashing algorithm.
Its main purpose is to securely hash data, especially passwords.
This type of hashing is also used to obtain a series of derived keys (passwords) from a password.
The HashString and HashFile now accept the new PBKDF2 constant, which expects the salt, number of iterations and key size as parameters-.

The WLanguage functions used to handle HTML documents are already very powerful.
Version 27 includes new properties that further simplify code:

• The Index property is used to get the index of an HTML node.
• The Parent property gets the parent of a node

The new HTML WLanguage functions are useful as well:

HTMLInsertBefore	HTMLInsertAfter
HTMLWrap	HTMLWrapAllChildren
HTMLUnwrapAllChildren	HTMLRemove
HTMLInsertFirstChild	HTMLInsertLastChild
HTMLRemoveChild	HTMLModifyAttribute
HTMLModifyAttribute	HTMLRemoveAttribute

The INIWrite function only accepted strings as parameters.
Starting with version 27, INIWrite accepts parameters of type int, real, boolean, etc.

When the programming standard of a project defines the use of prefix syntax (control.function) as mandatory, a programming standard error can be generated at compilation time.

A new compilation directive allows you to define a specific mode (32-bit or 64-bit) for the compilation phase.
This is especially useful when using external APIs that only work in one mode, either 32-bit or 64-bit.

The new dBlur WLanguage function blurs a rectangle defined by coordinates passed as parameters.
A Gaussian blur is applied.
The radius of the blur is passed as parameter.

The error messages from Zip functions are more precise and allow a quicker understanding of the problems that may occur.

The EncryptStandard WLanguage function manages all the encryption parameters automatically.
In some cases, the encryption initialization vector is imposed by the device the application communicates with.
Now you can pass this initialization vector to the function as a parameter .

• The API description type now supports 1 and 2-byte integers, both signed and unsigned.
• It is now possible to edit an image's Exif data
• 32-bit applications can also access the 64-bit Registry, and vice versa.

There are 2 HTTP standards: http1 and http2.
When calling a server, the client and server "negotiate" to agree on the protocol version to use.
However, some servers use only one standard: http2.
Version 27 allows you to force the use of http2.

You can add a node to a SOAP web service header with the new SOAPAddHeader function.

In some cases, Delete HTTP requests require passing data.
In version 27, you can pass this data.

In version 27, the new JSONToXML and XMLToJSON WLanguage functions allow you to automatically convert one format to the other.
JSONXMLConverter, a new WLanguage type, opens new options to configure and customize the conversion process: conversion of XML attributes, namespaces, empty tags...

When aggregating arrays (members of type object), you can access structure members 30% faster in version 27.
The same applies to members containing arrays of objects.
This is a major advantage in projects where Object Oriented Programming is mainly used.

In version 27, the access to properties is faster. An improvement of over 20% was observed.

You can loop through an array of objects that contains derived classes, taking into account only the objects of a given class: it's a polymorphic FOR EACH statement.

Coding the and < and > operators is easier in version 27.
New compilation directives allow you to declare the members to be compared as well as the order of comparison.

• You can set the default comparison operator.
  
• The <Useful> and <ForceDestructor> attributes can now be used with classes.

Bluetooth Low Energy reduces the power consumption of the device.
This protocol is now supported in WINDEV, in addition to WINDEV Mobile.

You can now call Python code natively from WLanguage, just like .Net assemblies, SOAP web services, etc, ...
Importing the .py file into the environment allows the code editor to automatically recognize all the functions of the .py script.
Each function in the script is then considered as a native WLanguage function.
The Python engine is initialized using the PythonInitialize function.

• Python: Native calls
• Python: Use in WLanguage

HFSQL 27 improves the performance of different types of queries.
"Full scan" queries containing dates are 30% faster.
Queries with SQL "TOP", "BOTTOM" or "TOP/BOTTOM" clauses use much less memory.

Need to nest transactions?
You can use savepoints to roll back to an intermediate point of the transaction.
The transaction will be divided into smaller parts.
During the transaction, the HTransactionSavepoint WLanguage function allows you to define and name a savepoint.
To undo the part of the transaction after this point, simply use HTransactionRollbackToSavepoint.
You can set multiple savepoints in the same transaction.

Aliases have always been available in HFSQL.
An alias allows you to perform one or more iterations on a file already in use without affecting the current iteration(s).
The use of aliases is simplified in version 27.
Simply write:

and that's all there is to it!

In version 27, HExportJSON can also be used to export the data file or query to a JSON type in WLanguage, no longer only to a file on disk.

A stored procedure can return records or an array of records.
Programming is much more... structured.

When the connection to the server cannot be established, a message is generated.
The number of server connection error notifications is limited so as not clutter up your inbox with the same message.

Universal Assisted Replication can now also be installed on a WEBDEV Application Server. This server can run on Windows or Linux.

The U.S. National Security Agency (NSA) requires at least AES-192 for top secret information.
HFSQL 27 supports both AES-192 and AES-256.

• Now you can rename one or more servers in a Server Replication.

In version 27, a new advanced type of HFSQL item is introduced: the Password advanced type.
This new type of item does not store the actual password.
The password entered by the end user won't be stored as is.
This means there are no chances of hacking into the database to obtain this password.
How is this possible?
Before being stored, the password will be both salted and hashed.
Salting consists in adding a random string to the password. If two users enter the same password, their salted passwords will be different.
This salted password will then be hashed, making it unidentifiable.
The result of these irreversible operations is stored in the database, instead of the original password.
Attackers cannot cannot reverse engineer the password from the result of these operations, but you can still check if a password matches the original one. The password cannot be read, but it can be compared.
You can configure the type of hash, result length and number of iterations.
With this new type of item, hackers can no longer steal passwords by accessing the data file.

To determine if a password is valid, simply compare the string entered and the content of the Password item (using the = operator).
Since WLanguage is a 5GL, it recognizes the types of the operators and automatically performs the necessary operations. No special programming required!
All related WLanguage functions automatically adapt to this particular type of item.
It supports the Null value and cannot be defined as index in the data file.
The LastCheckDate property returns the date the password was last written to the data file.

2 new SQL functions for resuming transactions are introduced in version 27.

ROLLBACK TO SAVEPOINT	Rolls back all actions performed within the transaction since the savepoint was established.
SAVEPOINT	Defines and names a new savepoint within the current transaction.

SQL queries written in the code accept a new, useful syntax: [% variable_name %].
At runtime, the variable name between "%" characters will be replaced with the value of this variable.
This avoids having to declare and assign a value to a parameter.

In version 27, HFSQLDrive supports stored procedures.
This optional functionality will be available early next year.

In version 27, HFSQL Cluster improves support for automatic data modification:

• Links
• Secure files
• ...

• Improved installation
  
• New HClusterMasterNode function, to get the cluster master

HFSQL Spare is a near real-time server backup solution.
Version 27 allows you to rename the spare server.
Simply enter the new name in the HFSQL Control Center.

The HFSQL Control Center boasts many practical improvements.
In particular, the HFSQL Control Center is no longer blocked by data file reindexing requests.
This is very convenient.

The Native Oracle and MySQL Connectors now support transaction savepoints.

FOR EACH loops that use a condition are faster with Native Connectors in version 27.

The treeview mode in the main window of the query editor now includes a search icon.
This gives you the ability to select items more quickly.
A search icon is also available for output items.

In France, electronic invoicing has become mandatory for invoicing government services.
The French government has set up the Chorus Pro system to submit and monitor invoices. It is the tool for managing the expenditure and non-tax revenues used by French government services.
All companies must use Chorus Pro to send their invoices to the French government services.
Version 27 takes into account the latest changes to the Chorus Pro APIs and protocols, and makes it easier to automate the invoice submission process.

A new input mask is introduced in version 27: the Bitcoin input mask.
This mask allows you to enter values in the unit of your choice: BTC, mBTC, Satoshi.

Telemetry allows you to collect and aggregate anonymous or non-anonymous information on how your applications are used: selected menus, functionalities used, duration of processes and queries, possible bugs, use time ranges...

Widgets can be used to display data retrieved via custom metrics.
In version 27, you can easily create new widgets from existing ones.

It is now easier to create unit tests: you can do so directly from the code header.
Additionally, if a window contains unit tests, they now appear in the header and can be started directly from the code editor.
This encourages developers to create and run tests, thus improving code and application quality.

A given test can be run with hundreds or thousands of different data sets (iterations).
The TestCheck WLanguage function allows you to make sure the result of a test is valid.
In version 27, when TestCheck encounters an error, the test stops automatically in the debugger on the current iteration: you will know exactly which dataset was used for the test (current iteration), making debugging easier.

In version 27, you can set automated tests for internal components.

In version 27, the Monitoring Robot also monitors the physical status of hard drives.
An alert is generated if a possible error is detected.

In version 27, the Monitoring Robot also monitors WEBDEV Clusters.
An alert is generated as soon as a problem is detected.

SCMDrive can now connect to the Control Centers.
In version 27, the Monitoring Robot can send alert messages to users registered in SCMDrive.

In version 27, you can use secure SMTP servers (ports 465 and 587) to send alerts.

2 new functions for Redis databases are introduced.

RedisGet	Gets the value of a key from a Redis server as a string.
RedisSet	Changes the value of a key on a Redis server.

Version 27 offers many other new features that you will discover once you order and receive your software...