Help needed: SQL Creation of ObjectPtr

Wed Nov 28 05:17:35 CST 2007

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

-- 
Best regards,
Ivan Smahin 
Senior Software Engineer
Paradigma Software, Inc
Valentina - The Ultra-Fast Database
http://www.valentina-db.com