Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating databases from off-site
Message
From
12/04/2006 23:47:56
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
12/04/2006 14:36:06
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01113052
Message ID:
01113241
Views:
20
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform