----- Original Message -----
From: Matthew Walker <[EMAIL PROTECTED]>
Date: Thu, 19 Aug 2004 10:25:19 +1200
Subject: RE: Access SQL Question
To: CF-Talk <[EMAIL PROTECTED]>
Is this what you want?
DELETE
FROM myTable
WHERE parent = 3
Or do you want to be able to recursively delete descendents (i.e. children,
cgrandchildren.) at all levels?
_____
From: Qasim Rasheed [mailto:[EMAIL PROTECTED]
Sent: Thursday, 19 August 2004 8:32 a.m.
To: CF-Talk
Subject: Access SQL Question
Is there a way in access where you can delete all the child of a
parent e.g. if I am deleting a record which a children and
children(s) may or may not have child. Here is db schema
id,name,parent
1,test1,0
2,test2,0
3,test3,1
4,test4,3
any help is appreciated
_____________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
