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

Reply via email to