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