[sqlite] How to truncate table?

2005-07-19 Thread chan wilson
Hi, In MS SQL, there is a "TRUNCATE TABLE" SQL that will remove all the records of a table and make the identity back to zero. Is there any means to accomplish it in sqlite? Thanks! _ 与世界各地的朋友进行交流,免费下载 MSN Messenger:

Re: [sqlite] How to truncate table?

2005-07-19 Thread chan wilson
How to truncate table? Date: Wed, 20 Jul 2005 00:29:27 -0500 On Jul 19, 2005, at 11:50 PM, chan wilson wrote: Hi, In MS SQL, there is a "TRUNCATE TABLE" SQL that will remove all the records of a table and make the identity back to zero. Is there any means to accomplish it in sq

Re: [sqlite] How to truncate table?

2005-07-19 Thread chan wilson
-users@sqlite.org Subject: Re: [sqlite] How to truncate table? Date: Wed, 20 Jul 2005 00:40:33 -0500 On Jul 20, 2005, at 12:33 AM, chan wilson wrote: Hi Puneet Kishor , Yes, you are right. I have to check out whether "DELETE FROM table;" will really set the auto imcrement primary key

[sqlite] how to customize the returned field name by PRAGMA

2005-08-05 Thread chan wilson
Hi, I am using "PRAGMA table_info(table-name);" to the the schema info of a table, but I could not customize the returned field name, such as: I wish "cid" to be ColumnID. normally we do by this: "SELECT cid AS ColumnID FROM (table-name);" but now I could not. is there anyway work

[sqlite] It there a roadmap?

2005-03-17 Thread chan wilson
Hi, I was wondering there is a roadmap of SQLite since many users are concerning what will the upcoming SQLite look like. :) _ 与世界各地的朋友进行交流,免费下载 MSN Messenger: http://messenger.msn.com/cn

[sqlite] SQLite Download Page dead link

2005-03-21 Thread chan wilson
The following link is dead! http://www.sqlite.org/sqlite3-3.2.0.bin.gz sqlite3-3.2.0.bin.gz (201503 bytes) A statically linked command-line program for accessing and modifing SQLite databases. See the documentation for additional information.

[sqlite] ALTER TABLE DROP/RENAME COLUMN?

2005-03-21 Thread chan wilson
Well, please allow me to congratulate to the release of 3.2.0 and many thanks to you guys! I was wondering whether it might be ALTER TABLE DROP/RENAME COLUMN in next release? _ 与世界各地的朋友进行交流,免费下载 MSN Messenger:

[sqlite] Pressure test and see the actual performance (phase I)

2005-03-24 Thread chan wilson
Hi All, I used the http://sourceforge.net/projects/adodotnetsqlite to do the pressure test and see the actual performance on my PC: PIV 3.0, 1G RAM, win2003 server(Simplifed Chinese)+vs.net2003, with unicode characters: I slightly modified the official test: the first field content and row

[sqlite] Pressure test of SQLite with ado.net wrapper(phase II)

2005-03-25 Thread chan wilson
Hi All, Please refer to phase I first. I used the http://sourceforge.net/projects/adodotnetsqlite to do the pressure test and see the actual performance on my PC: PIV 3.0, 1G RAM, win2003 server(Simplifed Chinese)+vs.net2003, with unicode characters: I slightly modified the official test:

[sqlite] failed to work when running in non-ASCII directory?

2005-04-11 Thread chan wilson
Hi, I found this problem a long time ago, but cannot figure out why: Everytime I put sqlite(no matter sqlite3.exe/sqlite3.dll/ other wrappers like sqlitedb.dll/ litex dll ) in a directory that contains non-ASCII characters, it failed to construct a connection. But it works well in those