Use sqlite3_last_insert_rowid
----- Original Message -----
From: "Arora, Ajay" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, March 29, 2007 12:19 AM
Subject: [sqlite] RE: Maintaining Master-Child relationships
Can anyone please look into my query,
I've tables
Master ( id integer primary key,
field1 text)
And
Child (id integer, name text)
My application receive values for field1 and name. I need to populate
master and child with incoming values using the same id.
A quick reply will be highly appreciated.
Regards
Ajay
-----Original Message-----
From: Arora, Ajay
Sent: 28 March 2007 15:04
To: 'sqlite-users@sqlite.org'
Subject: Maintaining Master-Child relationships
Hi,
I've two tables in my database, a master and a child with ID as a
common key.
I've created a table with one column to generate the sequence number.How
can I insert related records into both the tables using same ID?
Thanks
Ajay
THE INFORMATION CONTAINED IN THIS MESSAGE AND ANY ATTACHMENT MAY BE
PRIVILEGED, CONFIDENTIAL, PROPRIETARY OR OTHERWISE PROTECTED FROM
DISCLOSURE. If the reader of this message is not the intended recipient,
you are hereby notified that any dissemination, distribution, copying or
use of this message and any attachment is strictly prohibited. If you have
received this message in error, please notify us immediately by replying
to the message and permanently delete it from your computer and destroy
any printout thereof.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------