Oracle BI sequence generated primary key question

  • Thread starter Corey-g via AccessMonster.com
  • Start date
C

Corey-g via AccessMonster.com

Hi All,

I have a Before Insert (BI) trigger in Oracle to generate a PK (from a
sequence). I have a form bound to the Oracle table (linked programatically
using ADOX). I also have multiple subforms bound to various other linked
Oracle tables which have referential Integrity (RI) constraints based on this
genreated PK. The question I have is how do I know when the PK is generated
and what it is? If I was building this with unbound forms and code, I know I
could return the new PK as a result of the insert, but what about in bound
forms? I ask this because I am seeing the some of my linked tables not
getting the right value set (in that the FK is blank even though I have set
the Link Child Fields & Link Master Fields values to this linked PK field...
(I did have a Not Null constraint on the FK field, but removed temporarily to
debug - where I found that the PK isn't being set)

Environment deatils:
Access 2K3, Oracle 9i, and Access runtime on WIndows 2000 & XP

Thanks for any thoughts, ideas, or suggestions...

Corey
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

primary key - concatenated or autonumber? 6
Oracle linked tables 3
Multi_field Primary Key to FK 6
how to determine if primary key is set 2
Primary and Foreign Keys 10
Problem designing a form envolving many-to-many relationships 3
What is the good way to design this form 4
Adding subform missing composite primary keys 1

Top