Save yourself some time and show some code, it will make it easy for us to help you.
Genius might have limitations, but stupidity is no handicap -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of kritesh tripathi Sent: Tuesday, October 23, 2012 10:32 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] Getting Error SQLITE_NOTADB hi michael thanks for the responnse bt still getting the same problem language-C++ RTOS-micro itron where-creating db in digital camera external sd card and afterwards usin this db file for some wifi feature present in digital camera so that user can see all those images in tv or mobile. after debug i find tht in tht if condition using memcmp which compares between page1 and zmagicheader....bt value of page1=" " is this a problem ? cheers kritesh On Oct 24, 2012 3:57 AM, "Black, Michael (IS)" <michael.bla...@ngc.com> wrote: > OK...here it is again using an update....still works for me. Does it > work for you? > run it like this...first run with no args creates the table simple > simple 1 2 simple 2 3 > > The args just update from/to values so you can see them changing using > and update/where clause. > > #1 What OS? > #2 What language > #3 Where's your code? > > #include <stdio.h> > #include "sqlite3.h" > > int main(int argc, char *argv[]) > { > sqlite3 *db; > int rc; > rc=sqlite3_open("test.db",&db); > if (rc != SQLITE_OK) { > puts(sqlite3_errmsg(db)); > } > if (argc == 1) { > sqlite3_exec(db,"create table t (i > integer);",NULL,NULL,NULL); > rc=sqlite3_exec(db,"insert into t > values(1);",NULL,NULL,NULL); > } > else { > char sql[4096]; > if (argc != 3) { > printf("Need 2 args, old/new values\n"); > exit(1); > } > sprintf(sql,"update t set i=%s where > i=%s",argv[2],argv[1]); > rc=sqlite3_exec(db,sql,NULL,NULL,NULL); > } > > if (rc != SQLITE_OK) { > puts(sqlite3_errmsg(db)); > } > sqlite3_close(db); > return 0; > } > > Michael D. Black > Senior Scientist > Advanced Analytics Directorate > Advanced GEOINT Solutions Operating Unit Northrop Grumman Information > Systems > > ________________________________________ > From: sqlite-users-boun...@sqlite.org > [sqlite-users-boun...@sqlite.org] on behalf of kritesh tripathi > [tripathi.krit...@gmail.com] > Sent: Tuesday, October 23, 2012 1:44 PM > To: General Discussion of SQLite Database > Subject: EXT :Re: [sqlite] Getting Error SQLITE_NOTADB > > hi michale > > there is no problem in creating and inserting the records in table > ...but after tht i am trying to update the coloum value of table and > using update command with where clause ..here every time sqlite_exec > command failing and rc returns in sqlite3_prepare such as > SQLITE_NOTADB > > CHEERS > KRITESH > On Oct 24, 2012 2:10 AM, "Black, Michael (IS)" > <michael.bla...@ngc.com> > wrote: > > > 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: sqlite-users-boun...@sqlite.org > > [sqlite-users-boun...@sqlite.org] on behalf of kritesh tripathi > > [tripathi.krit...@gmail.com] > > Sent: Tuesday, October 23, 2012 11:58 AM > > To: sqlite-users@sqlite.org > > 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 > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
