Article View: borland.public.vdbase.data.sql
Article #1551Re: Updating Related Keys
From: Romain Strieff [TeamB]
Date: Sat, 22 Nov 1997 00:00
Date: Sat, 22 Nov 1997 00:00
21 lines
1273 bytes
1273 bytes
In article <01bcf6b3$9c330720$1030f489@jyuzamas.robins.af.mil>, jyuzamas@wrdiss1.robins.af.mil says... > The simple way would be to replace the seek and replace with the following > SQL; > > UPDATE ORDERS SET CUSTOMER = :cNewStore ; > WHERE CUSTOMER = :cOldStore > > Don't worry about indexs, they take care of them selves. > Yes, and do the same for the backup, history, logfiles, etc and all the children and children's children and children's children children and their siblings and if somebody has a lock on just _one_ record of those it will fail and you'll have to rollback. It _is_ easier never to come in that situation.<G> -- Romain Strieff [TeamB] A few VdB utilities at: http://ourworld.compuserve.com/homepages/RStrieff/
Technical Details
Message-ID:
<MPG.ee085c5fbc64e2f98a016@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<34466D8E.53A1@total.net> <01bcf6b3$9c330720$1030f489@jyuzamas.robins.af.mil>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,637a3bf0e23a423d X-Google-Attributes: gidff5a1,public From: Romain@Do.not.reply.via.e-mail (Romain Strieff [TeamB]) Subject: Re: Updating Related Keys Date: 1997/11/22 Message-ID: <MPG.ee085c5fbc64e2f98a016@forums.borland.com> X-Deja-AN: 291513448 References: <34466D8E.53A1@total.net> <01bcf6b3$9c330720$1030f489@jyuzamas.robins.af.mil> Reply-To: teamb@opto-pps.com Organization: TeamB Newsgroups: borland.public.vdbase.data.sql