mvanrijnen

Problem is that many of these type of errors, expose only in larger projects.

Someone at EMB or IDERA should communicatie then why problems are not solved as expected. But communication besides sales spam is the biggest problem for EMB. (this is again a plus point for moving to another dev platform, the minus points are not holding it for many years i think)

They have the same with the Delphi IDE 🙂

Why not override DoTerminate? (leave the events for users of the class (owners/creators) TMyClass = class(TThread) private ......... protected procedure DoTerminate; override; .............. procedure TMyClass.DoTerminate; begin {TODO -oOwner -cGeneral : My Code } inherited; end;

Or in case of Interbase database, you could fix something with changeviews also. Link1: ChangeViews - InterBase Link2: InterBase (embarcadero.com) (currently not working)

Queries are shortened from the real query's. (the problem is in the underlined lines of code) SELECT DISTINCT slm.sma2_log_merged_idno FROM sma2_log_merged slm INNER JOIN sma2_message sm ON (sm.sma2_message_idno = slm.sma2_message_idno) AND ((sm.ignore=FALSE) OR (slm.is_alarm=TRUE)) INNER JOIN sma2_plant sp ON (sp.sma2_plant_idno = slm.sma2_plant_idno) AND ((sp.ignore_untill IS NULL) OR (sp.ignore_untill<CURRENT_DATE)) --AND (sp.deleted_for_me=FALSE) AND (NOT (sp.deleted_for_me=TRUE)) WHERE ((slm.forget_until IS NULL) OR (slm.forget_until<CURRENT_DATE)) AND (slm.deleted=FALSE) AND (slm.afgehandeld=FALSE) AND (((slm.datetime_end>= '2021-12-03') AND (slm.leeftijd_in_dagen>=2)) OR (slm.is_alarm=TRUE)) Prepared in: 0.825 sec Processes in: 0.0190 sec SELECT DISTINCT slm.sma2_log_merged_idno FROM sma2_log_merged slm INNER JOIN sma2_message sm ON (sm.sma2_message_idno = slm.sma2_message_idno) AND ((sm.ignore=FALSE) OR (slm.is_alarm=TRUE)) INNER JOIN sma2_plant sp ON (sp.sma2_plant_idno = slm.sma2_plant_idno) AND ((sp.ignore_untill IS NULL) OR (sp.ignore_untill<CURRENT_DATE)) AND (sp.deleted_for_me=FALSE) --AND (NOT (sp.deleted_for_me=TRUE)) WHERE ((slm.forget_until IS NULL) OR (slm.forget_until<CURRENT_DATE)) AND (slm.deleted=FALSE) AND (slm.afgehandeld=FALSE) AND (((slm.datetime_end>= '2021-12-03') AND (slm.leeftijd_in_dagen>=2)) OR (slm.is_alarm=TRUE)) Prepared in: 0.823 sec Processed in: 21.851 sec ?? So here's a big differnce between "AND (sp.deleted_for_me=FALSE)" and "AND (NOT (sp.deleted_for_me=TRUE))" deleted_for_me is a not null field so always contains a TRUE or a FALSE value. (performed in Database WorkBench 4)

going a little bit offtopic, but what are the better alternatives ?

yes we use it also, (my collegue somewhat more than me).

thhx, i was tested positive last week (pcr test), no serious complaints, but have to keep the quarantaine time. few more days. @TimCruise We don't get to know which variant, only Positive/Negative for corona, the variants are determined by sampling the positive results i believe.

will take a little longer, tested positive with selftest for corona this morning, so in quarantaine@home now. (PCR-Test @GGD/healthcare test this afternoon)

Ok, and what would be the minimum hardware for this, Apple Mini (2014 ??) ? Or are there virtual solutions for this (legal ones) ?

No it's not what i mean, probably i pointed to the wrong example 🙂 I'll try to make a simple example tomorrow, of what i mean, already created ticket with EMB support for it, but for now no solution. When you log a user on to the RadServer, you get an EMB-X-Token, for further use with the restcallss (a session token), you can not have multiple session tokens for one username. (go into the db of radserver, and it explains itself). If else, then we got the wrong explanation from EMB self. (i can look that up also).

just try the example: Tutorial: RAD Server Client Application to Manage RAD Server Users - RAD Studio (embarcadero.com) simultanously from 2 different computers.

have you tried to login as the same user twice ? with the same applicationid ? Of course in pure REST you would not have to logon, but everyone uses sessions, you can't get a second sessionid for a user with RADServer at the moment. So I (we) have implemented our own sessions and authorisation within appserver, skipping the provided ones. That said, it's a good start of to get started with web/micro services and the rest idea. We are no a month in production with the first application and it runs ok., in januari we launch our 2nd (inhouse) application for this. We run it on a IIS Server, for outside world we put a nginx server in between wich does the client/server certificate authentication and the routing to (possible) different in house servers. (we could do this also on IIS, but felt saver with this solution)

This discussion is every time a new delphi version is released it seems. And there are people with no problems at all, and there are people with mediocre problems, and there are (as am i and my collegue) people who get frustrated with every update/ugrade 🙂 Maybe EMB would do good to investegate why some (i don't know how many) people have still such big problems with Delphi, is it some specific component, but i do not see any efford from EMB to fix some problems for once and for all (LSP anyone) We did upgrade every 6months/year, but we are waiting with upgrading to D11 now, to few bugfixes for us to go over. keep noted, that this is just my opinion and i do not speak for the whole world.

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 ?