Database engines never worked and hopefully never will work this way. You can easily implement it in your application: execute query, if no new infograms found then sleep for some time, check that total time passed doesn't exceed your limit, repeat everything from beginning.
Pavel On Thu, Apr 29, 2010 at 6:46 AM, Serdar Genc <serdar.g...@gmail.com> wrote: > My case is a little bit complex. Let me make a brief explanation about it. > Suppose you write a complex SQL query (preferably a select query) and send > this as a parameter > and waiting for its return value.. In this case, I would like to add a > defined period for the sqlite query > to wait. (30 seconds for instance). If infograms are inserted into my > database during this period then I > would like to be notified and take it. > > sqlite_execute_select_query(string query, int timeout); // this call will > suspend the execution of the application > > if an infogram is inserted that we would like to get according to our SQL > query then we continue the execution and > obtain that query. > > I think of creating a view for that SQL query and try to create trigger for > that view bla bla but no progress till now.. > > Has anyone got any idea how to do so.. > > Thanks in advance, > Serdar > > -> http://www.iptakip.com > _______________________________________________ > 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
