Binary Link onDelete

[Ruslan Zasukhin]

On 2/5/07 6:05 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

Hi Bart,

> this statement generates an Vexception
> 
>      aBinaryLink = CreateBinaryLink
> ("mm_compcard_functprofile_to_my_competences",Table
> ("mm_compcard_functprofile"),Table
> ("my_competences"),EVLinkType.kMany,EVLinkType.kMany,EVOnDelete.kCascade
> ,EVStorageType.kDisk)
> 
> while this one is OK
> 
>      aBinaryLink = CreateBinaryLink
> ("mm_compcard_functprofile_to_my_competences",Table
> ("mm_compcard_functprofile"),Table
> ("my_competences"),EVLinkType.kMany,EVLinkType.kMany,EVOnDelete.kDefault
> ,EVStorageType.kDisk)
> 
> 
> The difference is the EVOnDelete.kDefault is accepted, kCascade is not.
> 
> Why ?

May be your BinaryLink is of 1:1 or M:M kind ?

In this case you need specify explicitly which table is OWNER/Parent.

> And what does kDefault mean in a many to many link ?

Aha, so you have Many to Many link.
Then you need specify OWNER-table.

Read please 

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vsql:reference:create_link



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]