Hi, On Wed, Apr 22, 2009 at 3:53 PM, dipendra <[email protected]> wrote: > i want to insert data in multiple table where one table depened upon the > other table > something like that--- > > 1-insert into phone table > insert into phone(id,phone) values (auto incremented ,099999999); > > 2-take the phone id value in integer variable > integer phoneid=value; > > 3-pass this value in to address table > insert into address(phoneid)values(phoneid);
You are probably looking to use sqlite3_last_insert_rowid(). Regards, Eugene Wee _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
