Re: [sqlite] Problem creating TRIGGER

> > sqlite> CREATE TRIGGER dat.on_master_insert INSERT ON dat.master_table FOR > EACH ROW BEGIN INSERT > INTO dat.url_stats(new.file_name, '0', '0', '1'); END; > SQL error: near ".": syntax error > > The problem is near new.file_name, as when I access the database through a > C++ program while

[sqlite] Problem creating TRIGGER

Hi! I am very new to sqlite. I am having problem creating a trigger. Here is the statement: - sqlite> CREATE TRIGGER dat.on_master_insert INSERT ON dat.master_table FOR EACH ROW BEGIN INSERT INTO dat.url_stats(new.file_name, '0', '0', '1'); END; SQL error: near ".": syntax error The problem i

[sqlite] Problem creating TRIGGER

Hi! I am very new to sqlite. I am having problem creating a trigger. Here is the statement: - sqlite> CREATE TRIGGER dat.on_master_insert INSERT ON dat.master_table FOR EACH ROW BEGIN INSERT INTO dat.url_stats(new.file_name, '0', '0', '1'); END; SQL error: near ".": syntax error The problem i