Does SQL 7 support cascading for DRI (PK/FK), or the only way to do it is
All the best,
Neil Pike MVP/MCSE. Protech Computing LtdQuote:> Does SQL 7 support cascading for DRI (PK/FK), or the only way to do it is
> "triggers" ?.
With MS SQL Server 6.5 Cascading Update & Cascading Delete can be done with
"declarative referential integrity".
But: I didn't manage to define tables with primary/foreign key constraints
where e.g. a cascading update automatically occurs.
When I try to update a row in the 'primary key'-table the message 'UPDATE
statement conflicted with COLUMN FOREIGN KEY constraint ...' displays.
Can anyone give me a hint how the primary/foreign key constraints have to be
done in order to make it all work.