Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Automatically generating a 'create table' command
Message
 
À
21/10/2004 10:46:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00953298
Message ID:
00953822
Vues:
15
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."
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform