Re: [sqlite] make connection to another database within sqlite3 shell command

2012-02-17 Thread Stephan Beal
On Fri, Feb 17, 2012 at 2:46 AM, 黃楨民 wrote: > 1. Should I close database before opening another ? how? > 2. How to open another database? > You need to exit the program (with the ".quit" command) and the run it again with your second database. Or you can use the ATTACH command to connect multipl

[sqlite] make connection to another database within sqlite3 shell command

2012-02-16 Thread 黃楨民
Dear Sir: I am new from Xbase to SQL family nad have to make confustion clear. ran "sqlite3.exe a.db3" within windows shell command and manuplate those tables it contains. my questions are: 1. Should I close database before opening another ? how? 2. How to open another database? I had been tryi