Did you open the database when you launched SQLite again? Sorry if this is a stupid question, but I've never used SQLite from a command line or the shell.
-- Eric Pankoke Founder / Lead Developer Point Of Light Software http://www.polsoftware.com/ -------------- Original message ---------------------- From: sebcity <[EMAIL PROTECTED]> > > I created a table. > I populated the table. > I exited SQLite. > Started SQLIte again. > Typed "select * from <table name>". > ANd it tells me no such table exists?? > > > > Igor Tandetnik wrote: > > > > sebcity <[EMAIL PROTECTED]> wrote: > >> Im new to SQLite, After you create your tables how do you save them > >> so they are permenently there? It might be a dumb question but i cant > >> find the answer anwhere?! > > > > They are "permanently there" from the very moment you create them. All > > changes are written to the database file when a transaction is > > committed, or at the end of every statement if you don't open any > > transactions explicitly. > > > > Igor Tandetnik > > > > > > ----------------------------------------------------------------------------- > > To unsubscribe, send email to [EMAIL PROTECTED] > > ----------------------------------------------------------------------------- > > > > > > > > -- > View this message in context: > http://www.nabble.com/Saving-tables-tf2714011.html#a7567183 > Sent from the SQLite mailing list archive at Nabble.com. > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
