RE: [sqlite] select COUNT (DISTINCT column1, column2) from table?

Hi Phani! For your sample the following query will fit: select COUNT (DISTINCT year*12+month) FROM m If you take a look at EXPLAIN select COUNT (DISTINCT year*12+month) FROM m you will see that effectiveness is almost the same than in case of EXPLAIN select COUNT (DISTINCT year) FROM m and

RE: [sqlite] Sharing an in-memory database between applications

Hi Rob! Maybe standard windows feature memory-mapping-file can help you? Regards Xeepe Phone Solution Team http://en.xeepe.com -Original Message- From: Rob Richardson [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 7:35 PM To: sqlite-users@sqlite.org Subject: [sqlite] Sharing

RE: [sqlite] how to change SQLite column definition

AFAIK SQLite does not have such functionality. Please see http://sqlite.org/lang_altertable.html . So you have to do it in a bit more complicated way. Regards, Dennis Xeepe Phone Solution Team http://xeepe.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: