Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Automatically generating a 'create table' command
Message
De
21/10/2004 13:19:10
 
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:
00953401
Vues:
12
You have not really told us much anout your system, but if what yuou want to do is create a lot of empty tables programmatically, here is what I used to do. I created empty tables with the correct structure, but with cryptic names, like xyz_addr, and added them to my exe-file. All I had to do to create the the tables, was two lines of code, 'USE xyz_addr' and 'Copy to clientaddr'. You can also include the cdx in the exe-feile, and issue 'Copy to clientaddr with cdx'.

Another solution is to include the empty tables in a binary memo field of a master table via 'Append memo', and use 'Copy memo' to get them out again. You can also do the same for cdx files and other files.

>Has anyone written a 'Create Table command' generation program that will create that command by evaluating a real table?
>
>If so, do you mind sharing? We have several large tables (many fields) that we want to start creating programmatically, and I don't want to manually build the entire 'CREATE TABLE' command.
>
>Thanks, Michael
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform