On 29 September 2010 11:49, <db.subscripti...@shepherdhill.biz> wrote: > Hi, > > I have this table: > > CREATE TABLE [repo] ( > [code] varchar(20) PRIMARY KEY NOT NULL, > [klass] varchar(2) > ); > > and trying to create this trigger: > > CREATE TRIGGER repo_klass > BEFORE INSERT ON `repo` > BEGIN > new.klass = SUBSTR(new.code,4,2); > END; > > I got this error: > near "new": syntax error. > > Kindly assist.
http://www.sqlite.org/lang_createtrigger.html BEGIN ... END; brackets a valid update, insert, delete or select SQL statement. "new.klass = SUBSTR(new.code,4,2);" is not one of the above. try: CREATE TRIGGER repo_klass AFTER INSERT ON repo BEGIN UPDATE repo SET klass = SUBSTR( new.code, 4, 2 ) WHERE code=new.code; END; > > Thanks. > > Chris. Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
