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,888 other followers

Archive for the ‘Delphi’ Category

Delphi: OldCreateOrder in inherited TDataModule might suddenly become True

Posted by jpluimers on 2020/04/08

Interesting observation that might have been in Delphi for more than a decade: [WayBack] Found something strange in Delphi again which I’ve been trying to fix for days until I discovered it’s probably a Delphi issue… – Stefaan Lesage – Google+.

I think the summary is that if you have inherited TDataModule instances, then the descendant will always have OldCreateOrder set to True.

It is reported as RAD StudioRSP-20016 TDatamodule.OldCreateOrder always resets to true on descendants, but it is present in at least Delphi 7, so likely is in the old QC database:

Uwe Raabe:
I can track this error down to Delphi 7 (really)! Cannot check Delphi 6, but Delphi 5 just doesn’t have that property.
The reason lies in TDataModule.ReadState where

FOldCreateOrder := not ModuleIsCPP;
is set.

These might be related:

–jeroen

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

Debugging Delphi applications inside a Windows Docker container – yeiei.net

Posted by jpluimers on 2020/04/07

A docker container that pulls the PA server for Windows and steps how to attach to it and a video showing how to do this: [WayBackDebugging Delphi applications inside a Windows Docker container – yeiei.net

Cool if you do Delphi server side stuff.

Via: [WayBack] Hi delphi friends! If you are planning to use Windows Docker Containers and Delphi, you’ll need to read this: https://yeiei.net/en/debugging-delphi-appl… – Juan Antonio Ruzafa – Google+

–jeroen

Read the rest of this entry »

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

In SQL Server use `SET NOCOUNT ON` so tools taking the last modified record count won’t be confused by your trigger.

Posted by jpluimers on 2020/04/07

Interesting read: Time eating bug of the day… – Fabian S. Biehn – Google+.

TL;DR: in SQL Server use SET NOCOUNT ON so tools taking the last modified record count won’t be confused by your trigger.

Source: [WayBackTime eating bug of the day: I used a TADOQuery.ExecSQL (on Berlin) for an Up…

Related: [WayBack] sql server – ADODB affected rows return trigger’s affected rows – Stack Overflow

–jeroen

Posted in Database Development, Delphi, Development, Office VBA, Scripting, Software Development, SQL, SQL Server | Leave a Comment »

Cool Delphi IDE idea: when moving a project, not just adjust absolute file paths but also search paths

Posted by jpluimers on 2020/04/02

The IDE already owns and modifies your .dproj and .dpr files (of which many users complain, but I think it is a good thing), so this is a great suggestion: [WayBack] Possibly slightly obvious but nonetheless a minor little tip to bear in mind when moving a project (.dproj/.dpr) by saving it to a new location (which I… – Walter Prins – Google+

Possibly slightly obvious but nonetheless a minor little tip to bear in mind when moving a project (.dproj/.dpr) by saving it to a new location (which I encountered this morning):

While the IDE will automatically adjust form/pas file paths for files included in the project in the .dpr for you, what it will not however do is also adjust the project “Search path” in a similar fashion, even though moving the project is guaranteed to break the project if it has project relative search paths and hence they would require adjusting.

That is to say, if you have project relative search folders specified in the “Search path” (and indeed the output folders), you will need to manually go and edit these paths in the project by hand when you change the project’s location.

(I’d argue that the IDE ought to update relative paths in the project options automatically given that it does so already for the .dpr; it would be the intuitive and graceful thing to do.)

–jeroen

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

In case I need JSONPath functionality in Delphi: grijjy/GrijjyFoundation@4ce069a · GitHub

Posted by jpluimers on 2020/03/25

From a while back, but just in case I ever need JSONPath (for JSON, or BSON Path): [WayBack] Added JSONPath functionality · grijjy/GrijjyFoundation@4ce069a · GitHub.

Via: [WayBack] Search for and extract data from your JSON documents using an XPath-like query language. Now part of our JSON and BSON library. – Erik van Bilsen – Google+

It has a small glitch on non-USA systems, so I filed an issue and provided grijjy’s Erik van Bilsen with a pull request:

–jeroen

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

 
%d bloggers like this: