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

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

[sqlite] Is there way to modify table structure after initial definition ?

Dear all: Forgive for asking such stupid question. I use Xbase way to understand SQLite. It is allowed to modify dat type of column in clipper. In my personal thoughts, Creating a brandnew table and copy those data from older version might be an alternative way. Is there any instrument to

[sqlite] Help me about sqlite3_open(),please!

Dear all: 1. Will SQLite run sqlite3_open_v2 if I call sqlite3_open with 4 arguments ? I mean, Did SQLite pick up the interface depends on number of parameter ? 2. How to assign flag parameter in sqlite3_open_v2() with combination of

[sqlite] How to get schema from attached database ?

Dear all: I run sqlite3 In windows shell command environment and make a connection to database in thw way like 『>sqlite3 dbone.sq3』. Then, attach database 'dbtwo.sq3' as dbtwo. How could I get schema of detwo under windows shell command ? Please help! Best Regards tom

[sqlite] Could anyone recommend books for SQLite

Dear all I am looking for a book ,which include all instructures and functions of SQLite. It is like reference guide. Could any help? your sincerely tom ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] How to query data in table more than 2?

Dear all: I would like to query customer from from ooder table and only customer order more than twice. Which clause or filter should I use to filter those customer order more than twice ? Please help Best regards tom ___ sqlite-users mailing list

Re: [sqlite] Thanks to Peter Aronson for providing help!

Dear Peter: "Using SQLite" is on my listing to purchase. It is really helpful for me to understand futher in SQLite. Thank you again. Best Regards Tom 2012/7/30 > Send sqlite-users mailing list submissions to > sqlite-users@sqlite.org > > To

[sqlite] Thanks to Igor Tandetnik for providing help.

Dear Igor Tandetnik Thank you for teaching me how to query data duplicatee more than 2 from table. It is really helpful to me. Best Regards tom 2012/7/30 > Send sqlite-users mailing list submissions to > sqlite-users@sqlite.org > > To subscribe or