Xailer will soon be 20 years old and we want to celebrate it in style with you by presenting a very special offer that will be available throughout the month of June. For any version of Xailer we offer this offer:
20% discount on upgrades
40% discount on new purchases
These discounts are not cumulative with other discounts you may have.
The presentation was made in Madrid taking advantage of a meeting of xBase programmers from the Olivares 2000 Group, many of whose members have been advanced Xailer users for years.
I have taken the liberty of posting the photos of that meeting, in which you will surely recognize more than one (with a little less hair 😉 ). If any of those present prefer not to leave, leave it in comments and we will delete the photo immediately. In the same way, if anyone has photos from that day, I would love to include them.
I don’t want to end this article without talking a bit about the future of Xailer and what our short and medium term goals are, which are mainly two, but which involve a great effort and which we are sure will be very well received by the entire community:
Development of CGIs for Linux 64 bits using all the Xailer DataControls technology (integration with Nefele)
This control allows you to display animated GIFs with absolutely no lag or stuttering. And this is because the painting is done completely at a low level and in a second thread, which has a very high degree of complexity.
With this animated GIF control there is no need to call ProcessMessages() for the control to continue painting correctly.
It is available for any version of Xailer, even the personal one.
Xailer 8.1 includes High DPI support, which allows you to get the maximum resolution out of powerful 4K monitors. To activate it you just have to set the Appliction:lDpiAware property to true at the beginning of your application execution. That is all. What this property really does is that your program recognizes the true resolution of the monitor.
When windows is running on a high-resolution monitor and scaling other than 100% is set, programs receive “adjusted” resolution feedback, not the actual resolution. In the same way, when a program sets certain coordinates in a window, windows readjusts those coordinates according to the value of the scale that it has established. For example, if windows is set to 150% scaling, when a program sets the dimensions of a window to 400×400 pixels, windows resets it to an actual size of 600×600 pixels, including all controls within it. .
This means that we do not have to worry about the scale that Windows has configured, but it has the drawback that the texts and images look blurred. When we set Application:lDpiAware to .T., our program will work with real coordinates, with no adjustments by windows. The images and texts will look perfectly sharp and in their original size, even if this means that they will appear smaller than expected. In these cases, we can use the Application:nScale property to adjust the desired scale without losing the sharpness of images and texts.
This is a small improvement, but I think it is worth mentioning since it may interest more than one.
For the purists of the view-controller model, the use of the classic Xailer Data-controls is not appropriate, since all the editing process also occurs in the view, when it should be done in the controller. The most convenient way to avoid this problem is to use objects of type TMemDataset that return a memory recordset that is completely unbound from the table from which it came. But it has the disadvantage that the insert and edit operations are more complex since it requires the construction of the insert and update SQL strings manually. Let’s see how Xailer 8.1 solves this problem with a small example:
METHOD RSClientes( oRs )
METHOD ClientesUpdate( oRs, nId )
METHOD RsClientes( oRS as CLASS TMemdataset ) CLASS TControlador
WITH OBJECT ::oDatasource
IF oRs != NIL
:QueryMemDataset("SELECT * FROM CLIENTES", "", oRs )
oRs := :QueryMemDataset("SELECT * FROM CLIENTES")
METHOD ClientesUpdate( oRS, nId ) CLASS TControlador
WITH OBJECT ::oDatasource
:Execute(oRs:SqlUpdate("idCliente", nId ))
// Aquí se pueden hacer más operaciones de forma clara
The update operation is performed in the controller with the additional advantage that we can include any operation within the same transaction. For this, the new method SqlUpdate( aWhereCols, aWhereValues) is used, which creates the SQL statement with only the columns that have changed their value. As you can imagine, there is also a new method called SqlInsert().
Another of the peculiarities that this code has in its RsClientes() method that I think is very interesting is that the TMemDataset object is passed as a parameter, instead of being created in the method itself and returned as a return value, which could be the first approach that any programmer would make. This technique has a great advantage, which consists of being able to incorporate an empty TMemDataset into the form itself and even link it to a browse in which we have completely defined the columns and everything visually. If our method were responsible for creating the TMemdatset and returned it as a return value to then assign it to the browse with oBrowse:oDataset := oController:RsClientes(…) we would observe how all our browse columns would disappear since a new dataset and that causes a reset of the entire control. On the contrary, if we pass the recordset as a parameter, everything is perfectly maintained.
Xailer 8.1 will be published in the near future and in a series of short articles we will explain the new features that Xailer 8.1 will incorporate, leaving the most important ones for last. This is one of them.
The next version of Xailer 8.1 incorporates everything necessary to be able to do without any type of FTP connection. That is, all the classic operations that are carried out by FTP, such as:
deletion of directories
They are included in the new TWebDataSource class.
Note: The FTP services that TWebDatasource includes are limited to the directory where the PHP module is located and its dependent directories.
The use of the FTP protocol is becoming more complex every day due to the different existing options: secure FTP through digital certificate (FTPS) that can be implicit or explicit, through SSH protocol (SFTP) or non-secure FTP. Unfortunately the support of Microsoft Windows in its WININET library for any type of FTP apart from the non-secure one is null and the most appropriate option to attack this problem would have been to use the CURL library that is available in Harbour, but its use is complicated since it requires installing quite a few DLLs. The other option would be to use CURL by command line, which has been available in Windows for a long time, but that means having to ‘launch’ a console program from our application that programmers and users don’t usually like, and neither do antivirus programs.
For all these reasons and an additional one, which is that it is practically impossible for port 80 to be closed (which is the one used by the Web), we have decided to incorporate into our TWebDatasource class all the services that any class of file handling by ftp.
But already put, we have added one more service, which is the possibility of sending emails using one of the most used libraries in PHP, which is PHPMailer. As with the database access credentials to include in the PHP file, the same is true for the credentials for sending mail. In the PHP file itself and under the XA_SendMail() function, in a very simple way and without having to know anything about PHP, you can set all the parameters you want to send emails.
We remind you that this class is only available in the Enterprise version of Xailer.
After having turned our base version of Xailer into a completely free product and having been a complete success due to its great reception. Now it’s time to promote the professional version to make it much more interesting.
From the publication of this article, Xailer Professional receives two important news:
The inclusion of many controls that until now were only present in the ‘Enterprise’ version, such as:
Native access to MySQL, MariaDB and SQLite database servers.
Access to WIA scanner.
Access to the image editor.
A very important reduction in its price, which goes from € 395 to € 245
And also as a launch offer for this new version. We offer Xailer Professional at an upgrade price, that is, € 145 until June 30, 2021.
No more excuses not to start using SQL databases and definitely abandon DBF files. Furthermore, Xailer’s DataControls, included in the professional version, make the process very easy and intuitive. It is never too late to make the change.
Taking advantage of these Christmas dates, we have decided to offer our personal version of Xailer completely free and for an unlimited time. We remind you that this version is fully functional and includes everything you need to make robust management applications using any existing RDD. All the power of Xailer’s IDE, such as its fast debugger, intellisense support and its ease in creating executables, are available to the programmer.
We hope this offer is well received and encourages many users of [x] Harbor, Clipper and Visual FoxPro to try our integrated development environment for xBase. We are sure they will not disappoint. We thank you in advance that you can share this news.
This new version of Xailer starts directly from version 6.1 because version 6.0 has only been available for beta-testers and for a considerable time. Possibly, this new version of Xailer is the one that has been most tested before its final publication due to the update made in all the tools on which our product is based. We hope that the possible errors that can be found are minimal. And in any case they will be corrected quickly.
You need to completely rebuild all your projects, including any static or dynamic library that you are using.
Today we publish a new update of Xailer, the version 5.1.0 that corrects all the errors found until now and and is prepared internally for the imminent jump to Xailer 6 that will incorporate the latest version of Harbour, MinGW, SQLite, MySQL, MariaDB and Scintilla. Further information at: