V4MD: unique composite key

[Ruslan Zasukhin]

On 2/7/05 11:41 AM, "info at vallemediatime.com" <info at vallemediatime.com>
wrote:

> Hi Ruslan, 
> thanks for the previous answer.
> At last I need to know how to make a composite primay key in two column of the
> additional third table.
> e.g.
> From your example in VKernel-31
> ---------------------------------
>       Table: Has
> ---------------------------------
> Person_ptr     Task_ptr
> ---------------------------------
>       1                 1
>       2                 1
>       3                 3
>>    1                 1     How I check that I don't have a duplicate record?
>  
> Thank
> Paolo

This task can be solved by adding into table
One virtual field ( BaseObject method)

    fldF1F2 of type ULLONG  8 bytes
    
With formula in your case

    (Person_ptr << 32) + Task_ptr


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------