Re: [sqlite] [FireDAC][Phys][SQLite]-326. Cannot perform the action, because the previous action is in progress.
This is FireDAC error message not SQLite specific. I cannot reproduce it when using default FireDAC settings. But I think you must check Database ResourceOptions CmdExecMode. Change to am_NonBlocking. But I do not have to change that by default. Regards Radovan On 25.11.2019 18:34, Edson wrote: 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 occurs when trying to open the query a second time, for example: 1) first execution - OK qry.active: = False; qry.SQL.Clear; qry.SQL.Add ('DELETE FROM TAB_USERS'); qry.ExecSQL; 2) second execution - ERROR qry.active: = False; qry.SQL.Clear; qry.SQL.Add ('INSERT INTO TAB_USERS ... ... ...'); qry.ExecSQL; The error is fired at the line "qry.SQL.Clear;" I don't know what else to do ... Does anyone have any tips? Thankful! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[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 occurs when trying to open the query a second time, for example: 1) first execution - OK qry.active: = False; qry.SQL.Clear; qry.SQL.Add ('DELETE FROM TAB_USERS'); qry.ExecSQL; 2) second execution - ERROR qry.active: = False; qry.SQL.Clear; qry.SQL.Add ('INSERT INTO TAB_USERS ... ... ...'); qry.ExecSQL; The error is fired at the line "qry.SQL.Clear;" I don't know what else to do ... Does anyone have any tips? Thankful! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [FireDAC][Phys][SQLite]-326. Cannot perform the action, because the previous action is in progress.
This is FireDAC error message not SQLite specific. I cannot reproduce it when using default FireDAC settings. But I think you must check Database ResourceOptions CmdExecMode. Change to am_NonBlocking. But I do not have to change that by default. Regards Radovan On 25.11.2019 18:34, Edson wrote: 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 occurs when trying to open the query a second time, for example: 1) first execution - OK qry.active: = False; qry.SQL.Clear; qry.SQL.Add ('DELETE FROM TAB_USERS'); qry.ExecSQL; 2) second execution - ERROR qry.active: = False; qry.SQL.Clear; qry.SQL.Add ('INSERT INTO TAB_USERS ... ... ...'); qry.ExecSQL; The error is fired at the line "qry.SQL.Clear;" I don't know what else to do ... Does anyone have any tips? Thankful! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[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 occurs when trying to open the query a second time, for example: 1) first execution - OK qry.active: = False; qry.SQL.Clear; qry.SQL.Add ('DELETE FROM TAB_USERS'); qry.ExecSQL; 2) second execution - ERROR qry.active: = False; qry.SQL.Clear; qry.SQL.Add ('INSERT INTO TAB_USERS ... ... ...'); qry.ExecSQL; The error is fired at the line "qry.SQL.Clear;" I don't know what else to do ... Does anyone have any tips? Thankful! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users