AUTOINDEX the 2nd

Hi there, the _REAL_ problem was, that every referencial constraint i have in the DB was gone!!!! The statement contains the two lines marked SELECT A.plz FROM Patient P, OUTER (daMitAN DMA, OUTER Anschrift A) WHERE P.datenID = 164011 AND DMA.datenID = 164011 AND DMA.class_type = P.class_type AND A.wmtDummyA2_ID = DMA.datenID AND A.wmtDummyA2_CT = DMA.class_type ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^these are normally four rows (ID to ID and CT to CT) that have an referencial constraint. When there is an referencial constraint i never see an AUTOINDEX. So now i'm looking for the place in the code where the referencial constrains are blown away. Thanks for the help Dirk Hellmann -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum