Article View: borland.public.interbase.sql
Article #759Re: Update one table based on data in another
From: Bill Todd
Date: Tue, 26 Jun 2007 21:50
Date: Tue, 26 Jun 2007 21:50
11 lines
1368 bytes
1368 bytes
Paul wrote: > However, I will (as you suggest) just run the sql statement you > provided (which works great ;)) several times to update all fields. > Probably contruct the sql on the fly and programatically change the > field name. You can update all of the fields in a single UPDATE statement. -- Bill Todd (TeamB)
Technical Details
Message-ID:
<46818a27$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<bec083t4td4iqapnt5pu2sm66tp172oudu@4ax.com> <46804923$1@newsgroups.borland.com> <bov0839c1ajn1k0b8ercnip94med9g05g2@4ax.com> <468090bf$1@newsgroups.borland.com> <o3r283leioornf8hkkfnn17jiktrnmkc7d@4ax.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,2270d561f33be473
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Bill Todd" <no@no.com>
Subject: Re: Update one table based on data in another
Newsgroups: borland.public.interbase.sql
References: <bec083t4td4iqapnt5pu2sm66tp172oudu@4ax.com> <46804923$1@newsgroups.borland.com> <bov0839c1ajn1k0b8ercnip94med9g05g2@4ax.com> <468090bf$1@newsgroups.borland.com> <o3r283leioornf8hkkfnn17jiktrnmkc7d@4ax.com>
Organization: The Database Group, Inc.
User-Agent: XanaNews/1.18.1.6
X-Face: ":yn4zt^A_dn>6~{YJmu^B\'4w)e:apPM\VC=Dvf&*tASxX9|BYczkFd$xr.$vNSZ[3Uobr p]c4\+\l){!WQI.$]veP({HLd;CDYH?iN
NNTP-Posting-Host: 216.207.211.19
Message-ID: <46818a27$1@newsgroups.borland.com>
Date: 26 Jun 2007 14:50:31 -0700
X-Trace: newsgroups.borland.com 1182894631 216.207.211.19 (26 Jun 2007 14:50:31 -0700)
Lines: 11
X-Authenticated-User: btodd
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail