-
Content Count
23 -
Joined
-
Last visited
Community Reputation
14 GoodRecent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
That Serenade looks nice. But because Delphi is not directly supported: You can try Windows native Text to speech - if it is supported in your language. Or for your needs maybe VoiceAttack could be simpler - to add basic hotkeys and scripts.
-
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?
-
Warning: Windows Update KB5028166 breaks NT Domains
DiGi replied to dummzeuch's topic in Tips / Blogs / Tutorials / Videos
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
-
Converting a very long text to concatenated strings?
DiGi replied to PeterPanettone's topic in GExperts
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...
-
RegEx performance
DiGi replied to Mike Torrettinni's topic in Algorithms, Data Structures and Class Design
I hope you will use https://emailregex.com/ - because invalid "email validations" are common and annoying. -
Generic set comparer
DiGi replied to Attila Kovacs's topic in Algorithms, Data Structures and Class Design
Can we please sit for a while and appreciate how cute the separating line with scissors is -
Anything sensible for source code documentation?
DiGi replied to A.M. Hoornweg's topic in General Help
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. -
handling predicate conditions
DiGi replied to David Schwartz's topic in Algorithms, Data Structures and Class Design
Are you asking for something like https://fluentvalidation.net/? I don't know about similar Delphi framework -
How do you deal with git conflict annotations added to DFM files
DiGi replied to David Schwartz's topic in General Help
Another tip: Use https://andy.jgknet.de/blog/ide-tools/ddevextensions/ with option Remove Explicit* properties. And always check modified dfms before commit.