"Creating a Table from an Existing Table" Problem.

Article View: borland.public.cppbuilder.database.multi-tier

Article #1312

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#1312

From: X.F Yu
Date: Sat, 05 Feb 2000 00:00

16 lines
1173 bytes

I use BCB4 for database programming,Can I create a table from an existing
table which is a desktop detabase like Foxpro or DBase?
I want to select the data out of a table for temporary modification.and
sometimes you have to create a table similar to the existing table and fill
it with similar data.
I know like Oracle can surport like this:
CREATE TABLE NEW_TABLE(FIELD1, FIELD2, FIELD3)
AS (SELECT FIELD1, FIELD2, FIELD3
   FROM OLD_TABLE <WHERE...>
But for my Foxpro or DBbase database there is always a error message arised.

Your kindly help will appreciated.

Thanks.

X.F Yu

Technical Details

Message-ID: <87ha7t$69g3@bornews.borland.com>

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

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,f49b569b31df484,start
X-Google-Attributes: gidfcd2b,public
From: "X.F Yu" <helencn@public.tpt.tj.cn>
Subject: "Creating a Table from an Existing Table" Problem.
Date: 2000/02/05
Message-ID: <87ha7t$69g3@bornews.borland.com>
X-Deja-AN: 581912321
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200
Organization: Another Netscape Collabra Server User
X-MSMail-Priority: Normal
Reply-To: "X.F Yu" <helencn@public.tpt.tj.cn>
Newsgroups: borland.public.cppbuilder.database.multi-tier