Re: FN-FORUM asp deleting record problem

date posted 27th January 2002 12:24

Well done for mentioning transactions ...

Of course, if you'd used Oracle instead of ms blah,
you could just set the "Cascade Delete" property of the main table to true.

And then Oracle would handle all this for you.

:-)
----- Original Message -----
From: Trevor Spink [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Sunday, January 27, 2002 11:49 AM
Subject: RE: FN-FORUM asp deleting record problem


> Nice and neat solution, assumes however that you have available all the
> foreign keys.
> If you need to run a select to get the FK, things can get a little more
> ugly. But the use of transactions is essential whether in ASP or Stored
> Procedure.
>
> -----Original Message-----
> From: [EMAIL REMOVED]
> [EMAIL REMOVED] Behalf Of Robert Blackmore
> Sent: 27 January 2002 11:15
> To: [EMAIL REMOVED]
> Subject: RE: FN-FORUM asp deleting record problem
>
>
> Hi Ian,
>
> You can use a transaction and execute 3 delete statements from within
> the ASP code.
>
> e.g.
>
> Lcon.BeginTrans
> Lcon.Execute "DELETE * FROM Sub1 WHERE ID = " & LlngID
> Lcon.Execute "DELETE * FROM Sub2 WHERE ID = " & LlngID
> Lcon.Execute "DELETE * FROM Main WHERE ID = " & LlngID
> Lcon.CommitTrans
>
>
> The transaction will ensure that the data is either deleted from all 3
> tables or no tables.
>
> Regards,
>
> Rob
>
> > ----- 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]
> >
>
>
> ===============================================================
> = 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]
>
>
> ===============================================================
> = 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]
>
>
> ===============================================================
> = 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]
>