On Tue, May 31, 2011 at 6:09 PM, Fabio Spadaro <[email protected]>wrote:
> To recap:
> Step 1: alter table pippo rename to fabio -> ok
> step 2: insert into fabio (field1) values ('1 ') -> ko
> OperationalError: no such table main.pippo
> Step 3: alter table add column fabio field2 integer null -> ok
> result:
> empty table
> Question: Why does my insert referring to the old table?
>
Because you typed it that way? If the insert is part of a trigger (you
didn't mention a trigger, but it sounds like you're using one), see:
http://www.sqlite.org/lang_altertable.html
and read the 3rd paragraph. If it is not part of a trigger, then simply
correct the spelling in your program/SQL script.
--
----- stephan beal
http://wanderinghorse.net/home/stephan/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
