Problem with SQLite...

[sshrum]

SQLite v 3.8.8.3

AutoIT v 3.3.12.0

SQL statement is:

Update Metadata set AcquisitionTime="2009/04/23 16:14:23" where SourceURL="M:\1\1 Giant Leap-My Culture.mp3";

 

Getting @error = 2 and 21 as the result from _SQLite_Exec()

If I set _SQLite_SafeMode(False), I get a out of memory error on _SQL_Exec().

 

Sending this line via SQLite Admin (using SQLite v 3.8.8.3) works fine.

 

Databases are fine as I pull data from them prior to doing the UPDATE sql and load them into arrays.

 

I also can't seem to find where the SQLite constants are as referred to in the Help file under _SQLite_Exec - Return Value - Failure.

 

TIA

Edited March 10, 2015 by sshrum

[sshrum]

I'm assuming that the error constants are from here: https://www.sqlite.org/rescode.html

error 21 = SQLITE_MISUSE

Any ideas what's happening?

Edited March 10, 2015 by sshrum

[jchd]

Hard to tell without seeing code!

$SQLITE_* constants are all declared at the top of the sqlite.au3 include file and yes they match error codes of SQLite. Not doing so would be terribly troublesome.

[sshrum]

I've skirted the issue by loading up the results in arrays and then writing it out to a new database file.  Not really what I was hoping for but it works and I only need to do it the one time.