[SOLVED]: [sqlite] Problems adding a new column

Hello Paul, You just beat me by a couple minutes! :-) Thanks, I've found out this statement works as well: -> INSERT INTO address_backup(ROWID,First,Last,Country) SELECT ROWID,First,Last,Country FROM address; Thanks a lot, -- Tito On 26 may 2004, at 9:15, Paul Smith wrote: Shouldn't the

Re: [sqlite] Problems adding a new column

At 14:03 26/05/2004, Tito Ciuro wrote: Hello, I would like to add a new column to an existing table on-the-fly. I've followed the code found on SQLite's website: http://sqlite.org/faq.html#q13 and modified it slightly to the following: Adding table 'address' to the database... -> CREATE

[sqlite] Problems adding a new column

Hello, I would like to add a new column to an existing table on-the-fly. I've followed the code found on SQLite's website: http://sqlite.org/faq.html#q13 and modified it slightly to the following: Adding table 'address' to the database... -> CREATE TABLE address(ROWID INTEGER PRIMARY