Hi Rudy
[You wrote:]
System : NT4, MSSQL 7 and CF 4.5
Scenario:
I have 2 tables, USERS and CARS with One-to-Many relationship.
If I delete a user, then all cars that he has should be deleted too.
I use 2 queries to delete a user in the USERS and all his cars in the =
CARS table.
Is there a more efficient way to just delete a user in USERS table and =
all connection to this will also be deleted too?
Imagine if there are more than 10 relational tables.
And Can setting up a Relation Diagram in SQL help me? (I did some tests =
and it doesn't turn out to be what I expected)
Suggestions and Advices are very much welcome.
[Ant says:]
If you enforce referential integrity in MS SQL the manual says:
"When you enforce referential integrity, SQL Server prevents users from:
Adding records to a related table if there is no associated record in the
primary table.
Changing values in a primary table that result in orphaned records in a
related table.
Deleting records from a primary table if there are matching related
records."
This means that SQL will manage the references for you!
Regards,
Anthony Geoghegan.
Lead Developer,
IFTN
http://www.wow.ie
mailto:[EMAIL PROTECTED]
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
