Re: How to copy a record to another

Article View: borland.public.cppbuilder.database.ado

Article #3376

Back to borland.public.cppbuilder.database.ado Previous Next

#3376

From: G�khan �ATALKAYA
Date: Wed, 04 Sep 2002 14:54

15 lines
1488 bytes

Update tablename
set fieldname=newvalue
where select fieldname from anothertable;

place this code segment in a TQuery and run it when you like.

"HuangC" <HuangC913@msn.com>, haber iletisinde �unlar�
yazd�:3d6dc8d2$1@newsgroups.borland.com...
> Hi all,
> I have two Database that have the same structure,
> I have done a query in the first database, and now I want save the records
> that been finded into another database, does anyone can tell me how to do
> it. thanks in advance.
>
>

Technical Details

Message-ID: <3d761ea6@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-08!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

References: <3d6dc8d2$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,ebb5ea42dc823dd9
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-09-04 08:12:31 PST
From: "G�khan �ATALKAYA" <gcatalkaya@ttnet.net.tr>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3d6dc8d2$1@newsgroups.borland.com>
Subject: Re: How to copy a record to another
Date: Wed, 4 Sep 2002 17:54:25 +0300
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 195.175.217.244
Message-ID: <3d761ea6@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1031151270 195.175.217.244 (4 Sep 2002 07:54:30 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-08!supernews.com!newsswitch.lcs.mit.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail

Reply to Parent Message