updating and foreign keys

[email protected] Mon, 10 Mar 2003 22:56:51

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-906180-2003.03.10-22.39.22--gcdod-oracle#[email protected]>

A new record is contained by recordset rs. rs contains fields from
table A and table B.  Table A contains, as a foreign key, the primary
key for table B.  How do you add a record using rs?

The problem I'm having is getting the foreign key into table A.  If I
do:
  rs.update

Table A and B both get a primary key assigned, but I can't figure out
a way to get the foreign key into table A.

Any tips would be appreciated.

  Scott
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].