Hello,
I try to create a delete trigger by this expression:
create trigger 'test1' before delete ON 'filter'
FOR EACH ROW
BEGIN
insert into recordiation set id = 1, currentdate = now(), name = old.name;
END
But I have some exception. Logs:
Синтаксическая ошибка в выражении SQL "CREATE TRIGGER
GOODWILLCATALOG.'test1'[*] BEFORE DELETE ON 'filter'
FOR EACH ROW
BEGIN
INSERT INTO RECORDIATION SET ID = 1, CURRENTDATE = NOW(), NAME = OLD.NAME "
; ожидалось "identifier"
Syntax error in SQL statement "CREATE TRIGGER GOODWILLCATALOG.'test1'[*]
BEFORE DELETE ON 'filter'
FOR EACH ROW
BEGIN
INSERT INTO RECORDIATION SET ID = 1, CURRENTDATE = NOW(), NAME = OLD.NAME "
; expected "identifier"; SQL statement:
create trigger GoodwillCatalog.'test1' before delete ON 'filter'
FOR EACH ROW
BEGIN
insert into recordiation set id = 1, currentdate = now(), name = old.name [
42001-168] 42001/42001 (Помощь)
END;
Синтаксическая ошибка в выражении SQL "END"; ожидалось "EXPLAIN, EXECUTE, {"
Syntax error in SQL statement "END"; expected "EXPLAIN, EXECUTE, {"; SQL
statement:
END [42001-168] 42001/42001 (Помощь)
I would be grateful for any advice.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
