Lars Fosdal

It may be that the Outlook 2003 OLE server lacks some of the interfaces that your OLE client implementation requires. 2003 is pretty ancient...

It seems that the @Inserted_Values temp table does not use TIMESTAMP. declare @Inserted_Values table ( WX_5Min_Key int NOT NULL, [DateTime] DateTime NOT NULL );

Have you looked into which joins that fail? Is it possible to see any differences in the stored data / parameters that can cause joins that fail? Is the type strictly identical - ie both parameters and tables columns are of the TIMESTAMP type?

Have you applied the most recent patches?

It is useful to post the actual errors for others to be able to think about the cause.

What target? Windows, iOS, Android, Linux? 32 or 64 bit? In the IDE or outside?

Which database do you use? Attached the reformatted SQL for readability. Personally I would never use a timestamp for a join, but that is probably just me. test.sql

The Delphi generics lack constraints support for enumerations and sets.

Perhaps @David Millington has a tip?

Hmm, yeah, that's a conundrum. A better pattern would be that your included subscription follows the cycle of the major version - i.e. 10.4.x.

I am on active update subscription. Can you even have 10.4.2 without one, considering that if you just bought 10.4.1 or 10.4.2 you would be within the one year subscription?

@Marco Cantu - Has the RAD Studio Web Installer been updated with the patches, or do you have to patch after installation?

In that case, it is silly that the patches are not in order, and that two of them have the same date. IMO, the description should have contained the patch number.

I assume order of installation is not important.

https://blogs.embarcadero.com/rad-studio-10-4-2-general-patch-and-delphi-compiler-patch/

Make that three patches.

@Dalija Prasnikar notified me that the try...finally issue that is mentioned as fixed is not actually fixed by those patches. There will be another patch soon. https://quality.embarcadero.com/browse/RSP-33117

Since I've not used MadExcept, I can't speak for that, but we use Eurekalog in several multithreaded NT services.

@A.M. Hoornweg The Eurekalog stack trace is for thread where the problem occurs. There also is an option to collect stacks from multiple threads at an access violation or exception, but it is usually not recommended since it is very resource intensive. Our service is heavily multithreaded as well, doing database work, multi-connection TCP comms, as well as serving a web UI to multiple concurrent users.

Eurekalog is invaluable for services. Eliminates the guesswork. Worth every €/$/£.

@KodeZwerg That's not portable, though - and the quality of the PRNG would depend a lot on the parameters to BCryptOpenAlgorithmProvider.

Don't know about good PRNGs, but get your seeds here. https://www.random.org/

That seems to cover the subject quite aptly.

TBH, I do not know how much C++ is done in VS versus other IDEs.

So, to get real traction for a C++ Getit, one could write a plugin for VS and flog the heck out of it on the forums...