>>You could change this in your Config.FPW file.
>I do this already to have my separate disk used as temp, but that gives me only 1 location.
>
>>I doubt you want some cursors to be created somewhere, but others to be created somewhere else.
>Doubting is my job - see my first name<g>. I would like to have a collection of temp sites and be able to specify which one to use. Even better (in case no hints are in the code) if a large select from cursor on E:\Temp is done, put it into F:\Temp.
Well you can do that with select into table, but then you've taken the housekeeping on yourself. I'd probably write a collection class which would give you a random filename in the least busy location, and then it'd be a matter of telling it to remove a file from the collection once I don't need it. Removing would also kill the physical file and any associated indexes and/or memo files.