Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updating databases from off-site
Message
De
12/04/2006 23:47:56
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
12/04/2006 14:36:06
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01113052
Message ID:
01113241
Vues:
19
>Thanks for the tip, and while I'm sure it's a fine product, is there another way this can be done without spending $349? :) I've got no problem with spending money, but getting the boss to do it is...well, not easy.
>
>Is there a way for me to make modifications here and email the appropriate files to the plant reflecting the new structure of the database? Just based on what is included with VFP (I'm on 6.0) itself? If so, what files need to be sent?

I usually script things like this:
use TableWhichIChanged
if type("newfieldIJustNeedToAdd")="U"
   alter table TableWhichIChanged add column newfieldIJustNeedToAdd c(20)
endif
...
if tagno("MyNewTag")=0
   index on newfieldIJustNeedToAdd tag MyNewTag
endif
Of course I've got this automated somewhat, but that's basically it. I'm doing this because there's no way I could get SDT, unless I forked out from my own pocket :).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform