Re: Where's SAVE TO in VDB7 SELECT statement?

Article View: borland.public.vdbase.data.sql

Article #1334

Back to borland.public.vdbase.data.sql Previous Next

#1334

From: Bowen Moursund
Date: Wed, 04 Feb 1998 00:00

15 lines
952 bytes

>Is there any way to save the results from a Sql Select statement in VDB7 to
>a new table?

Try COPY TO, e.g.:

 select * from MYTABLE where MYFIELD = "whatever"
 copy to NEWTABLE

An alternative is to use an UpdateSet object. See the online help for an
example.
__
Bowen Moursund (TeamB)
bowen.NOSPAM@nerds.com
http://www.mindspring.com/~bowenm/datatech.htm

Technical Details

Message-ID: <6ba8vu$7o13@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6b9th7$7j02@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,d6626bb0432135d6
X-Google-Attributes: gidff5a1,public
From: "Bowen Moursund" <teamb@opto-pps.com>
Subject: Re: Where's SAVE TO in VDB7 SELECT statement?
Date: 1998/02/04
Message-ID: <6ba8vu$7o13@forums.borland.com>
X-Deja-AN: 322047012
Content-Transfer-Encoding: 7bit
References: <6b9th7$7j02@forums.borland.com>
Content-Type: text/plain; charset="iso-8859-1"
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Organization: DataTech
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message