Article View: borland.public.interbase.sql
Article #760Re: Update one table based on data in another
From: Paul
Date: Tue, 26 Jun 2007 22:15
Date: Tue, 26 Jun 2007 22:15
26 lines
1807 bytes
1807 bytes
Dont suppose you could share the syntax with me please ? A brief example ? Just that, this is the problem I had initially. Could find code showing how to update one field, but not more than one. Have tried several variations in syntax, but none work. Many thanks.. Paul. On 26 Jun 2007 14:50:31 -0700, "Bill Todd" <no@no.com> wrote: >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. OS : Windows XP Service Pack 2 Delphi : 2005 Service Pack 3 Installed CPU : AMD 3500+
Technical Details
Message-ID:
<as3383h1vg5gfj48ppdov8po5d2pt01457@4ax.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.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> <46818a27$1@newsgroups.borland.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: Paul <nospam@sdiespammersdie.com> Newsgroups: borland.public.interbase.sql Subject: Re: Update one table based on data in another Date: Tue, 26 Jun 2007 23:15:34 +0100 Organization: None Message-ID: <as3383h1vg5gfj48ppdov8po5d2pt01457@4ax.com> References: <bec083t4td4iqapnt5pu2sm66tp172oudu@4ax.com> <46804923$1@newsgroups.borland.com> <bov0839c1ajn1k0b8ercnip94med9g05g2@4ax.com> <468090bf$1@newsgroups.borland.com> <o3r283leioornf8hkkfnn17jiktrnmkc7d@4ax.com> <46818a27$1@newsgroups.borland.com> X-Newsreader: Forte Agent 1.92/32.572 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 86.154.104.5 X-Trace: newsgroups.borland.com 1182896132 86.154.104.5 (26 Jun 2007 15:15:32 -0700) Lines: 26 Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail