Re: [sqlite] Tables dropped (mac)

2008-03-21 Thread Griggs, Donald
=== Re: Maybe I left off the .db? Sqlite doesn't enforce filename restrictions -- you can name the file simply "test" if you prefer. Re: Am I right that you can only have one database file per sqlite installation? I'm not certain I understand

Re: [sqlite] Tables dropped (mac)

2008-03-21 Thread Janis Rough
Well I missed that in the doucmentation, thanks. I just re-read it. Although at the prompt I thought I did put test as the filename. Maybe I left off the .db? So this should be to get the prompt and save the fiel. sqlite3 test.db > Am I right that you can only have one database file per sqlite

Re: [sqlite] Tables dropped (mac)

2008-03-21 Thread John Stanton
What was your filename? Janis Rough wrote: > I created some tables at the sqlite prompt using the terminal window on a > Mac. I checked with .tables and .schema and they were created and I > inserted data. I closed the terminal window and went back later. At the > sqlite prompt there were no

Re: [sqlite] Tables dropped (mac)

2008-03-21 Thread Griggs, Donald
Regarding: I created some tables at the sqlite prompt using the terminal window on a Mac. I checked with .tables and .schema and they were created and I inserted data. I closed the terminal window and went back later. At the sqlite prompt there were no tables. I tried .tables and

[sqlite] Tables dropped (mac)

2008-03-21 Thread Janis Rough
I created some tables at the sqlite prompt using the terminal window on a Mac. I checked with .tables and .schema and they were created and I inserted data. I closed the terminal window and went back later. At the sqlite prompt there were no tables. I tried .tables and .schema and nothing. So