SQLite error with version 5

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

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

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

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.