On 06/01/2011, at 7:09 PM, stunner Easwar wrote: > I need to use local variables similar to sql syntax using DECLARE. My project > involves lot of places where I need to select values from different tables > and insert it into one table. In most of the cases creation of view is also > not feasible. Any alternative for DECLARE.
Can you please give us example of your "places where I need to select values from different tables and insert it into one table". This is sometimes called "re-injection", where you're extracting the results of one query, only to re-inject it into another query. In SQL, this is a very inefficient way to do it. Most situations like this can be better handled by combining the select and insert into one SQL command. Tom BareFeetWare -- Comparison of SQLite GUI tools: http://www.barefeetware.com/sqlite/compare/?ml _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
