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.
Thanks.
Chris.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
