Help needed: SQL Creation of ObjectPtr

[Karl Grob]

This works

Thanks
Karl

Am 28.11.2007 um 12:26 schrieb Ruslan Zasukhin:

> On 28/11/07 1:17 PM, "Ivan Smahin" <ivan_smahin at paradigmasoft.com>  
> wrote:
>
>> Hello Karl,
>>
>> Wednesday, November 28, 2007, 12:35:34 PM, you wrote:
>>
>>> Hi
>>
>>> Can anyone give me some help?
>>
>>> ALTER TABLE tbl_Wortindex
>>> ADD tbl_Wortindex_eroeffnetVon OBJECTPTR INDEXED
>>> REFERENCES  tbl_Benutzer ON DELETE SET NULL
>>> CONSTRAINT Link_tbl_Wortindex_eroeffnetVon
>>> ON UPDATE NULL
>>
>> Try it please, it is known bug - constraint clause should come first.
>>
>> ALTER TABLE tbl_Wortindex
>> ADD tbl_Wortindex_eroeffnetVon OBJECTPTR INDEXED
>> CONSTRAINT Link_tbl_Wortindex_eroeffnetVon
>> REFERENCES  tbl_Benutzer
>> ON DELETE SET NULL
>> ON UPDATE SET NULL
>
> Ivan,
>
> You self point me just only:
>
>    for ObjectPtr   ON UPDATE have no sense,
>    because RecID value is never changed.
>
> So enough
>
> ALTER TABLE tbl_Wortindex
> ADD tbl_Wortindex_eroeffnetVon OBJECTPTR INDEXED
> CONSTRAINT Link_tbl_Wortindex_eroeffnetVon
> REFERENCES  tbl_Benutzer
>   ON DELETE SET NULL
>
>
>
>
>
> -- 
> 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]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina