Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-27 Thread Kees Nuyt
On Thu, 27 Mar 2008 03:10:33 -0700, you wrote: >Can I know where/HOW the Journal file is being written so that i can >check on my switch whether I have >sufficient write privileges enabled for journal file. Journal files are written in the same directory as the database file. The database

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread BanuPrakash G
yes i have write permissions ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Sent: Wednesday, March 26, 2008 7:55 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL error: SQL logic error or missing database do you have

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread BanuPrakash G
sage- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of BanuPrakash G Sent: Wednesday, March 26, 2008 12:19 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL error: SQL logic error or missing database Even create a database i.e. ./sqlite mydb.db3 when i attemt

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread Dennis Cote
BanuPrakash G wrote: > Database or disk is full is the Error message i get from the sqlite > > :root> ./sqlite3 mediadb.sql > SQLite version 3.5.7 > Enter ".help" for instructions > sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100)); > SQL error: database or disk is full > > sqlite>

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread Ken
root> -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of BanuPrakash G Sent: Wednesday, March 26, 2008 12:19 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL error: SQL logic error or missing database Even create a database i.

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread BanuPrakash G
Prakash G Sent: Wednesday, March 26, 2008 12:19 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL error: SQL logic error or missing database Even create a database i.e. ./sqlite mydb.db3 when i attemt to execute any command i.e. create tables,insert etc i see the ERROR Mes

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-26 Thread BanuPrakash G
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Prabowo Murti Sent: Tuesday, March 25, 2008 9:18 PM To: General Discussion of SQLite Database Subject: Re: [sqlite] SQL error: SQL logic error or missing database BanuPrakash G wrote: > Hi, > > I

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-25 Thread P Kishor
it successfull and when i use the db to > > create tables > > I see on the SQLITE shell the ERROR message as "SQL error: SQL logic > > error or missing database". > > > > i.e. > > > > ./sqlite3 > > SQLite version 3.5.7 > > Ent

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-25 Thread Prabowo Murti
ge as "SQL error: SQL logic > error or missing database". > > i.e. > > ./sqlite3 > SQLite version 3.5.7 > Enter ".help" for instructions > sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100)); > SQL error: SQL logic error or missing datab

Re: [sqlite] SQL error: SQL logic error or missing database

2008-03-25 Thread Ken
essage as "SQL error: SQL logic error or missing database". i.e. ./sqlite3 SQLite version 3.5.7 Enter ".help" for instructions sqlite> CREATE TABLE t1(a INTEGER, b INTEGER, c VARCHAR(100)); SQL error: SQL logic error or missing database Can anybody point me out where exac

[sqlite] SQL error: SQL logic error or missing database

2008-03-25 Thread BanuPrakash G
Hi, I have used the latest verision of sqlite i.e. sqlite-3.5.7 Amalgamation release for PPC Arch. I was able to cross compile it successfull and when i use the db to create tables I see on the SQLITE shell the ERROR message as "SQL error: SQL logic error or missing database&qu