> > 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