hi thanks for the reply. yes, you are right. i am looking to last inserted id.
i am new in sqlite. please exaplain briefly. can u give me a example ya code. thanks dipendra Eugene Wee-2 wrote: > > Hi, > > On Wed, Apr 22, 2009 at 3:53 PM, dipendra > <dipendrakumar.jais...@gmail.com> 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://www.nabble.com/insert-into-multiple-table-tp23171437p23172579.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
