Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Right method to enforce Composite Primary Key

Status
Not open for further replies.

Deadline

Programmer
Feb 28, 2001
367
US
Hi,
What is the most appropriate and elegant method to enforce Composite keys in "Detail" Tables(Transaction Tables) ?

Thank you,
RR.
__________________________________
The best is yet to come.
 
Ok, I'm rephrasing my question here -


What would be the most elegant and/or appropriate method to enforce/implement Primary key constraints in Visual Basic for an Oracle Database both composite and single ?

I'd like to gracefully alert the user that their set of data(which constitute the primary keys) is already present in the database - Should I query the table(s) before saving the record ? or else how ? Thank you,
RR.
__________________________________
The best is yet to come.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top