Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alter Table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
00839425
Message ID:
00839457
Vues:
16
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,
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform