If these processes do not really depend on the environment established by your JobControl program, you could create this as a new EXE that does load a CONFIG.FPW file. You would have to call this new EXE from JobControl with a RUN /N SORT.EXE parm1, parm2, etc...

If settings like SORTWORK, TMPFILES, etc., are not specified in CONFIG.FPW, what will be used is what is returned by SYS(2023). If not there, then it probably would put all these temp files in the same folder as the main program. Unless someone from MS tunes in here, there is no other known way to temporarily redirect this.

>Hi everybody,
>
>Seems like my first question led to a dead end :(
>
>Also I'm not convinced, that ALTER TABLE command creates temp files in TMPFILES directory (specified in config.fpw). The error message, I got, indicated, that it was trying to create temp file on the network drive.
>
>INDEX ON command seems to put their internals under SORTWORK path according to Help file.
>
>I have a problem. I need to run ALTER TABLE and INDEX ON commands on huge VFP tables (about 5mln. recs). I want to check for free space prior to running these commands.
>
>So, where should I check for the free space?
>
>How much space would I need?
>
>How can I re-direct VFP internal temp files to some temp directory and then re-direct it back?
>
>Can somebody from MS help me with these questions?
>
> Some specifics about our environment:
>
> We're running .app applications from the Network drive. All databases reside on the same Network drive. Each user has VFP installed. Main application, called JobControl, calls all other applications.