ondelete cascade

[ramsai8]

HI,

i struck with a problem when i was deleting arow from database which is having

primary key in one table and that one is also having foureign key in second table

the error is like this

DELETE statement conflicted with TABLE REFERENCE constraint 'FK_DAUse_Clien ts'. The conflict occurred in database 'SIIP', table 'DAUseHistory'.

[kenobewan]

Please show us both statements. Thanks.

[Plater]

Have you tried the CASCADE DOWN command in your delete statement?
(Or is it CASCADE up? I can never remember, they're dangerous)