Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alter Table
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00839425
Message ID:
00839457
Views:
15
Hi, Bill.

>Putting the call into the Load method worked just fine. I thought the Init method fired before the Load method, but I guess not.

Remember the mnemonic keyword LISA. This stands for Load - Init - Show - Activate, and this is the order in wich things happens. Of course, Show is a method, not an event, but the S is to indicate that Activate happens after you issue Show (is you do).

>I built the Alter Table function for the situation where you have an existing system distributed to many clients and you need to add (or alter) one or more fields in a table for a new release. The only alternetives are to buy expensive 3rd party software or build a conversion utility program for the client to run before installing the new version.

I think the small utility to run after installation is a better approach, as performing an ALTER TABLE needs exclusive access to the table involved, and this would be problematic in a multiuser environment.

Hope this helps,
Previous
Reply
Map
View

Click here to load this message in the networking platform