Mihailo <gaji...@gmail.com> wrote:
> I have one database1 with dataTable1 and other database2 with dataTable2.
> conn1 and conn2.
>
> 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 ....));
It seems you have two connections, both of which refer to both databases. Why
do you think you need sepearate connections in the first place? Why can't you
just have one connection execute both these statements?
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
