The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

  • Twitter Updates

  • My Flickr Stream

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,920 other followers

Archive for October, 2019

Antipatterns in software development, architecture and management

Posted by jpluimers on 2019/10/30

If you develop software, be sure you recognise Antipatterns just as well as Patterns.

Luckily [WayBack] SourceMaking has a full sub-site covering software development, -architecture and management AntiPatterns: [WayBackAntiPatterns.

Of course it isn’t complete, so be sure to read [WayBack] The Majestic Monolith – Signal v. Noise as well.

via: [WayBackMartin Fowler on Twitter: “It’s an old anti-pattern, and sadly is still going strong: The Entity Service Antipattern.”

–jeroen

Posted in Design Patterns, Development, Software Development | Leave a Comment »

E2398 Class methods in record types must be static (Delphi) – RAD Studio

Posted by jpluimers on 2019/10/29

[WayBack] E2398 Class methods in record types must be static (Delphi) – RAD Studio present since at least Delphi 2007 ([WayBack] E2398: Class methods in record types must be static).

This is a Delphi compiler limitation for records, that is not present for classes.

Maybe one day when record inheritance kicks in, this will be resolved (as Stefan Glienke hinted in the below tread), because currently Self (which is present in non-static class methods on classes) then points to the current type. In static class methods, there is no Self, which is OK as that would point to the only available type anyway.

Via: [WayBack] why a class method of a record without the static keyword raise E2998 error ? AFAIK it can not be anything else then static ?! – Paul TOTH – Google+

Note that [WayBack] Error and Warning Messages (Delphi) – RAD Studio shows various other errors around the use of static:

All are marked “No further information is available for this error or warning.“, though they would at least deserve some examples.

–jeroen

Posted in Delphi, Development, Software Development | Leave a Comment »

Sparkle and WinSparkle – frameworks to update your applications on Apple Mac OS X / MacOS and Windows.

Posted by jpluimers on 2019/10/29

Since I will need these one day as native apps are useful:

via: [WayBack] Looking for ideas how to display to the users that ‘New version is available’ info… – Mike Torrettinni – Google+ which also has some good tips on how to notify the user about the availability of new updates.

–jeroen

Posted in Development, Software Development, Windows Development | Leave a Comment »

BNNVARA – De Wereld Draait Door – Boek: Beginnen over het einde – Henk en Nina Blanken

Posted by jpluimers on 2019/10/29

Just in time for a very heavy period in my life: [WayBack] BNNVARA – De Wereld Draait Door – Boek: Beginnen over het einde – Henk en Nina Blanken

It is about changing legislation about euthanasia in cases when someone has documented that urge, but cannot execute that urge any more because of for instance Alzheimer’s disease, or brain damage because of (metastasis of) cancer.

The driving force is writer Henk Blanken who was diagnosed with Parkinson’s disease 8 years ago, and has a very high change of getting Alzheimer’s.

From that page:

24 okt 2019

Acht jaar geleden werd oud-journalist en schrijver Henk Blanken gediagnosticeerd met parkinson. Daardoor kreeg hij ook een grote kans op dementie. Sindsdien strijdt Blanken voor een wijziging van de euthanasiewet. Hij wil dat zijn familie het moment van euthanasie kan bepalen, als hij dement wordt. Vandaag verschijnt daarover zijn boek ‘Beginnen over het einde’ met een manifest waarin hij een steunoproep doet voor een [WayBack] humaan levenseinde voor iedereen. Hij zit aan tafel met zijn dochter Nina.

His book is available as of today: [WayBack] Beginnen over het einde – Henk Blanken – De Correspondent

Nergens ga je zo prettig dood als in Nederland. Behalve als je dement bent. Waarom is euthanasie bij dementie zo moeilijk? Journalist Henk Blanken vindt een uitweg in zijn boek Beginnen over het einde.

[WayBack] Beginnen over het einde – Henk Blanken – De Correspondent

Nergens ga je zo prettig dood als in Nederland.

Behalve als je dement bent.

Want ook al mag het van de wet, geen arts helpt je bij het sterven als je niet meer begrijpt wat er gebeurt.

Waarom is euthanasie bij dementie zo moeilijk? En hoe kan het wél?

In dit openhartige boek laat Henk Blanken zien hoe belangrijk het is om op tijd te beginnen over het einde. Met je naasten en met je arts. Zodat je niet te vroeg dood gaat, maar ook niet te laat.

Op 29 oktober in de boekhandel!

For People in The Netherlands:

Read the rest of this entry »

Posted in About, LifeHacker, Personal, Power User | Leave a Comment »

Spring4d Marshmallow ORM – ensuring the right identifier quoting is used

Posted by jpluimers on 2019/10/29

When an ORM generates the SQL for a certain database back-end, it needs to use the right quoting.

Normally, the Spring4D Marshmallow project derives that from the back-end specific adapter used.

But if you use a generic TDriverConnectionAdapter, then you need to manually set the QueryLanguage property in your IDBConnection using a valid value from Spring.Persistence.SQL.Interfaces. This then uses the correct SQLGenerator from the TSQLGeneratorRegister to generate the SQL including correct quotes.

To quote identifiers, most back-ends use a double quote, but MySQL uses a backtick.

via:

You obviously already modified that code as the commented out code is the correct one.
I guess you already got that mistake when you started using MySQL via ADO as MySQL needs the backtick.

Set QueryLanguage of your IDBConnection properly (the valid values are in Spring.Persistence.SQL.Interfaces). Then the correct SQLGenerator will be used.
If you are using an adapter that is specific to a certain database then it sets the QueryLanguage properly but if you are using an adapter for components that can connect to multiple databases (like ADO or FireDAC) it does not, hence the need you specify it.

 

–jeroen

Posted in Delphi, Development, Software Development, Spring4D | Leave a Comment »

 
%d bloggers like this: