Re: [sqlite] Update in SQLite

2004-08-16 Thread cai yuan
Hi all, Many thanks for your kindly reply. I will start using SQLite today.. ;-) Cai Yuan - Original Message - From: "Darren Duncan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, August 16, 2004 7:13 AM Subject: Re: [sqlite] Update in SQLite > At 1

Re: [sqlite] Update in SQLite

2004-08-15 Thread Darren Duncan
At 1:28 AM +0800 8/15/04, cai yuan wrote: Hi, I would like to test the SQLite in some linux embedded system. I read the limitation document and it says "To change a table you have to delete it (saving its contents to a temporary table) and recreate it from scratch." (Stated in http://www.hwaci.co

Re: [sqlite] Update in SQLite

2004-08-14 Thread Scott Leighton
On Saturday 14 August 2004 10:28 am, cai yuan wrote: > Hi, > I would like to test the SQLite in some linux embedded system. > I read the limitation document and it says > "To change a table you have to delete it (saving its contents to a > temporary table) and recreate it from scratch." (Stated in

Re: [sqlite] Update in SQLite

2004-08-14 Thread David M. Cook
On Sun, Aug 15, 2004 at 01:28:05AM +0800, cai yuan wrote: >"To change a table you have to delete it (saving its contents to a temporary >table) and recreate it from scratch." (Stated in >http://www.hwaci.com/sw/sqlite/omitted.html) Does it mean when I use the >"UPDATE ..." SQL statement, the table

[sqlite] Update in SQLite

2004-08-14 Thread cai yuan
Hi, I would like to test the SQLite in some linux embedded system. I read the limitation document and it says "To change a table you have to delete it (saving its contents to a temporary table) and recreate it from scratch." (Stated in http://www.hwaci.com/sw/sqlite/omitted.html) Does it mean whe