On Tue, Nov 3, 2009 at 1:23 PM, Victor Mayevski <vit...@gmail.com> wrote: > Ok, I will rephrase my question although it appears that the answer is > has been already preconceived. I am writing an abstraction layer to > Sqlite where tables, views, triggers etc are presented as XOTcl > Classes/Objects. If two different scripts access the database and one > of them creates a new table, the other has no way of knowing about it > unless it does some kind of polling periodically. That new table > should appear as an XOTcl object in the running script. Well, the > script that creates the table will also create the object. The other > script has to do the polling unless it is possible to do it some other > way.
You started off by saying that you will rephrase your question, but not only do you not have any "?" in the para above, I don't even get an implied question. Based on your earlier email though, I can guess that you are still asking if one db handle can divine what another db handle did. The answer is, afaik, "no." It would be highly dangerous if it could. Of course, once your db changes initiated from one db handle are committed to disk, any db handle created after that would use the altered db. Perhaps there is a way to figure out the changes on the fly, but it seems like a dicey path to go down on. -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= Sent from Madison, Wisconsin, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users