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

2012-07-30 Thread
? ___ -- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users End of sqlite-users Digest, Vol 55, Issue 29 -- 黃楨民

[sqlite] Thanks to Igor Tandetnik for providing help.

2012-07-30 Thread
? ___ -- ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users End of sqlite-users Digest, Vol 55, Issue 29 -- 黃楨民

[sqlite] Could anyone recommend books for SQLite

2012-07-28 Thread
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?

2012-07-28 Thread
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

[sqlite] How to get schema from attached database ?

2012-02-25 Thread
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] Help me about sqlite3_open(),please!

2012-02-23 Thread
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] Is there way to modify table structure after initial definition ?

2012-02-20 Thread
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] 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