Article View: borland.public.cppbuilder.database.multi-tier
Article #1110Re: "Creating a Table from an Existing Table" Problem.
From: Jun Pan
Date: Wed, 26 Apr 2000 00:00
Date: Wed, 26 Apr 2000 00:00
22 lines
1424 bytes
1424 bytes
What you can do is, you can go into Database Desktop create a new table select borrow from and you select the table that you want to borrow from. I think this is what you want to do. "X.F Yu" wrote: > 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:
<3907386A.4E79826C@earthlink.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<87ha7t$69g3@bornews.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,f49b569b31df484 X-Google-Attributes: gidfcd2b,public From: Jun Pan <junpan@earthlink.net> Subject: Re: "Creating a Table from an Existing Table" Problem. Date: 2000/04/26 Message-ID: <3907386A.4E79826C@earthlink.net> X-Deja-AN: 616018061 Content-Transfer-Encoding: 7bit References: <87ha7t$69g3@bornews.borland.com> X-Accept-Language: en Content-Type: text/plain; charset=us-ascii X-Trace: 26 Apr 2000 11:32:34 -0800, 208.223.214.225 MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.multi-tier