>>>>Hi Renoir just create the text file with the extention vbs, you need to have WSH installed on the machine where you are going to run the file.
>>>>
>>>>>Ok, that is what I don't know. Where does this code reside? Is it just a text file with a ??? extension? How is it executed on the local machine? Sorry, this is new to me.
>>>>>
>>>>>Renoir
>>>
>>>Ok, now it's becomming more convoluted... I need to have WSH installed on the local machine? I guess I'm not seeing how using WSH is better way to load an application EXE than just using Foxpro code itself compiled in it's own EXE. How do I ensure WSH is installed on all the hundreds of PCs involved in an update? Do I need to include code that installs WSH? How does the VBS file execute? Is it automatically done when it is first detected on the hard drive of the local machine? Do you realize now how much I don't know about this?
>>>
>>>I need an Ed Rauh type of explanation for this. (That's a compliment Ed if you're lurking.)
>>>
>>
>>FWIW, it's
Title: Re: Updating EXE and Data Without Disruption Thread #590579 Message #590605>
>Ed,
>
>Do I detect sarcasm?
>
>I read your post to me and knowing that the place I'm at (state government) won't spring for a site version of Stonefield, was trying to find the best way to use what you said. I found George's FAQ regarding WSH and was trying to understand how to implement this.
>
>Sorry Ed, we're not all Yale doctors of computer science...
>
>If I missed the spirit of your post(s) I apologize.
You don't need SDT; I use that only to handle the database container and table update aspects of the uodate app. I do discuss the use of the WSH loader, what's needed, and why it's a better choice than a loader written in, say, VFP, since WSH is available in a self-installing form, and doesn't need it's runtime in place before you can use it to put it's runtime in place.
As for working for a state agency, the logic still escapes me why you wouldn't buy SDT. It's licensed on a per-developer using it basis - for me, that meant a one-time expense of $299, and I can use it's runtime components in every app I write on a royalty-free basis. Duplicating the functionality would take hundreds if not thousands of man-hours, so it'd be an easy item to cost justify, especially since it drastically reduces the cost of update and routine maintenance, as well as replacing some of the more onerous and dangerous maintenance functions with better, more reliable ones. That's my belief; I scrapped what I'd written, representing a couple of hundred hours of work, years ago to switch to SDT and have never looked back.
SDT is not essential to the loader, just to my philosophy of applying structural changes to the DBC and tables on the fly. You could always spend a year or two writing the equivalent code if $299 is too much to get through the budget.
>
>Renoir