Sign in to follow this  
Followers 0
59FIFTY

SQLite strange error

5 posts in this topic

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?!

Share this post


Link to post
Share on other sites



Simple script:

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

Dale


Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl

MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model

Automate input type=file (Related)

Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded  Better Better?

IE.au3 issues with Vista - Workarounds

SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead?

Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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


Free Internet Tools: DebugBar, AutoIt IE Builder, HTTP UDF, MODIV2, IE Developer Toolbar, IEDocMon, Fiddler, HTML Validator, WGet, curl

MSDN docs: InternetExplorer Object, Document Object, Overviews and Tutorials, DHTML Objects, DHTML Events, WinHttpRequest, XmlHttpRequest, Cross-Frame Scripting, Office object model

Automate input type=file (Related)

Alternative to _IECreateEmbedded? better: _IECreatePseudoEmbedded  Better Better?

IE.au3 issues with Vista - Workarounds

SciTe Debug mode - it's magic: #AutoIt3Wrapper_run_debug_mode=Y Doesn't work needs to be ripped out of the troubleshooting lexicon. It means that what you tried did not produce the results you expected. It begs the questions 1) what did you try?, 2) what did you expect? and 3) what happened instead?

Reproducer: a small (the smallest?) piece of stand-alone code that demonstrates your trouble

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0