--
-Original Message-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 11 September 2000 11:17
To: '[EMAIL PROTECTED]'
Subject: RE: SQL - Relational issue
You need one DELETE statement for each table that you want
to delete from. One way to make this simpler is to
put the DELETE
Hey, this TRIGGER thing is cool. Just what i need.
Thanks a lot Nick!
- Original Message -
From: DeVoil, Nick <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 11, 2000 6:16 PM
Subject: RE: SQL - Relational issue
> You need one DELETE statement for
g orphan records
but it won't do cascading deletes for you unless you
have triggers set up to do it.
Nick
-Original Message-
From: Rudy Rustam [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 11, 2000 11:03 AM
To: [EMAIL PROTECTED]
Subject: Re: SQL - Relational issue
Back to the
Sent: Monday, September 11, 2000 4:02 PM
Subject: RE: SQL - Relational issue
> 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 sho
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 mo
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.
I
6 matches
Mail list logo