Hello scoobyjh,
Don't you want
sqlite3_exec("VACUUM;")
instead of
sqlite3_exec("VACUUM") //maybe got error
?
I use vacuum from the Sqlite3.exe and it works with the semi-colon.
C
Tuesday, July 24, 2007, 7:22:33 AM, you wrote:
s> With OS_UNIX version 3.4.0 (AMALGAMATION), I do the following:
s> a) open a database file, it contains one table with 3 records in it.
s> b) insert 9997 records in side a begin/end transaction
s> c) delete 9997 records
s> d) vacuum the database
s> e) close the database file
s> Whether I use VACUUM on it's own or VACUUM table-name, I get this error:
s> SQL error: SQL logic error or missing database
s> I have no views and I havn't changed the schema.
s> Any ideas?
s> Preston Zaugg wrote:
>>
>> Incase anybody runs into this in the future... I found the cause of this
>> problem... I had a view that was pointing to a column of the table that no
>> longer exsists. As soon as i dropped the view i was able to vacuum the
>> database without error.
>>
>> --Preston
>> ----- Original Message -----
>> From: "Preston Zaugg" <[EMAIL PROTECTED]>
>> To: <sqlite-users@sqlite.org>
>> Sent: Tuesday, October 04, 2005 10:58 AM
>> Subject: RE: [sqlite] SQL logic error when running vacuum;
>>
>>
>>> Well, based on your comment i tried a vacuum from the API and i still get
>>> the error.
>>>
>>> ----Original Message Follows----
>>> From: "Cariotoglou Mike" <[EMAIL PROTECTED]>
>>> Reply-To: sqlite-users@sqlite.org
>>> To: <sqlite-users@sqlite.org>
>>> Subject: RE: [sqlite] SQL logic error when running vacuum;
>>> Date: Tue, 4 Oct 2005 18:46:27 +0300
>>>
>>> as a matter of fact, I have also noticed that using the vaccum command
>>> from the command-line interface does bring this error up sometimes.
>>> however, since I use the graphical UI most of the time (being its
>>> author:) I don't use the command line interface that much.
>>> I suspect it has nothing to do with the engine itself, rather with the
>>> command-line tool.
>>>
>>> > -----Original Message-----
>>> > From: Preston Zaugg [mailto:[EMAIL PROTECTED]
>>> > Sent: Tuesday, October 04, 2005 6:35 PM
>>> > To: sqlite-users@sqlite.org
>>> > Subject: [sqlite] SQL logic error when running vacuum;
>>> >
>>> > I have a database (encrypted w/ encryption extensions from
>>> > drh). After run a sql file on this database it gives the
>>> > error "SQL error: SQL logic error or missing database" after
>>> > running a vacuum. it also seems to give this error
>>> > sporadically on other statements.
>>> >
>>> > the sql file that i run does the following:
>>> > drops a table
>>> > creates a new table (same name different structure from the
>>> > the table that was just dropped) adds a unique constraint
>>> > runs 7000+ insert statements
>>> >
>>> > the file is executed using the .read of the command line
>>> > utility, and runs without error/warning.
>>> >
>>> > As a side note i am able to run this same script against a MS
>>> > SQL Server database without error.
>>> >
>>> > Between the fact that i can run this script on sql server and
>>> > don't get any errors on the .read, makes me think that my
>>> > script is valid/well formed.
>>> >
>>> > Oh.. other important stuff... i was on 3.2.2 when i started
>>> > running into this problem. Upgraded to 3.2.7 with the same
>>> > results. I'm on Windows 2003 and using a local database.
>>> >
>>> > Any suggestions?
>>> > --Preston
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>>
>>>
>>
>>
--
Best regards,
Teg mailto:[EMAIL PROTECTED]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
