liigo wrote:
>
> VACUUM got error...
>
> sqlite3_open(...)
> sqlite3_exec("VACUUM") //maybe got error
> sqlite3_close(...)
>
> If my database has a table that created before sqlite3_open(),
> I got the errcode=1, errmsg="SQL logic error or missing the database"
>
>
>
I also get this error, whether I supply a table name or not.
I am using SQLite version: 3.4.0 (AMALGAMATION) and built it with OS_UNIX
and SQLITE_OMIT_LOAD_EXTENSION defined:
char *fileName = "/home/databases/sqlite/sqlite_sample.db";
sqlite3 *db = NULL;
char *zErrMsg = 0;
int error;
error = sqlite3_open( fileName, &db );
if( error )
{
fprintf(stderr, "Can't open database %s: %s\n", fileName,
sqlite3_errmsg( db ));
exit( 1 );
}
error = sqlite3_exec( db, "VACUUM", callbackFunc, 0, &zErrMsg );
if( error != SQLITE_OK )
{
fprintf(stderr, "SQL error: %s\n", zErrMsg);
sqlite3_free( zErrMsg );
closeDatabase();
exit( 1 );
}
error = sqlite3_close( db );
if( error != SQLITE_OK )
{
fprintf(stderr, "Can't close database handle :%P %s\n", db,
sqlite3_errmsg(db));
exit( 1 );
}
db = NULL;
Has anybody got any comments on this?
--
View this message in context:
http://www.nabble.com/Can%27t-run-VACUUM-command%21-tf30544.html#a11760892
Sent from the SQLite mailing list archive at Nabble.com.
