sqlacces.txt

c#设计模式WithCla

SQL Code Generation Script to generate SQL tables for import into Microsoft Access
These scripts are "getting started" scripts that must be updated for your development environment.

1. Use Shlaer Mellor Methodology with arrow heads for 1:1, 1:M, and M:M

2. Create a class with all SQL data types, e.g. name TEXT, age LONG to update wc2.ini

3. Enter attribute size e.g. (10) in ATTRIBUTE_USER1 text box

4. Check Index, Unique, Not Null, Primary Key, and Foreign Key as appropriate

5. Select "Utilities - Generate Class Code/Report", enter a file name, e.g SQLRPT.TXT and 
select SQLACCES.SCT script.  This script assumes you will have at least one index,
e.g. PRIMARY KEY.  If you don't have an index, you will have to delete the last
comma.

6. Place other SQL statements into CLASS_USER1, CLASS_USER2, and CLASS_USER3.

6. Select "File Edit File" to open SQLRPT.TXT

7. Select and copy all the SQL statements for a single table 

8. In Microsoft Access, select Query New, then SQL or SQL - Data Definition, then paste 
the SQL statements for a single table, then Save.  If necessary correct any syntax errors. 

9. In Microsoft Access, select Query Open to create the table

10. Repeat the cut and paste for all tables.  

Problems: 1) Access 2.0 does not let you create multiple tables in one 
query.  2) I have not been able to create a foreign key using SQL.
The following SQL statement may be modified to create a foreign key:
CONSTRAINT customerFK REFERENCES Customer,

Please send script improvements to MicroGold [e-mail] 
   info Richard Felsinger [e-mail]  803-881-3648