SQLite strange error

[59FIFTY]

Simple script:

$oDB = ObjCreate("LiteX.LiteConnection")
$oDB.Open("mydb.db")
$oDB.Prepare("SELECT * FROM mytable")
$oDB.Close()

generates the error message: The requested action with this object has failed.

It worked half an hour ago, but now it doesn't?!

[DaleHohm]

Simple script:

$oDB = ObjCreate("LiteX.LiteConnection")
$oDB.Open("mydb.db")
$oDB.Prepare("SELECT * FROM mytable")
$oDB.Close()

Dale

[59FIFTY]

It is an Opbject and if I delete the DB it get's created each time I run the script. The Prepare fails and I don't know why, this script is so simple, but it won't work.

[DaleHohm]

It is an Opbject and if I delete the DB it get's created each time I run the script. The Prepare fails and I don't know why, this script is so simple, but it won't work.

You need more information about the error. I have not studied the SQLLite UDF, so I am not the best to help here, but this will help gather more info. I realize that you are not using IE in any way, but these first two lines will enable a COM error handler that will display more information to the SciTe console. Please run this in SciTe and post the _FULL_ console output generated:

#include <IE.au3>
_IEErrorHandlerRegister()

$oDB = ObjCreate("LiteX.LiteConnection")
If Not isObj($oDB) Then ConsoleWrite("Object creation error..." & @CR)
$oDB.Open("mydb.db")
$oDB.Prepare("SELECT * FROM mytable")
$oDB.Close()

Dale

[59FIFTY]

I got the problem now, it's because of SQLite Administrator, I don't know why, but I've a manipulate the database with SQLite Administrator the database file get's corruptet, that's why I get this error message, thanks for the help!