Zoran Bonuš

Setting SQL forces the FDQuery to close. My guess is that in combination with pooled connection, it might release the connection too. Have you tried setting the SQL before starting the transaction or even setting the FDQuery.Connection ?

You might try to debug and trace into the line where you set the SQL to see what after-effects it has in your context.

Blogpost about the update:

https://blogs.embarcadero.com/introducing-the-brand-new-konopka-signature-vcl-controls-8/#What_is_new_in_Konopka_Signature_Controls_8

And KSVC 8.0 has just been released

https://blogs.embarcadero.com/introducing-the-brand-new-konopka-signature-vcl-controls-8/#What_is_new_in_Konopka_Signature_Controls_8

KSVC 8.0 released

https://blogs.embarcadero.com/introducing-the-brand-new-konopka-signature-vcl-controls-8/#What_is_new_in_Konopka_Signature_Controls_8

The latest skia4delphi (beta) removes the need to deploy the .dll, as far as I inderstand it:

34 minutes ago, Stefan Glienke said:

Why?

I guess to help the compiler a liittle bit,  as explained here:

https://blog.marcocantu.com/blog/2022-december-suggestions-help-delphi-compiler.html

In such situations I use JSONReader instead:

https://docwiki.embarcadero.com/CodeExamples/Sydney/en/RTL.JSONReader

It's less convenient, but much more efficient when "sequential" processing of the json is possible.

I use F4 (Run to cursor) in situations like this ...to skip debugging parts i don't need to debug, but still stops when the program reaches the selected line.

Have you considered

https://winsoft.sk/acpusb.htm
(commercial)?

You may try the TNumberBox, available in the newer versions of Delphi.

https://docwiki.embarcadero.com/RADStudio/Sydney/en/Using_VCL_TNumberBox_Control

Have you considered creating LXC containers, instead of VMs? Should be less resource-hungry, easier to setup...and only slightly less secure (if set as not priviliged, which is the default).

How about testing .Visible in OnActivate?

Or starting a timer in OnShow and execute your code few ms later, when the form is already visible.

How about app tehtering? Ready to use components, multi-platform, ip/bluetooth app to app communication

https://docwiki.embarcadero.com/RADStudio/Alexandria/en/Using_App_Tethering

If you already use database of other data, I would go with the images in DB. Another form.of storage means also another thing to take care of backups, accessibility, security, etc.

Or you can use other 3rd party db components (commercial like unidac) with Delphi Pro.

Just for a reference, a recent blog post on the topic and a shared library by @Darian Miller

https://www.ideasawakened.com/post/use-createprocess-and-capture-the-output-in-windows

For a similar task I use this solution (the updated version), works fine by me:

https://stackoverflow.com/questions/9119999/getting-output-from-a-shell-dos-app-into-a-delphi-app

1 hour ago, Lainkes said:

I'm using MariaDB.

I have 1 table. In that table are 50 fields (string) that can be True or False.

I want a count of the True value for every field for a particular year.

I thought that SUM was adding values, not counting. Am I correct?

Thanks for your feedback

 

Lainkes

 

Right, but you can convert boolean to integer (1/0) and then SUM works like COUNTIF. Conversion can be implicit or explicit, or using case/iif constructs... whatever MariaDB supports.

If you already use a DB that supports events/notifications (Firebird, Interbase, Oracle, MSSQL...?), a FDEventAlerter (or similar) may be sufficent to notify clients (instead of polling).

https://docwiki.embarcadero.com/RADStudio/Sydney/en/Database_Alerts_(FireDAC)

Not exactly addressing the issue, but do you use firedac connection pooling?

https://docwiki.embarcadero.com/RADStudio/Sydney/en/Multithreading_(FireDAC)

May help or circumvalent your problem

Also try to use read-only transactions and "read committed" isolation mode whenever possible.

Also check the ibclient dll version.

For similar reasons, I use an ordinary form with a TfrxPreview component on it.

https://www.fast-report.com/documentation/ProgMan/index.html?creating_a_custom_preview_window.htm

Or you may try  TButtonGroup

https://docwiki.embarcadero.com/Libraries/Sydney/en/Vcl.ButtonGroup.TButtonGroup

Should be fixed in 11.2 (I haven't tested yet)

https://quality.embarcadero.com/browse/RSP-37631

I have encountered the "missing personality" from time to time too. A quick fix that works for me is:
In the IDE, open Tools - Manage platforms and hit Apply (without changing anything)

Close/open the IDE a then the project opens fine.

Hope it helps ...

Same error here, Visual Studio NOT installed.