June 25, 2003 at 8:46 am
Every book that I have seems to be wrong.
I must ask how to do a cascade delete. For my own amusement, I'll post what my book says.
Open table A with the Query option, Change the select format to delete, enter the statement. Then open table b (the related table) to view all records.
Run the query on the table A
It is supposed to automatically delete the records in Table b that correspond to the "ID" but it doesn't.
Any help would be great
June 25, 2003 at 11:08 am
Can you post the T-SQL code behind the tables and specifically the foreign key constraints?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
June 25, 2003 at 12:21 pm
I'm getting this error.
'Site_Visitor' table saved successfully
'Site_Visitor_List_Topics' table
- Unable to create relationship 'FK_Site_Visitor_List_Topics_Site_Visitor'.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Site_Visitor_List_Topics_Site_Visitor'. The conflict occurred in database 'hudsonorg', table 'Site_Visitor', column 'site_visitor_id'.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply