Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GenTable
Message
From
01/08/2000 22:05:36
David Fluker
NGIT - Centers For Disease Control
Decatur, Georgia, United States
 
 
To
01/08/2000 06:20:53
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00399165
Message ID:
00399682
Views:
19
You have a lot of options given here, and I may be over simplifying, but two more things come to mind...

1. Use AFIELDS(aTable) to get the structure of an existing table and CREATE TABLE MyTable FROM ARRAY(aTable) to create the new table.

2. You can include an empty table with the structure and indexes you want in your exe and copy it to the user's hard drive. For example, to create a history table for each new account in a system. You include an empty table "Hist.dbf" with the index structure you want in the project. To create the empty history table for the simpson account you execute the following:
(cTableName is set to 'Simpson_History')
USE Hist IN 0
SELECT Hist
COPY TO (cTableName) WITH CDX
USE IN Hist
>I want to put a tables structure into a program so that I can create it elsewhere.
>
>Does anyone know of a program like GENDBC that will just generate the code for a single table, like EVIEW does for views.
>
>Thanks
>Kev
David.
Previous
Reply
Map
View

Click here to load this message in the networking platform