SQLite Forum

SAVEPOINTS
Login
I ran into a problem with savepoints. Are savepoints supported in a trigger?

 33     SAVEPOINT X;
 34     INSERT INTO AUDIT(EMP_ID, NOTICE)
 35     VALUES (
 36         NEW.ID,
 37         (SELECT CASE 1
 38                 WHEN EMP_ID < 10 THEN NEW.NAME || ' is too young to be an employee.'
 39                            ELSE 'OK.'
 40         END)
 41     );
 42     RELEASE SAVEPOINT X;