I have one database1 with dataTable1 and other database2 with dataTable2.
conn1 and conn2.
conn2->query("attach '".$_SESSION['QPO_dataBase1Path']."' as dst1");
//$_SESSION['QPO_dataBase1Path'] is path to database1, adding
database1 to database2
conn1.beginTransaction();
conn2.beginTransaction();
//problem area
conn1->query("SELECT * ....");
conn2->exec("UPDATE dataTable2 set spt_activtrigger = 3 where sim_id
in ( select sim_id from dataTable1 where ....));
.
.
.
.
conn1->exec("UPDATE dataTable1 set spt_activtrigger = 3 where sim_id
in ( select sim_id from dataTable2 where ....));
conn2->exec("UPDATE dataTable2 set spt_activtrigger = 3 where sim_id
in ( select sim_id from dataTable1 where ....));
.
.
// I have a lot of commands
conn1->commit();//problem database locked
conn2->commit();//problem database locked
How I can avoid this problem, and when database is locked????
Thanks!!!!
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
