Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automatically generating a 'create table' command
Message
 
To
21/10/2004 10:46:29
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00953298
Message ID:
00953822
Views:
14
Thanks, everyone:

Here is what I was hoping to do:

I want to add the CREATE TABLE command to my code so that the tables get created at run time without requiring that one exists yet. I want to start doing that for all my temp tables that are used for imports, etc.

I can certainly manually write the CREATE TABLE commands for each of these tables, but what a pain, especially for some tables that have a ton of fields (one has 240 fields). Most of these tables already exsist, so I was hoping that someone had written a program that could examine the table structure and build the 'CREATE TABLE' command for me.

I can write it myself, I have written a program that will compare one free DBF against another and builds a program to correct the table that is missing fields using ALTER TABLE - I was just hoping someone out there in the great world of Universal Thread has already done this.

Thanks for all your advice,

Michael
Michael Meinberg
Tamtech, Inc

"The amount of things that I know nothing about is alarmingly increasing."
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform