Re: how to get permanent sql-answer-table instead of a temporary one?

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

Article #22

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

#22

From: Geoff S. Wass
Date: Mon, 08 Feb 1999 00:00

14 lines
949 bytes

Thomas,

There is more than one way. SQL has a clause "SAVE TO" which allows you
to keep the output:  SELECT * FROM yourTable SAVE TO myTable

You can also use the updateSet.copy( ) property to ask dBASE to copy the
result set (rowset) for you.

--
Geoff Wass
Kuala Lumpur, Malaysia


=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=

Technical Details

Message-ID: <36BE546B.74D1B67D@ibm.net>

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

References: <36BE29D7.16FD9566@trautwein.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,10948d881a86ab50
X-Google-Attributes: gidff5a1,public
From: "Geoff S. Wass" <gswass@ibm.net>
Subject: Re: how to get permanent sql-answer-table instead of a temporary one?
Date: 1999/02/08
Message-ID: <36BE546B.74D1B67D@ibm.net>
X-Deja-AN: 442028311
Content-Transfer-Encoding: 7bit
References: <36BE29D7.16FD9566@trautwein.com>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
Organization: Noordindarus Consultancy Sdn. Bhd.
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message