Re: Select to a new table

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

Article #457

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

#457

From: Geoff S. Wass
Date: Sun, 22 Nov 1998 00:00

24 lines
1253 bytes

Todd & Greg,

If you are using VdB 5.x, this /may/ not work as planned (bug). Instead
you may have to break it into 2 steps:

SELECT * FROM yourTable
COPY TO newTable
&& or COPY TO newTable WITH PRODUCTION to keep indexes

Try it as one command and if it fails to work, try this. If you are
using VdB 7.01 you can ignore this message.

--
Geoff Wass
Kuala Lumpur, Malaysia


== In news groups use a reply (not e-mail) so all can help and learn!
==
== Report Inprise/Borland bugs...
== http://www.inprise.com/devsupport/bugs/bug_reports.html
== dBASE Archives http://forumsearch.borland.com:88/
== or http://www.dejanews.com
== Alan Katz's Visual dBASE Magazine http://www.ksoftinc.com/vdb/

Technical Details

Message-ID: <365809BD.52B82719@ibm.net>

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

References: <365398B2.4EC0@aol.com> <730bpb$pur11@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,2a2f73a4e301b4fe
X-Google-Attributes: gidff5a1,public
From: "Geoff S. Wass" <gswass@ibm.net>
Subject: Re: Select to a new table
Date: 1998/11/22
Message-ID: <365809BD.52B82719@ibm.net>
X-Deja-AN: 414476673
Content-Transfer-Encoding: 7bit
References: <365398B2.4EC0@aol.com> <730bpb$pur11@forums.borland.com>
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