Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View set identity_insert on
Message
 
To
16/10/2003 12:31:00
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00839334
Message ID:
00839360
Views:
26
1. EASIER- i have a generic method that makes a create table statement ( it's actually a rip-off of gendbc.prg with mods for sql server ). to do the alter takes more work. i can do the work, but i don't feel the need when i have a nice way to do it.
2. COLUMN ORDER- i don't usually want my new columns at the end of the table. alter table can't get the new columns in where i want them. plus, my application depends on the columns being in the proper location because my application dynamically creates all my edit forms based on the table structure.

Make sense?

DB
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform