The long way round yeah I could, Im deleting the oldest comment to be replaced with the newest like a rollover.
cmdDelete.CommandText = "DELETE FROM Comment WHERE iCommentID IN(" _
& "SELECT min(iCommentID) FROM Comment WHERE iListingID = " + Comment.ListingID.ToString + ")"
The comments I use have ParentId's (FK) which if used means that the Comment is a reply to another comment. If I delete the Parent Comment I want to delete any replies so that the data isn't irrelevant. Im deleting the comments regarding some business rules won't make to much sense its not really a forum like this or other common designs.
I can do it the long way round but would like to do it with as little DB requests as possible.