Re: [sqlite] insert into multiple table

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 >

Re: [sqlite] insert into multiple table

Hi, On Wed, Apr 22, 2009 at 3:53 PM, dipendra 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

[sqlite] insert into multiple table

hi 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 ,0); 2-take the phone id value in integer variable integer phoneid=value; 3-pass this value in