Help needed: SQL Creation of ObjectPtr

[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]