Re: FN-FORUM asp deleting record problem

date posted 27th January 2002 03:19

Hi Iain

Do you definatly want to delete the records? If you're using an autonumber
field for your unique ID then you're going to start getting mystery gaps in
your numbering. A far better idea is to use a Yes/No/BIT field which marks
the record as deleted. That way to delete the record you just have to mark
that field as True, and filter all 'deleted' records from your querys by
using that field. IE

SELECT someTable.someField
FROM someTable
WHERE someTable.deleted = FALSE

Not the answer you're looking for, but hopefully something worth thinking
about.

Norman


----- Original Message -----
From: [EMAIL REMOVED]
To: "Freelance forum" [EMAIL REMOVED]
Sent: Sunday, January 27, 2002 12:53 AM
Subject: FN-FORUM asp deleting record problem


> I am trying to delete a record from a database table. The record is linked
> to via a unique ID to two further tables. (Have been brought in to work
with
> an existing database)
>
> Is it possible to delete the record from all three tables at the same
time?
> I have found information on the macromedia site about adding to multiple
> tables from the same page but there seems to be no mention of deleting
from
> more than one table.