I'm trying to insert a trigger from command line in OpenOffice 4.1.3, and I'm using this configuration:
Tools --> Options --> OpenOffice --> Java --> "Use..." checked --> classpath --> add package --> "The file (hsqldb.jar) downloaded from that i downloaded from here: Access2Base
http://www.access2base.com/access2base.html
So... This is the code that I'm trying to execute:
Code: Select all
CREATE TRIGGER "t1" AFTER UPDATE ON "DesgloseCostes"
FOR EACH ROW
BEGIN ATOMIC
update "Costes" set "importenoiva" = (NEW."importe");
END
Code: Select all
1: Unexpected end of command: BEGIN in statement [CREATE TRIGGER "t1" AFTER UPDATE ON "DesgloseCostes"
FOR EACH ROW
BEGIN]
PS2: I had a similar problem in mysql but I solved it there changing the delimiter to //
this is a sample code:
Code: Select all
CREATE TRIGGER "t1" AFTER UPDATE ON "DesgloseCostes"
FOR EACH ROW
BEGIN ATOMIC
update "Costes" set "importenoiva" = (NEW."importe");
END//