[sqlite] sqlite & multithreading

Hi! Problem: 1 - I need some help using sqlite3 with multithreading. Here is an overview of present situation: - I am using sqlite 3.0.8 I have two threads (A & B) working at the same time. Thread A is used to query database while thread B is being used for writing to the database. E

[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

[sqlite] A problem with the select statement

Hi! I am using sqlite 3.05 beta. I have created a table containing a field named 'title'. When I run the SQL Command : - select count(*) from master_table where title = "title" output is 885, i.e. count of all the rows in the table, whereas it should have returned the number of rows in which