On Apr 18, 2004, at 8:56 AM, Richard wrote:
I think, the problem is that, I did do that, sqlite test.db and did not get a correct reply...
Hence, wondering if I'm did right..
Inside the SQLITE folder, is the following: libsqlite.a sqlite sqlite readme.pdf sqlite.h
I been clicking on ssqlite, which is the a unix exe file. and it brings up a terminal window with sqlite, running...
sqlite> # this is the prompt I see, now what do I enter in?
you are saying you did type > sqlite test.db
but then you go on to say that you "clicked" on ssqlite (sic)... I am assuming you mean you clicked on sqlite (the unix binary... there is no concept of exe file in unix... a binary could be an "exe" file).
So, which one of the above did you do?
The act of clicking on sqlite would be equivalent to typing > sqlite
without any database specified. That won't work.
Do as Yves suggests below. It will work. You have to specify the database when launching sqlite. Once you specify the database (it will be created if it doesn't already exist), then you can create your tables and whatnot.
On Apr 18, 2004, at 3:59 AM, Yves Glodt wrote:
A new database is created when u call sqlite.exe with a filename as parameter. Of course only if this file does not yet exist... e.g.:
~$ sqlite test.db SQLite version 2.8.13 Enter ".help" for instructions sqlite> create table testtable ( ...> id integer, ...> name varchar(64) ...> ); sqlite> insert into testtable values (1,'Joe'); sqlite> select * from testtable; 1|Joe sqlite>.q ~$
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
