"Creating a Table from an Existing Table" Problem.

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by X.F Yu Sat, 05 Feb 2000 00:00

#1312

Author: 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

Re: "Creating a Table from an Existing Table" Problem.

#1330

Author: Mark Cashman (TeamB)
Date: Fri, 25 Feb 2000 00:00

8 lines
875 bytes

What specific error message do you get?

------
Mark Cashman, TeamB C++ Builder
http://www.temporaldoorway.com/programming/index.htm
C++ Builder, JBuilder programming information
Home of The C++ Builder Programmer's Webring - Join us!
------

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads