Usually, in SQL-server 2000, when I update fields of the table, I can use such sql statement:
if not EXISTS(select T.[name],F.[name] from sysobjects T left join syscolumns F on T.[id]=F.[id] where T.[name]='table_A' and F.[name]='field_A') alter table table_A add field_A varchar(20) not null default '' go But, how can I do in sqlite ? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
