Thanks alot !!! Have a good day. Let me try.
On Wed, Jan 11, 2012 at 7:15 PM, Igor Tandetnik <itandet...@mvps.org> wrote: > Durga D <durga.d...@gmail.com> wrote: > > so, first I need to insert in t0 table, then query for value from t0, > then > > update t1 with this value. Needs to avoid reading from t0 table. > > You don't need to query t0 after insert. You can use > sqlite3_last_insert_rowid API function, or last_insert_rowid() SQL function. > -- > 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