OpenEuphoria

Re: euEDB / euSQL primary key problem

• Posted by Matt Lewis <matthewwalkerlewis at gmail.com> Feb 18, 2007
• 526 views

duke normandin wrote:
> 
> hey....
> 
> I need to have both keys in a 2-key table form a "composite" primary key.
> Can't
> seem to be able to convince euEDB to accept that scenario. Anybody know if
> this
> feature is supported in euEDB / euSQL ?
> 
> Example:
> 
> Students Table           Participants Table            Activities Table    
>     
> Name   | ID*             ID*   |  Activity*            Activity*  |  Cost
> 
> You see how the fields in the "Participants" table are really "foreign" keys
> that _together_ constitutes the table's unique key? TIA...

You need to put ID and Activity into a sequence, and make that the key.
For eusql, you'd need to make them 'sub-fields.'

PK.ID
PK.Activity

Matt