Dragan,

All of the application users have a network share called "H:\TMP" (it's created during the application installation). However, it is a different disk area for each user. The optimal solution is to ensure that this is the area actually used to store temporary tables. It is the folder mentioned in the CONFIG.FPW file. However, it doesn't appear that ALL workstations actually use this folder to store the temporary tables. Some workstations use another folder (for example, "C:\documents and settings\username\temp" or even "c:\temp"). I merely want to ensure that whatever temporary folder is being used is NOT the same disk area as another user. That is why I was interested to determine if I could set temporary table locations in code rather than in the CONFIG.FPW file.

Unfortunately, I can't really go in and change the TEMP settings for a workstation login script. That is out of my control.

Stephen

>>I have a VFP7 application that resides on a network server. Users have a desktop icon that points to the executable and runtimes.
>>
>>The application is also accessible through a Citrix metaframe client which means that someone can run the application without access to a local drive.
>>
>>There are numerous instances in the application where the user creates temporary tables. Even though there is a small performance penalty, I want to ensure that an individual's temporary cursors never occur in the same folder as another users. All users (both networked and Citrix) users have access to a private network share of "H:\TMP". I would like to set this as the default temporary file path for my application. I have the TMPFILES="H:\TMP" statement in the config.fpw file on the server, but I'm not sure that it's really working for all workstations.
>>
>>Is there a way to specify the TMPFILES path in code? I've searched the VFP docs and tried a bunch of things (all with various syntax errors).
>
>I've just checked where my Citrix creates temp files, without any config.fpw, and it's on the server's c:\docume~1\{username here}\temp\2. I've also created a cursor, and checked its dbf() - it's in the same directory. Getenv("TMP") gives the same directory. Since this type of directory is created by OS for each user, I think you can just leave it as is.
>
>If you really want to put them all into the same directory, you'd either need to create a config.fpw for your application (and include it in the exe), or set the TMP=H:\tmp in the login script, or both. Though, I'm not sure I'd put them all in the same place - there's a chance that somehow two users would try to create two files with the same name. It doesn't have to be the impossible "at the same microsecond", it's enough that one keeps his open, and the other tries to create it. So it's better to keep them in their private directories, IMO.