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

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Edson
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
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

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

Radovan Antloga-2
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
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|

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

Radovan Antloga
In reply to this post by Edson
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
> [hidden email]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users