weirdo12

Do you use GuessFormat() prior to doing the TFDBatchMove.Execute?

Of course, if you'll never need to support a client/server installation it makes no sense.

Agreed. That said, there are developers in the space we work in (in fact most of them) that include SQL Server Express as default database for a small single-user app. That or Access. If you have not worked with PostgreSQL you should check it out.

It might not have been clear in the original post that SQLite is our default database (and it has been since 2021). Using FireDAC, the same install supports SQLite, PostgreSQL, SQL Server, SQL Anywhere and MySQL,

This guy is also pretty high on SQLite:

Okay, then let's go with that description if stand alone isn't clear enough.

I add a new form and drop the components on that and then just delete that form from the project.

Did you create a new project for version 12.2 or did you just open the one you used with the earlier version? Yeah, try creating a new project.

I can confirm that FireDAC and the 32-bit version 10 libpq.dll works fine with the supported 64-bit versions of PostgreSQL (12-16) including those running on Linux, FreeBSD and Azure. I can't help you with the TLS and reverse proxy stuff 😉

I know we are just lucky to be able to use C++ when building apps using the super powers of the VCL but it's so nice to have C++ specific stuff like Visual Assist added to the product!

I know DevExpress is hoping to deliver their components 'ready to go' for the new C++Builder tool chain. https://community.devexpress.com/blogs/vcl/archive/2024/07/24/vcl-year-end-roadmap-v24-2.aspx

When you store the correct data using pgAdmin4, what do you see if you do a SELECT on the table from FireDAC?

What is the value of your TFDConnection CharacterSet parameter? https://docwiki.embarcadero.com/RADStudio/Athens/en/Connect_to_PostgreSQL_(FireDAC)

I realize a solution was found, but disabling the ListView when the user changes the contents of the Memo would ensure users remember to save or discard changes.

The FireDAC docs say it's a driver issue. Is your application 32-bit or 64-bit?

Do you have another tool installed on the new laptop that you can successfully use to connect to and view the data in the .accdb file?

A TFDEventAlerter creates it's own new connection when you set the Connection property. So yes, you need to keep track of the TFDEventAlerter objects you create and disable them if the connection is lost. I found it necessary to set Active to false and clear the Connection property. https://docwiki.embarcadero.com/Libraries/Athens/en/FireDAC.Comp.Client.TFDCustomEventAlerter.Connection

Wow. That's looks like a great tool to help new Delphi developers get started.

In the direction Remy suggested, maybe TFDConnection,Connected = true in the IDE.

What database are you using? Show us the code you are using that is not working as expected along with an explanation of what you think should be happening.

The warning is caused by having #include "Label.h" *before* the USEFORM. #include "Label.h" ... USEFORM("Label.cpp", fmLabelView); Try this: USEFORM("Label.cpp", fmLabelView); ... #include "Label.h"

Thanks for the update.

If you want to be as flexible/portable as possible you could consider using a FireDAC macro like this: email = { fn IFNULL(:EMAIL, email) }

😄 So just supply the current value when the value doesn't change. I do like the statement that uses COALESCE because it makes it very obvious that that is what is happening. Are you targeting a specific database server?

They are retooling the C++ compiler chain. I get the impression that C++ is becoming more important - not less - even if it might seem like a 2 steps forward, one step back (for the moment). My gut feeling is the future has never been brighter for C++Builder.