SQLitening Support Forum

SQLitening Support => You've got Questions? We've got Answers! => Topic started by: Fim on December 17, 2019, 09:17:34 am

Title: Database locked in local mode but not in remote mode
Post by: Fim on December 17, 2019, 09:17:34 am
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.
Title: Re: Database locked in local mode but not in remote mode
Post by: Fim on December 20, 2019, 05:46:15 am
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.
Title: Re: Database locked in local mode but not in remote mode
Post by: Fim on December 21, 2019, 04:41:06 am
lSetProcessMods "L0" No effect
I will return later with an example.
/ Fim W.