I assume you have some program doing the sqlite_exec?
Care to show us your code?
I just ran a test doing what you describe with SQLite Database Browser Version
2.0b1 and the following program compiled against 3.7.13;
After the 2nd run of this program there are 2 records in test.db which the
browser shows....no errors occur.
#include <stdio.h>
#include "sqlite3.h"
int main()
{
sqlite3 *db;
int rc;
rc=sqlite3_open("test.db",&db);
if (rc != SQLITE_OK) {
puts(sqlite3_errmsg(db));
}
sqlite3_exec(db,"create table t (i integer);",NULL,NULL,NULL);
rc=sqlite3_exec(db,"insert into t values(1);",NULL,NULL,NULL);
if (rc != SQLITE_OK) {
puts(sqlite3_errmsg(db));
}
sqlite3_close(db);
}
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
________________________________________
From: [email protected] [[email protected]] on
behalf of kritesh tripathi [[email protected]]
Sent: Tuesday, October 23, 2012 11:58 AM
To: [email protected]
Subject: EXT :[sqlite] Getting Error SQLITE_NOTADB
Hi
I am using Sqlite for my project and getting Error like -SQLITE_NOTADB
whenever i am trying
below scenario-
1- Open and create the database
2- Execute Sqlite_Exec to Insert the record in the database table
3- Close the database
4- Confirm by opening the .db file in sqlite browser tht dtabase table
insert the records
5- Again Open the the database
6- Whenever Executing Sqlite_Exec to Update the colum value of database
table .
.Getting the Errror in Sqlite3_Prepare()--->lockBtree(BtShared *pBt)-->
if( memcmp(page1, zMagicHeader, 16)!=0 ){
goto page1_init_failed;
Everytimes above if condition True hence page1_init_failed and returns
rc = SQLITE_NOTADB;
Anybody have any idea what would be the reason if db table is creating
properly then why does failing in this condition .
Cheers
kritesh
I am getting Error
lockBtree
--
Regards
kritesh tripathi
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
