• Welcome to SQLitening Support Forum.
 

Database locked in local mode but not in remote mode

Started by Fim, December 17, 2019, 09:17:34 AM

Previous topic - Next topic

Fim

I am building a smaller ERP system with Powerbasic and SQLitening. It works as it should when I run in Remote mode. But when I run in Local mode I get "Database locked" every now and then. It does not appear to be a systematic error. Does anyone have a tip where to look for the error?
/Fim W.
Fim W

Fim

Your proposal did not affect the situation.
What I can see, a failed INSERT causes the database to be locked when I try with a REPLACE instead. It only applies in local mode. At the moment, I solve it by doing slClose immediately followed by a slOpen. in case of a failed INSERT.
I will return later with an example.
/ Fim W.
Fim W

Fim

lSetProcessMods "L0" No effect
I will return later with an example.
/ Fim W.
Fim W