SQLite error with version 5

Discussion in 'Questions (Windows Mobile)' started by HARRY, May 20, 2007.

  1. HARRY

    HARRY Active Member Licensed User

    Erel,

    When I close a program a get a number of error messages, which I did not get with version 4:

    Sub Form1_Close
    If cPPC =true then
    Shell("\Programmabestanden\Screen_Orientation\Prtr0.exe")
    End if
    Con.Close
    End Sub

    First, in dutch, that an unexpected arror has occured, and an option to show the following detailed messages

    The detailed messages are:

    Camping Photos.exe
    Argument exception

    bij
    System.PInvoke.EE.Runtime_InteropServices_GCHandle_InternalGet()
    bij System.WeakReference.Get_isAlive()
    bij
    System.Data.SQLite.SQLiteConnection.ClearReferences()
    bij
    System.Data.SQlite.SQLiteConnection.RemoveCommand()
    bij
    System.Data.SQlite.SQLiteCommand.set_Connection()
    bij
    System.Data.SQlite.SQLiteCommand.Dispose()
    bij
    System.Data.SQlite.SQLiteCommand.Finalize()


    The error occurs only when I have updated the data base.

    The update command is:

    cmd.CommandText="UPDATE WPOILABEL_V1 SET PHOTO1 = '" &Text1& "' , PHOTO2 = '" &Text2& "', PHOTO3 = '" &Text3& "', Comment = '" &Text4& "' WHERE ID= '" &ActCampID& "' "

    number=Cmd.ExecuteNonQuery

    The update is correctly done.

    Initially I did I/O on the data base without Begin/Endtransaction. But it proved that it makes no difference.

    What can be wrong?

    Harry
     
  2. Erel

    Erel Administrator Staff Member Licensed User

    Try to remove Con.Close.
    It will be closed anyway.
     
  3. HARRY

    HARRY Active Member Licensed User

    Erel,

    Removing con.close didn't help. Some further information:

    The problem occurs on the PDA device only; on the desktop the program runs well.

    When I close the program there appears to be a number of messages, the number being equal to 2 * the number of updates done. Apparently, these messages are generated in the background when the program is running.

    Any idea?

    Harry
     
  4. Erel

    Erel Administrator Staff Member Licensed User

    I've did a small test on a device using the UPDATE method and everything worked fine.
    You could alter the SQL example and check it with the UPDATE method.
     
Loading...