Re: FN-FORUM asp deleting record problem/transactions

date posted 27th January 2002 13:44

OK you got me there... I had never heard of 'transactions' but....after
searching at http://www.tcp-ip.com/ i eventually found a bit about them and
an articel about using the RecordSet object at
http://www.programmersresource.com/articles/delrec.asp

I will work through these.

Many thanks for pointing me in the correct direction.

Iain
----- 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]
>