>I am trying to redirect tempfiles from C to D drive, where I have much more space.
>I put following line into CONFIG.FPW:
>TMPFILES=d:\TEMPFILES
>But GetEnv('temp') still shows C:\WINDOWS\TEMP and my query fails because of space.
>
>What I am missing?
>TIA
>Oleg
Oleg,
With tmpfiles usage, it's not necessary to add path and actually it's ignored :
tmpfiles = d:\mydir1
tmpfiles = d:\mydir2
tmpfiles = d:\mydir3
All point to just drive d:. If you also want directory to be significiant the you should use :
editwork = d:\tempfiles
progwork = d:\tempfiles
sortwork = d:\tempfiles
OTOH getenv("temp") is not the same thing as your "temp". It's OS "temp" directory and it would again be "C:\WINDOWS\TEMP" in your case.
You could check like this :
select * from sometable into cursor myCursor nofilter
? dbf("myCursor") && This would be in your temp directory
Cetin