Re: FN-FORUM asp deleting record problem

date posted 27th January 2002 08:59

Interesting thought - I'll put it to the database designer. Only one of the
tables has the ID created as an autonumber so I could delete from the 2
linked tables and mark the main table as deleted. Thanks

Iain
----- Original Message -----
From: "Norman Beresford" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, January 27, 2002 3:11 AM
Subject: Re: FN-FORUM asp deleting record problem


> 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.
>
>
>
> ===============================================================
> = SAVE TIME *AND* MAKE MONEY! with Neutralize (**): =
> = Generate bespoke quotes for Online Marketing Services. =
> = Resellers info at http://www.neutralize.com & 01209 210 910 =
> ===============================================================
>
> **************************************************************
> *** Sponsor the forum for as little as £1 at: ***
> *** ***
> *** http://www.freelancers.net/cgi/sponsor.cgi?action=show ***
> **************************************************************
>
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>