Lajos Juhász

ord('C')-ord('A')+1, ORD('E')-ORD('A')+1, ...

Most probably the problem is the group by part. You've there O.Delvdate that is not in the select list. Interbase 2017 Update 1 (http://docwiki.embarcadero.com/InterBase/2020/en/Enhancements_to_GROUP_BY_and_ORDER_BY) introduced the extended syntax. If you're using a version that support you can write: SELECT O.DELVTYPE, SUM(OD.REMAINQTY) QTY, (Case O.DELVTYPE When 'Sea' then O.DELVDATE + 45 else O.DELVDATE + 15 end) as DELVDATE FROM ORDETAIL OD JOIN ORDERS O ON O.RNO=OD.RNO WHERE OD.ITEMNO = 'ABX22' GROUP BY O.DELVTYPE, 3 HAVING SUM(OD.REMAINQTY) > 0

I wonder how hard it will be to turn on UEFI on a laptop.

The first one will create TMyForm instance with no owner. While the second one creates an instance of TMyForm owned by the application object. In case the form is the first form created by the application it will make it the mainform of the application. For more detail open VCL.Forms.

There is no data type TxQuery it's TxQuery<T: TDataset>. Unfortunately in Delphi you cannot have a class reference to a generic class. I've even tried this: type TFDxQuery = TxQuery<TFDQuery>; TxFDQueryClass = class of TFDxQuery ; an it also fails with [dcc32 Error] Unit1.pas(43): E2021 Class type required I would expect that TFDxQuery is a class.

There is a bug in the code it will round up 5 to 10 so it should be: function RoundUpToFive (AValue : Double) : double; var lTrunc: integer; lMod5: integer; begin lTrunc:=Trunc(Avalue); lMod5:=lTrunc mod 5; if lMod5 = 0 then result:=lTrunc else result:=lTrunc + 5 - lMod5; end; Another interesting case would be how to round up 5.99 should it be $5 or $10?

You can read a file as a string: TemplateLines := TFile.ReadAllText(afilepath,Tencoding.UTF8 );

You can find information here: https://www.indyproject.org/2005/08/17/html-messages/

I do hope that you're aware that the IDE is still a 32 bit application and can't use additional memory.

Delphi 10.4 was unstable however it never failed to load. Something that you've installed made the IDE unstable. As @Vandrovnik wrote you should try bds.exe -r foo.

Place a break point in the DataModule most probably you didn't excecuted the code there and fdmAdmin.FieldDefs remains empty. That's the only way you get this error message.

Before next time just send a pull request.

There is a simple solution for this problem. Reorder the packages in the group, move the design time packages to the bottom.

Is it valid to name en.delphipraxis.net as a platform where you can find answers to your Delphi related problems?

Now it's also working for me.

I cannot load the page: "This site can’t be reached".

I've used that in my example and also it's better to implement the logic in AddObject as in the TStringList where method Add invokes Addobject with nil object.

It really depends on the data for a list of 3-5 elements my guess is a list is faster.

Your implementation of StrExists ignores the CaseSensitive property.

Check out the source and you can easily write your own version (a quick example code): uses System.RTLConsts; type TMyStringList = class(TStringList) public function AddObject(const S: string; AObject: TObject): Integer; override; end; function TMyStringList.AddObject(const S: string; AObject: TObject): Integer; begin if sorted then result:=inherited AddObject(S, AObject) else begin result:=IndexOf(s); if (result=-1) then begin result:=count; InsertObject(result, S, AObject) end else begin case Duplicates of dupIgnore: Exit; dupError: Error(@SDuplicateString, 0); dupAccept: begin result:=count; InsertObject(result, S, AObject); end; end; end; end; end;

No, there is no way and it's documented that Duplicates works only for sorted lists: Set Duplicates to specify what should happen when an attempt is made to add a duplicate string to a sorted list. The CaseSensitive property controls whether two strings are considered duplicates if they are identical except for differences in case. The value of Duplicates should be one of the following.

Try https://en.wikipedia.org/wiki/Windows-1251 one character is undefined hex 98. https://en.wikipedia.org/wiki/Windows-1250 there 5 undefined characters.

Did you filled a bug report also with Microsoft? Delphi uses HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\FontSubstitutes\MS Shell Dlg 2 on my Windows 10 that's still Tahoma.

If I remember correctly try ... finally was not effecting windows. I am using VCL for Windows so I could be still fine of course since I am enjoying my 2020 vacation I will test it in more details when I return to work.

The patch is looking good after 3 minutes of testing 🙂