[sqlite] [FireDAC][Phys][SQLite]-326. Cannot perform the action, because the previous action is in progress.

Hi everyone! I am using SQLite, with Delphi XE Rio and Firedac and I don't know why, a cited error message appeared. I've tried everything to unlock the database: I renamed the .db file, changed the folder file, turned off the notebook, etc., but I can't unlock the .db database. The error occ

[sqlite] [FireDAC][Phys][SQLite]-326. Cannot perform the action, because the previous action is in progress.

Hi everyone! I am using SQLite, with Delphi XE Rio and Firedac and I don't know why, a cited error message appeared. I've tried everything to unlock the database: I renamed the .db file, changed the folder file, turned off the notebook, etc., but I can't unlock the .db database. The error occ

[sqlite] Incorrect result when using WHERE with with correlated sub-select query

), MbC AS ( SELECT Country, MAX(spent) spent FROM GbC GROUP BY 1) SELECT outerr.* FROM GbC outerr WHERE outerr.spent = (SELECT spent FROM MbC WHERE Country = outerr.Country) ORDER BY 1, 3 DESC -- Edson Poderoso ___ sqlite-users mailing list sqlite-users