Oops, I forgot the "new." prefixes. That trigger should be: create trigger "Import insert" instead of insert on Import begin insert into Person (Name, Email) select case when new.Name = '' then null else new.Name end , case when new.Email = '' then null else new.Email end ; end ;
Or more simply, using the nullif() function: create trigger "Import insert" instead of insert on Import begin insert into Person (Name, Email) select nullif(new.Name, '') , nullif(new.Email, '') ; end ; Tom Tom Brodhurst-Hill BareFeetWare Sent from my iPad _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
