[sqlite] Getting Error SQLITE_NOTADB

2012-10-23 Thread kritesh tripathi
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


Re: [sqlite] Getting Error SQLITE_NOTADB

2012-10-23 Thread Black, Michael (IS)
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 showsno 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


Re: [sqlite] Getting Error SQLITE_NOTADB

2012-10-23 Thread Simon Slavin

On 23 Oct 2012, at 5:58pm, kritesh tripathi tripathi.krit...@gmail.com wrote:

 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;


Try it without step 4.  Do you still have the problem ?

Try it with steps 3, 4, or 5.  Do you still have the problem ?

What SQL command results in the SQLITE_NOTADB ?

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Getting Error SQLITE_NOTADB

2012-10-23 Thread kritesh tripathi
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 showsno 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


Re: [sqlite] Getting Error SQLITE_NOTADB

2012-10-23 Thread kritesh tripathi
hi simon

i am not using step 4 in my program...after step 1 to 3 ,db file create in
external sd card .
then i am trying to update the colum value of table using upadte command
with where clause but its failing due to below if condition as i mentioned
in the sqlite3_prepare--lockBtree

if(memcmp...)
page1_init fail

cheers
kritesh
On Oct 24, 2012 2:12 AM, Simon Slavin slav...@bigfraud.org wrote:


 On 23 Oct 2012, at 5:58pm, kritesh tripathi tripathi.krit...@gmail.com
 wrote:

  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;


 Try it without step 4.  Do you still have the problem ?

 Try it with steps 3, 4, or 5.  Do you still have the problem ?

 What SQL command results in the SQLITE_NOTADB ?

 Simon.
 ___
 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


Re: [sqlite] Getting Error SQLITE_NOTADB

2012-10-23 Thread Black, Michael (IS)
OK...here it is again using an updatestill 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 showsno 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


Re: [sqlite] Getting Error SQLITE_NOTADB

2012-10-23 Thread kritesh tripathi
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 zmagicheaderbt 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 updatestill 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 showsno 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

Re: [sqlite] Getting Error SQLITE_NOTADB

2012-10-23 Thread Arbol One
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 zmagicheaderbt 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 updatestill 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 showsno 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