Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Dynamicly updateing table structures
Message
From
20/07/1998 12:10:33
 
 
To
20/07/1998 09:40:59
Rob Gordon
Xon Digital Communications Ltd.
Dartmouth, Nova Scotia, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00118850
Message ID:
00119290
Views:
21
>It's pretty simple .. On startup, check if the fields to be added/modified are present in the table (AFIELDS will do). If they're missing , use the ALTER TABLE command to change the tables in question.

Thanks very much. I am checking it out now.
Clearly though I will not be able to be as "lazy" as I was in 2.6 and I will have to keep track of my changes. I will also have to make sure I only run the update appropriate to the version installed at the time. Using the blank table - append from method of 2.6 I didn't need to know the version of the old data. 2.6 took care of it for me.
It is impossible to make programs idiot proof. Idiots are too cleaver.

MCP( Tcp/Ip )
Previous
Reply
Map
View

Click here to load this message in the networking platform