Re: [sqlite] Trouble with ALTER TABLE/ADD

2006-10-26 Thread Isaac Raway
On 10/25/06, Christian Smith <[EMAIL PROTECTED]> wrote: A better solution would be to transfer the contents of the table being updated to a temporary table, then recreate the original tables sans the surplus columnn: It may not be quick for large tables, but how often are you going to be

Re: [sqlite] Trouble with ALTER TABLE/ADD

2006-10-25 Thread Christian Smith
Isaac Raway uttered: Thank, I will look at that (away from my dev machine for the day). One other related question, are there plans to expand the functionality of ALTER TABLE? I am working on a feature that could benefit greatly from REMOVE/RENAME COLUMN. As it stands, I am going to have to

Re: [sqlite] Trouble with ALTER TABLE/ADD

2006-10-23 Thread Isaac Raway
Thank, I will look at that (away from my dev machine for the day). One other related question, are there plans to expand the functionality of ALTER TABLE? I am working on a feature that could benefit greatly from REMOVE/RENAME COLUMN. As it stands, I am going to have to simulate this by using

Re: [sqlite] Trouble with ALTER TABLE/ADD

2006-10-23 Thread drh
"Isaac Raway" <[EMAIL PROTECTED]> wrote: > > ALTER TABLE topic ADD COLUMN type_id integer; > > This works fine when I run it on the sqlite3 command line, but fails in the > Delphi units. Any thoughts? Has anyone ahd trouble running ALTER TABLE from > the Delphi bindings? > Perhaps the delphi

[sqlite] Trouble with ALTER TABLE/ADD

2006-10-23 Thread Isaac Raway
Hi, this is my first question on this list. First, a brief introduction: I've been using sqlite for about the past year or so and so far I'm very happy with it. As far as databases, I have experience with MySQL, SQL Server and of course Access. My language skills include Delphi, PHP, Tcl, and VB

[sqlite] Trouble with ALTER TABLE/ADD

2006-10-22 Thread Isaac Raway
Hi, this is my first question on this list. First, a brief introduction: I've been using sqlite for about the past year or so and so far I'm very happy with it. As far as databases, I have experience with MySQL, SQL Server and of course Access. My language skills include Delphi, PHP, Tcl, and VB