Skip to Content
avatar image
Former Member

Compound PK in IDT Business Layer

What is the method to create a compound PK in IDT Business Layer. I've tried the method shown in the tutorials but that onlly alows for an atomic key and the manual (needless to say) doesn't cover it either. 

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 20, 2014 at 04:20 AM

    David, hello again.  As long as I'm not misunderstanding, I don't think you've got the right use of Keys in the Business Layer.  Keys in the Business Layer are intended to provide Index Awareness.  In a Primary Key/Foreign Key relationship, the idea is that you'd be able to pass a string like "Party Pants" to a lookup table to get the key value, presumably a numeric value, like the number "1", where "1" is the value for "Party Pants".  Good or bad, for as long as I can remember, the Universe has never been designed to work that way with a Compound Key.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Completely agree with Eric, the main reason of having a business layer is to hide all the database complexity in the first place..  Also I do not see any use case for this functionality in the universe which will be helpful for the business users

  • Apr 19, 2014 at 06:15 PM

    HI..

    If possible can you please provide one example or requirement to create compound PK in IDT Business Layer.

    Add comment
    10|10000 characters needed characters exceeded