Hi, My system do have Memory : 2000 MB is it fine for sqlitie to start on with ?
Is their any disk size limitation for sqlite i.e.Incase do sqlite require a min of any n MB disk to make transactions ? BFOS:root> ./sqlite3 bhanu.db SQLite version 3.5.7 Enter ".help" for instructions sqlite> .databases seq name file --- --------------- ---------------------------------------------------------- 0 main /root/bhanu.db sqlite> CREATE TABLE t1(a INTEGER); SQL error: database or disk is full sqlite> Thanks /BP -----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.e. ./sqlite mydb.db3 when i attemt to execute any command i.e. create tables,insert etc i see the ERROR Message SQL error: SQL logic error or missing database. I think because of some library dependency this issue is being observed ...any pointers ?? Thanks /BP -----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 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". > > 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 exactly I am wrong ? > > > Thanks > /BP > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > Hi You have to create a database first. Create a table before a database is like build a window without house :) I am using sqlite3 on Ubuntu. $ sqlite3 mydb.db3 I am new in sqlite. Cmiiw. _______________________________________________ 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
