I start sqlite3.exe from windows which opens up a command prompt. I create a table etc, fine. Now if I .exit or .quit I get no message...

I start sqlite3.exe from windows which opens up a command prompt. I create a table etc, fine. Now if I .exit or .quit I get no message asking what I want to call my database and no database is created. I have looked on .help and searched t'internet, but cannot find any save function (nor a load function). I am assuming that this basic? feature is missing (by design?) and I have to always use sqlite3.exe from the command line. If this is true, why? [I know I can use a 3rd party gui for creating new databases.] Regards Gordon Moore

[quote='Gatsu' pid='164' dateline=' ***-***-**** '] I dont get it, how do I "run the program like sqlite3 mydb.db" ? I'm using widows. [img]http://www.tibiatrader.com/2.jpg[/img] [/quote] The simple answer is that though sqlite3 can be instantiated (run) from windows it does not allow you to add the necessary file name. Neither does sqlite3 allow you to create or save a newly created database file from within its prompt (i.e. something like .save, .close, .open, does not exist). The only solution is that you run it from a Dos or command prompt. In win7 you can just right click (or shift right click) on the folder in the tree view of windows explorer and it has an option to open command prompt here. There is an addon somewhere on the web that allows XP to do the same, but I forget where. It would be nice for someone to extend sqlite3.exe to allow this functionality from windows. :) btw when you are in a command prompt with a huge path and the ">" you can shorten this to just ">" by typing blah\blah\blah\>prompt $g you can get your full path back by typing >prompt $p$g Oh the memories of MS-Dos :)