SQL Lite Lock

2220

Member
Licensed User
First of all, I purchased B4P few weeks ago and I'm very happy with them. I'm still discovering the tricks.

I'd like to know how can I control the File Locking of SQL Lite. I got some error messages of 'Database is Locked' and I have no ideo how to fix it or to control it.


Thank you in advance,

Joan
 

Mr_Gee

Active Member
Licensed User
I had the same issue, I solved it by closing the connection before sending another cmd
B4X:
cmd.CommandText = "SELECT * FROM countries WHERE country = 'XYZ"
Reader.Value = cmd.ExecuteReader
Reader.Close
Make sure you use the Reader.Value before closing the Reader, otherwise you lose the value
 
Last edited:

agraham

Expert
Licensed User
They both seem to be native code libraries incorporating SQLite code and the encryption routines. They won't work with B4ppc as the B4ppc version of the SQLite library incorporates a managed wrapper because B4ppc is a .NET app.
I'm looking for an encryption tool for SQL Lite. It's a must for me.
If you are willing to roll your own look at my Crypto library http://www.basic4ppc.com/forum/additional-libraries/2220-cryptoex-library.html
 
Top