"blackbox" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm new to SQLite and triggers. Is it possible to set a trigger so it > updates a field of a new record in a table to the same value as the > Autoincrement field. > > i.e. > > Field1, Integer Autoincrement > Field2, Integer > Field3, Text > Field4, Text > > When the user enters text in Field3 & Field4, Field1 is > auto-populated. When the new record is saved, I would like the > trigger to set Field2 to be the same as Field1. I have no idea how > to set the syntax to do this.
create trigger triggerName after insert on tableName begin update tableName set Field2=new.Field1 where Field1 = new.Field1; end; > Also, is it possible to have an autoincrement field in SQLite that is > not a primary key? No. Why would you want to? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users