SQL Lite Lock

Discussion in 'Questions (Windows Mobile)' started by 2220, Sep 2, 2008.

  1. 2220

    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
     
  2. Mr_Gee

    Mr_Gee Active Member Licensed User

    I had the same issue, I solved it by closing the connection before sending another cmd
    Code:
    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: Sep 2, 2008
  3. 2220

    2220 Member Licensed User

    Last edited: Sep 2, 2008
  4. agraham

    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.
    If you are willing to roll your own look at my Crypto library http://www.basic4ppc.com/forum/additional-libraries/2220-cryptoex-library.html
     
  5. 2220

    2220 Member Licensed User

    I'll try Agraham.
    Thank you.
     
Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice