"I read somewhere that the DDL is really just a copy of the text when teh table was created" It starts that way, but the ALTER TABLE command will update that string when it runs so that it reflects the new column.
Did you commit your changes after the alter table and before looking for the change in Sqlite Expert? "However, when I use the Sqlite Expert, the DDL is not reflected. Even though the column is created." Never having used Sqlite Expert, how are you determining that it was created? Further queries using the column work? Some GUI showing fields has been updated? Some other means? When you say "the DDL is not reflected" how are you looking at the DDL? Is it some special window in Sqlite Expert? Are you explicitly running a select statement on sqlite_master? Some other method? If you close Sqlite Expert and re-open it does it show the changes now? At the moment it kind of sounds like Sqlite Expert is doing some sort of non-expert caching that it isn't updating the way it should. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
