Re: [sqlite] Adding a column to an sqlite database through the sqlite utility interface

2005-03-02 Thread Steve Frierdich
LE t1_backup; COMMIT; .Jan- Original Message - From: "Ulrik Petersen" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 02, 2005 8:03 PM Subject: Re: [sqlite] Adding a column to an sqlite database through the sqlite utility interface Steve Frierdich wrote: D

Re: [sqlite] Adding a column to an sqlite database through the sqlite utility interface

2005-03-02 Thread Jan Ekström
Original Message - From: "Steve Frierdich" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 02, 2005 7:26 PM Subject: [sqlite] Adding a column to an sqlite database through the sqlite utility interface Does anyone know how to add a column to an sqlite database through the

Re: [sqlite] Adding a column to an sqlite database through the sqlite utility interface

2005-03-02 Thread Jan Ekström
lrik Petersen" <[EMAIL PROTECTED]> To: Sent: Wednesday, March 02, 2005 8:03 PM Subject: Re: [sqlite] Adding a column to an sqlite database through the sqlite utility interface Steve Frierdich wrote: Does anyone know how to add a column to an sqlite database through the sqlite util

Re: [sqlite] Adding a column to an sqlite database through the sqlite utility interface

2005-03-02 Thread Ulrik Petersen
Steve Frierdich wrote: Does anyone know how to add a column to an sqlite database through the sqlite utility interface. I tried the SQL statement , ALTER TABLE table Name ADD column variable, and it did not work. Anyone know any other way? Thanks Steve http://www.sqlite.org/faq.html#q13

[sqlite] Adding a column to an sqlite database through the sqlite utility interface

2005-03-02 Thread Steve Frierdich
Does anyone know how to add a column to an sqlite database through the sqlite utility interface. I tried the SQL statement , ALTER TABLE table Name ADD column variable, and it did not work. Anyone know any other way? Thanks Steve Shum [Ming Yik] wrote: >Hi, > >I would like to ask ...: > >1.) Add