Re: Referential constraint in On-Line 7

Is it possible, that you placed referential constraints on other tables, without the cascading delete option? The other reason could be, that your database is no logging. I can't tell where in the Online 7 manuals you can find any reading about it, but in the Informix Guide to SQL V6.0 Tutorial you can find some stuff on p. 4-19 (Referential Integrity). Hope this helps, Roland wyang wrote: > > It seems that Informix On-line 7 supports cascading deletes when a > referential integrity is violoated. When I create a foreign key > constrait from dbaccess, it prompts me for "Add enable cascading deletes > Yes or No". I chose Yes because I thought this would allow me to delete > the referenced column without getting any error. But actually it does > not work that way. > > I search all informix manuals, but didn't find anything about cascading > deletes of foreigh key. > > Any comments are appreciated. > > Weimin