It solves the problem. I put all in one connection, made attach and
everything is fine.
Thanks Igor, you save me a hours!!!!!!!!!
2010/11/16 Igor Tandetnik <itandet...@mvps.org>:
> 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
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
