Nope, how would i do that? Eric Pankoke wrote: > > 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] > ----------------------------------------------------------------------------- > > >
-- View this message in context: http://www.nabble.com/Saving-tables-tf2714011.html#a7567686 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
