SQL Lite Lock

[2220]

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]

I had the same issue, I solved it by closing the connection before sending another cmd

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

 

[2220]

Thank you very much. I'll check all the code.

By the way have anybody tested the Transparent AES Encryption for SQLite DLL with B4P? Or the MapESoft- GIS component with source code


I'm looking for an encryption tool for SQL Lite. It's a must for me.

 

[agraham]

By the way have anybody tested the Transparent AES Encryption for SQLite DLL with B4P? Or the MapESoft- GIS component with source code

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.b4x.com/forum/additional-libraries/2220-cryptoex-library.html

 

[2220]

I'll try Agraham.
Thank you.