mvanrijnen

I do know that yes, why the question, are you speaking for everyone ?

nah, it's not too expensive, upgrading just does not solve enough problems for existing customer, nor give it enough bugfree new feautures. The price is right for good tooling, it just does not live up to the price 🙂

It's a webserver with a "framework" around it to make it a little easier to develop and deploy your webservices. It's not too bad, but has some shortcomings, most pain is the fact that there is almost no documentation. What did you thought it was?

RADServer is a lot of promises, once using the product you find out you'd better choose another solution as a base for rest services. (we are still using it, but from week to week, less and less is used from the radserver itself), it's about the same as Delphi lot of commercial shit and shouting, but not really a usable product.

Yes i know, we do that every month here. But somehow the query which ran yesterday in 1.21 (on testdatabase), ran this morning in 0.37, so have to figure out what that is. The test DB is a database which get restored everynight from a backup from the productiondb. So it could be that some process is messing up the index stats or so, have some more testing todo before finding out.

I remember reading somewhere (not sure where 🙂 ) the opposite, some documentatin about this? Have to look this up, your variant with the original "AND (sp.deleted_for_me=FALSE)" is faster then my solution. man man, some work to do now 🙂 [edit] Seems we have some other problems here, the old query now performs faster also. (not as fast as it should)

We use het purely internally, you simply have to setup an internal MQTT server and point your clients to that, (i even have tooling to use the internal DNS as configuration for this, but we don't use this at this point yet).

We use this one (paid but not expensive): TMS MQTT Cross-platform messaging client library implementing the full MQTT specification. (tmssoftware.com) Works very good, we use it for signaling between apps and servicec etc.

reminds me to ask my boss for some speakers 🙂 no sound now 😞

If you specifing absolute paths, they would be loaded from the absolute location, can you try to monitor the service with procmon (sysinternals), and see what files en especially where the service tries to open them ?

nice stuff to execise on creating unittests 🙂

What is your actual question now? Maybe you can explain some more on your actual problem ? It seems you have to fill in your external ip address somewhere, and because this can change you email it to yourself/somebody? Can't you solve things with DDNS ?

It probably is against the licensing to use MSWord like that, it can not be used on a server as for as i know. There are solution in azure to expose central installed apps to remote users desktop.

Where did you run your query ? Did you have any output ? There has to be an error/exception somewhere.

Nice, i have my own helpers class, but with a lib like this it would be nice if you get set defaults, like global or on classlevel. So you would not have to decorate each TDateTime, or TStrings. just a tip!

Original query, does gives an error in DBWorkbench and FireDac (TFDQuery).

I did not try it out myself 🙂 I give it a try tomorrow, but i if there is no T2 table there should be an error/exception somewhere. (i'l try it out in DBWorkbench, and delphi with firedac)

You can change them, i have here at work not the availabitity over Win11 (real or VM).

Did youcheck at Advanced System Settings ? See screen shots, sorry dutch and win10, but same settings exists on Win11,

Little tip, always try constructions as this, with a simple select statement first. eg (not corrected, just as example!): SELECT * FROM TABLE1 T1 WHERE EXISTS (SELECT 1 FROM TABLE1 T1 WHERE T1.ID= T2.ID); so you have an idea what records are gonna be hit.

Why? I use it (@home), and it works just great. TS has to make sure that he has a dedicated main folder to put his dcu's in, which then has to be in the Exceptions list for Kaspersky.

Aks if they can make a few directory/folder exceptions for you, should not be that big a problem.

There are some policies what you can set gpedit.msc Computer Configuration>Administrative Templates>Windows Components>Windows Update But i believe microsoft can always push updates with nondomain member computers. (have to look that up).

maybe post a little bit more code, how do you logon, keep credentials, do you need to hve cookies, or headers in the request? here's something you maybe can take a look at: Quick And Easy Way To Integrate Firebase Into Your Delphi Apps (embarcadero.com)

I'm trying to catch the last active window in a traybar application. So as soon as the user rightclicks my traybaricon, the popupmenu shows, at that (or just before), i need to have the last active window (in windows, not a window of my application). I tried a few things with GetNextWindow(Application.MainWindowHandle, GW_HWNDPREV) and a few other options. but without success, anyone has a good tip in the right direction?