>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 :).