Xailer & OZ Software

Hello Xailers,

Is there any way to know how many active connections the database have?

TIA,
Juliano

Juliano,

I don't know any way to get it.

However, if you think that your app is going to be used by several users at once, I suggest you to jump to MariaDB. SQLite and MariaDB (or MySQL) are very close in terms of SQL dialect, and it's very easy to replace one by the other. Moreover, it's really easy to support both DB engines in any app. Almost all my programs support both engines, and I select one of them just when I install it in the customer computer.

Thanks José!

But I was needing this exactly to allow just one connection to the database at a time... We will try to figure some way to do it then, thanks!

Regards,
Juliano

Try with oDS:Execute( "PRAGMA main.locking_mode=EXCLUSIVE;" )

Regards,

Juliano,

the solution proposed by Ignacio is explained here: https://www.sqlite.org/pragma.html#pragma_locking_mode