Jump to content

DiGi

Members
  • Content Count

    22
  • Joined

  • Last visited

Community Reputation

14 Good

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. DiGi

    Delphi 12 Athens Refactoring Broken

    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...
  2. DiGi

    Delphi 11.3 : FORSAKEN

    Wait what? Nobody is talking about broken refactoring?
  3. 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.
  4. DiGi

    Retrieve count values on different columns

    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.
  5. DiGi

    Retrieve count values on different columns

    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)
  6. 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
  7. DiGi

    Converting a very long text to concatenated strings?

    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)?
  8. DiGi

    Introducing Delphi Uses Helper

    @Stefan Glienke Please can you release update for Delphi 11 and 11.1?
  9. DiGi

    Delphi 11.1 is available

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

    RegEx performance

    I hope you will use https://emailregex.com/ - because invalid "email validations" are common and annoying.
  11. Can we please sit for a while and appreciate how cute the separating line with scissors is
  12. DiGi

    Anything sensible for source code documentation?

    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.
  13. Are you asking for something like https://fluentvalidation.net/? I don't know about similar Delphi framework
  14. Another tip: Use https://andy.jgknet.de/blog/ide-tools/ddevextensions/ with option Remove Explicit* properties. And always check modified dfms before commit.
  15. DiGi

    Git UI tools

    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.
×