Re: SQL SAVE TO option

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

Article #1136

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

#1136

From: Warrick Clarke
Date: Fri, 17 Apr 1998 00:00

27 lines
1072 bytes

I use updateset() I don't know if its the best way but it works for me.

q = new Query()

q.sql = "select * from fish"
q.active = true

u = new UpdateSet()

u.source = q.rowset
u.destination = "results.dbf"
u.copy()

q.active =false

Regards
Warrick

> How do I create a new database from the results of a select?
> I don't see anything in OLH but recall someone here saying it is supported?
> Is it SAVE TO or COPY TO ? What is syntax?
>
> --
> Thanks,
> Tom Gleaton
> County of Riverside,  Riverside California

Technical Details

Message-ID: <3536C135.191DDC98@latrobe.edu.au>

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

References: <01bd6955$04033e60$4a4c96d1@dict2>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,314cd95164e49b11
X-Google-Attributes: gidff5a1,public
From: Warrick Clarke <w.clarke@latrobe.edu.au>
Subject: Re: SQL SAVE TO option
Date: 1998/04/17
Message-ID: <3536C135.191DDC98@latrobe.edu.au>
X-Deja-AN: 344871663
Content-Transfer-Encoding: 7bit
References: <01bd6955$04033e60$4a4c96d1@dict2>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message