Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Automatically generating a 'create table' command
Message
From
21/10/2004 13:19:10
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00953298
Message ID:
00953401
Views:
11
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
Previous
Reply
Map
View

Click here to load this message in the networking platform