date column part of primary key in Oracle

[prev] [thread] [next] [Date index for 2005/02/08]

Is there something in CDBI that prevents you from having a date 
datatype as part of a primary key? I have a simple table with an 
order_id and an enter_date as the PKs. But when I list the enter_date 
in the Primary section, it comes back empty when I fetch records. All 
other columns have data.

If I put enter_date in Essential, it works. The problem is, if I have 
several records with the same order_id, CDBI spits them all out with 
the same date since they all look the same to CDBI.

Thanks for any insight.

Jim

==========================================
Jim Brandt
Administrative Computing Services
University at Buffalo