problem in create trigger

[zirill]

create trigger not working:

CREATE TABLE COMPANY(
   ID INT PRIMARY KEY     NOT NULL,
   NAME           TEXT    NOT NULL,
   AGE            INT     NOT NULL,
   ADDRESS        CHAR(50),
   SALARY         REAL
);
 CREATE TABLE AUDIT(
    EMP_ID INT NOT NULL,
    ENTRY_DATE TEXT NOT NULL
);
CREATE TRIGGER audit_log AFTER INSERT
ON COMPANY
BEGIN
   INSERT INTO AUDIT(EMP_ID, ENTRY_DATE) VALUES (new.ID, datetime('now'));
END;

[lovasoa]

You are right, thank you for opening this issue. The problem is here: https://github.com/kripken/sql.js/blob/master/coffee/api.coffee#L311 .

I'm going to fix that ASAP and add it to the tests.

[zirill]

Many thanks for your wonderful project.
On this basis, I have now created a GUI
http://sqliteonline.com

[lovasoa]

Wow http://sqliteonline.com is really impressive!
Is it open source? Do you have many visits?

[zirill]

Still very much did not, now there is a "closed" alpha testing.
js - only open source :)