This is a multi-part message in MIME format.
------=_NextPart_000_0086_01C01C09.22A55D80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
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.
Thanks in advance.
- Rudy
------=_NextPart_000_0086_01C01C09.22A55D80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>System : NT4, <FONT face=3DArial =
size=3D2>MSSQL 7=20
and CF 4.5</FONT></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Scenario:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I have 2 tables, USERS and CARS with =
One-to-Many=20
relationship.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>If I delete a user, then all cars that =
he has=20
should be deleted too.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I use 2 queries to delete a user in the =
USERS and=20
all his cars in the CARS table.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Is there a more efficient way to just =
delete a user=20
in USERS table and all connection to this will also be deleted =
too?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Imagine if there are more than 10 =
relational=20
tables.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>And Can setting up a Relation Diagram =
in SQL help=20
me? (I did some tests and it doesn't turn out to be what I=20
expected)</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Suggestions and Advices are very much=20
welcome.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>- Rudy</FONT></DIV></BODY></HTML>
------=_NextPart_000_0086_01C01C09.22A55D80--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.
