DiGi

Refactoring was broken with 11.x too and was barely working with 10.x. I used it before quite regularly.

In VS it just works, pure magic...

Wait what? Nobody is talking about broken refactoring?

11 minutes ago, Sherlock said:

To be fair, Microsoft has declared SMBV1 deprecated as early as 2014 And recent installations of Wins 10 and 11 have SMBV1 deactivated by default. Finally killing it now altogether seems logic and overdue. And if you ask Ned Pyle (Microsofts guy in charge of this) you should have gotten rid of it years ago: https://techcommunity.microsoft.com/t5/storage-at-microsoft/stop-using-smb1/ba-p/425858

https://learn.microsoft.com/en-us/windows-server/storage/file-server/troubleshoot/smbv1-not-installed-by-default-in-windows

Well, blocking old SAMBA... I have some old NAS/Media center at home. And of course there are no new updates for ages. And I really don't waste money on new one because someone decides that it is not secure enough anymore and I cannot access it over LAN.

https://mariadb.com/kb/en/boolean/ - so it is TINYINT(1)

You can wrote simple

SELECT
  T.YourYearColumn, -- or whatever
  SUM(T.Option1) AS CountRowsWithOption1,
  SUM(T.Option2) AS CountRowsWithOption2,
  ..
FROM
  Table1 AS T
GROUP BY
  T.YourYearColumn;

Just try it by yourself and you will see results.

Which SQL Engine?

One table scan for whatever you want.
 

-- Assuming that Field type is TINYINT NOT NULL 1/0
SELECT
  SUM(T.Field1) AS SumField1,
  SUM(T.Field2) AS SumField2,
  ..
FROM
  Table1 AS T;


-- If you want special values. Or you can use IIF()
SELECT
  SUM(CASE WHEN T.Field1 = 'SomeTextValue' THEN 1 ELSE 0 END)) AS SumField1,
  SUM(CASE WHEN T.FieldMixed = 7 THEN 1 ELSE 0 END)) AS SumMixed7,
  SUM(CASE WHEN T.FieldMixed = 31 THEN 1 ELSE 0 END)) AS SumMixed31
  ..
FROM
  Table1 AS T;

Optionally if you prefer rows instead of columns you can use UNPIVOT + SUM + GROUP BY (for MSSQL, I don't know with other SQL engines that much but probably there is similar feature too)

Hi, after Rev 3897 (adding InitDpiScaler) procedure list is focused, not default edtMethods.

It works fine after I commented out calling InitDpiScaler

Windows 10, dual 1920x1200 / default DPI

I just wonder how do you get that text in your clipboard in the first place. Copy from another application (not from file on disk / http URL)?

@Stefan Glienke

Please can you release update for Delphi 11 and 11.1?

So, literally one and half hour ago we finally switched main branch to Alexandria. And now this...

15 hours ago, Mike Torrettinni said:

Seems like the only RegEx left in my apps will be for email validation. But this is called only once on user entry, so no performance needed.

The rest of RegEx will probably phase out slowly.

I hope you will use https://emailregex.com/ - because invalid "email validations" are common and annoying.

Can we please sit for a while and appreciate how cute the separating line with scissors is

1 hour ago, Uwe Raabe said:

You know you can collapse not only single XMLDoc sections, but also all of them in one go?

Just one offtopic question. Is there any undocumented keyboard shortcut for this specific fold? They are many shortcuts (like Ctrl+Shift+K+M) but not for Doc comments.

Are you asking for something like https://fluentvalidation.net/? I don't know about similar Delphi framework

Another tip: Use https://andy.jgknet.de/blog/ide-tools/ddevextensions/ with option Remove Explicit* properties. And always check modified dfms before commit.

Many tools are just too basic. Only TortoiseGit provides almost all options in useful ways. Only issue is that it take time to configure it in way that you want and learn ways to do things. Like that you can create/switch branches from Log view etc.

It last year there was really huge improvements in Git for Windows and TortoiseGit.

Just one complete offtopic "funny" web: https://deadlockempire.github.io/ - find deadlocks yourself...