on delete cascade and dynamic sql

Hi,

I have a procedure that uses dynamic sql to delete rows from a table. There is another table that has a foreign key "on cascade delete" to the primary key of the first table. This works fine in regular sql - when I delete parent rows, the corresponding child rows are also deleted. In dynamic sql, this doesn't happen! Does anybody know why?

Thx

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Aug 19 1999 - 15:23:37 CDT