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
