TDatabaseManager.Update issue w. FireDAC provider

BIZ TMS Aurelius
1

Hello,


I'm using Delphi Tokyo update 1 with latest Aurelius version.
I'm facing an error when calling TDatabaseManager.Update().

This is happening in Aurelius.Schema.SQLite.TSQLiteSchemaRetriever.GetForeignKeys method when calling Aurelius.Schema.AbstractImporter.TSchemaRetriever.Open('pragma foreign_key_list("Assures")')

I'm getting this exception :

Exception 'first chance' at $ 76B108B2. EFDException exception class with a message '[FireDAC] [Phys] [SQLite] -308. Unable to open / set the command, which results in not returning a result set. Tip: Use the Execute / ExecSQL method for commands other than SELECT '. Process Tournee.exe (7324)



2

I suppose that error is happening while you are debugging? Does that error happen when you run outside IDE (or in Release mode)? This error is a normal FireDac exception that is handled by FireDac itself and does not propagate to the application.

3

You were right. This exception was only happening while debugging !

Thank you.