Juan C.Cilleruelo

this is what I get when I try to install it from GetIt!

Always work. I only changed to version 10.4.2. No other change. Embarcadero doesn't need your excuses! He has his own ones!

Don't work on my own libraries and Code! Of course!

Seems it's doing something, but finally it doesn't do anything!

These days I've received the offer to renovate Delphi Professional Subscription, but this time don't come with the FireDAC Add-On, like past years. Asked my local reseller in Spain about this, he said to me that FireDAC Add On is discontinued. Does anyone know anything about this? Local reseller tells me about migration to Enterprise version, but there is not a special offer to upgrade from Professional version. He tells me that I need to buy a new subscription license, and I think this is very, very expensive, taking into account the type of product that I'm developing and selling. I think that Embarcadero is eliminating lower versions of his licences, converting Delphi into a luxury tool for development. This is not in concordance with the quality of his last versions. I'm currently using 10.3 Update 2, after tried to install, with a great effort of time and resources the 10.4. Version 10.4 was significant, for me. The worst experience in years with Embarcadero. Nothing is working, but when at last I got an installation running (Patchs and Update 2) I notice that Mobile functionalities are not installed. I've informed Embarcadero of this problem and he said to me that there is a problem with my license and that they are studying how to resolve it. Because of this, I continued developing with the 10.3 version. If Embarcadero is going to be as expensive per licence, I think this is the moment of study the possibility of migrating to another environment. Evolution is a need, but not at any cost!

Thank you to inform me!

Maybe the Preprocessing of SQL Statements. But I have not still installed Devart. Maybe Devart has something similar or better. By another hand, this is quite simple of solve, loading the query text from the code every time. I use it to do queries that depend on the dialect.

Change from FireDAC to another set of components like Devart is not going to be a problem in my case. My software follows a strict MVC architecture. All the Models are independent of the rest for the application and in fact, there are tested as a separate unity. I have a project of Unit-Tests that test separately all the models without link any Controller. Only some functionalities of FireDAC I'm going to miss, but I'm sure that in a new set of components I'm going to find new functionalities too, that is going to make more special the experience. The problem, in my case, is the frustration of making plans and see how Embarcadero doesn't take you into account. To see that Embarcadero trace his own plans without the worry about the plans of his customers. What's Next? Eliminate Professional version, perhaps? They coming bad times to all of us. Times in which the price can be a very, very, very important thing in all the ambits. In these new times, decisions based exclusively on money are going to be frequent.

FireDAC "A D D - O N " is discontinued.

I'm seeing Devart and seems to be a good option. But I can't understand his price policy. They only publicly a price. But I can't see the subscription price of the next years. It's this price every year?

My application generates a data file with instructions to generate a graphic file and after call an external program that processes this information and generates the graphic file. Next, my program, that is waiting until the graphic file exists, takes this graphic file and incorporates it to his database. The problem is the the time that the external application take to processing the data file. This time can be very large. An sometimes, my program traying to get the resulting file meanwhile the external program is processing it. This becomes in an OS exception. Can I ask to the OS, if the file I want to take is been still processing by another application? The program is cross platform, because of this I can't call the external application waiting to his finallization. And of course, if the solution is for crossplatform, more better. Thank in advance.

try WriteLicenseData; except on exception do begin raise; Exit; end; end;

All the code is from somebody who didn't understand, absolutely, the way exceptions work. This structure is not a punctual case in the code I'm revisiting, is a constant. Is on all the methods. I think that this type of wrong conception code is more than 30% of the whole code. It's because I commented it like 'paranoid code'.

Maybe, catch the exception with the intention of re-raise the same one, is useful for someone, but... the "Exit;" instruction too?

If anyone has not noticed, the previous structure is, in code, equivalent to: WriteLicenseData;

This was my first option, effectively, but, how to do this in Mac OS X?

Each error waits one second. I think is absurd repeat without allow the other process finish.

This is my current code. I think now is working well. Any idea! Thanks to all. ...... CountErrors := 0; while not (TFile.Exists(PNG_FileName) or (CountErrors > 5)) do begin Inc(CountErrors); Sleep(1000); end; Sleep(1000); CountErrors := 0; SuccessLoad := False; while (not SuccessLoad) or (CountErrors > 10) do begin try BlobField.LoadFromFile(PNG_FileName); SuccessLoad := True; except on EFOpenError do begin SuccessLoad := False; Inc(CountErrors); Sleep(1000); end; end; end; .....

The external program is OpenSCAD. I can't control how it works. The generated file exists during all the process. I can't control this.

#Delphi, #FMX, #FireDAC. I have a DB Field defined as DECIMAL(15, 3); This produce permanent fields on my program of the type TBCDField. All of this is correct. Sometimes I need to Assign the value of one of this fields to a local or class variable. Which type do you recommend for this variable to assure I do not go to lost precision and the value is going to be near to an unaltered form?

In this case, if for measurements but is the same type of data I use for all economic values. I read an EU document in which he explains how to treat with decimal values in operations with Euro. It's easy: You always should take three decimals for all operations and finally show a "round half up" function to two decimals when you show or print the results. I can't remember where is this document, but if you need it you can search on the web. reference for "Round Half Up": https://en.wikipedia.org/wiki/Rounding#Types_of_rounding

Thank you all! Working again! The final solution was finally, use Currency. I can take this TFields AsCurrency and this works well. The problem comes from a modify in all the program. I had all the measures for the furniture in millimetres. This is a good thing for woodworking, but I have now a new customer that need my program for modelling complex things for 3D printing and he needs until hundredths of millimetres (two decimals). Solved.

Read the thread, please! Your response is not related to the theme! It's only the first thing you found in a google search. What kind of help is this? What solves?

Attila: This is not the problem. The database is well defined. Read the previous entries, please.

I understand that if instead use MyField.AsBCD, I use MyField.AsCurrency, I don't loss precision, because is his internal representation. Do you think? I'm going to do some proves.