>
> 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
> using master_table instead of dat.master_table, same error is emitted.
The VALUES keyword is missing from your INSERT statement.
__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail